Product Purchase Cost Value Varying from that Configured

Premium_Petware

Hi there, we are having issues with some products where the product cost has started varying. 

 

For example (file attached), this product cost increased Mid april from $92.50 to $97.50 . The first 5 transactions correctly process at $97.50, then on 08/06/21 there is a wobble with one the product cost dropping to $65.60 and the next jumping to $117.00.

 

It them comes right again until we get a back order on 26/10/21, then it all get screwed up from there.

 

Any suggestions on how to resolve this? I have tried recreating the errant transactions but hasn't helped.

Product Cost Issue.png

gavin12345

Hi @Premium_Petware 

 

There are lots of anomalies (AKA bugs) in the Inventory module of AR2022. 

 

One thing to be aware of is this while the list displayed is in date order, the transactions were not entered in this order.  When a Sale transaction is processed, MYOB uses (or is meant to use) the average cost as it was at the time of that transaction. If you later amend an earlier transaction or enter a Purchase with an earlier date, this does not change the COGS for the Sale as this has already been set, however it will affect new transactions.

 

The current average cost based on the Items Register is $65.95, so if you try to re-do or re-create a transaction, this is the cost that will be used. You should do an Inventory Adjustment Journal to set the correct cost, then redo the errant transaction .

 

Regards

Gavin