Project Issue & Return at different cost prices - Bug

Morning all,

Hoping someone can shed some light and help me on this issue as soon as possible.

I searched and found an idea posted in the Ideas forum about project costing when using Stock issues/returns

But this looks more like a bug rather than a idea that has to be requested for change:

My scenario is below:

A Stock Issue was made to a project as normal, [Stock Control >> Issues >> Project Issue
-> User noticed they entered the wrong qty
-> so almost immediately created a Stock Return to the same product & details to same project  [Stock Control >> Returns >> Project Return]

In the 20 seconds between the issue and return there was no movement, stock adjustments, revaluations, goods booked in or out etc.

Outcome:
Yet the cost prices posted to the project are completely different,

Same issue happened once a few months back but the value was only minimal a few £, but on this case the value is approx. £20,000

Anyone any ideas if there is a workaround or fix on this, or what way would be best to handle correcting the costs on the project itself.

Thanks,
Paul

  • 0

    Hi Paul, the same problem exists in other parts of stock control too. If I write off an item and then instantly rediscover it the write off value will follow the costing methodology but the (re)discovered item will always populate with average buying price. It can be overridden but this relies on you knowing the correct value to use. Or in your case the project return. 

    If you haven't populated average buying price (in amend stock item) and if the stock item is new (ie no average has yet been calculated) then you can even apply a zero average buying price.

    Rather than applying average buy price as default would a better approach (for Sage to improve the system) is for the user carrying out a stock adjustment in (be it project or other) to be presented with a grid of past issue prices (including the option of the average buy price) and one of those can be selected or a different value used?

  • 0 in reply to JohnChinery

    Hi John,

    Thanks for the reply,

    If I pick one stock item:
    The stock item is setup as FIFO so the Average cost is calculated automatically. but I don't see where you can override the price at point of entering the issue or return.


    The puzzling part about this is the cost prices used in the two transactions..

    The average cost price of the stock code is £437
    Yet the unit cost price used on the issue and return is 
    Issue -> 82 x £335 = £27,470
    Return -> 82 x £519 = £42,558
    Difference of approx £15K

    confused.com

    I need to figure out how to adjust the cost of the project.

    Cheers,
    Paul

  • 0

    Ended up using a Project Cost Adjustment against the Project and the relevant stock Nominal account to correct both the cost on the project and the cost of the stock value on the Nominal,

    But this really needs to be flagged as a bug as its double work trying to keep an eye on these cost differences