Forum Discussion

Premium_Petware's avatar
Premium_Petware
User
3 years ago
Solved

Product Purchase Cost Value Varying from that Configured

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...
  • gavin12345's avatar
    gavin12345
    3 years ago

    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

     

gavin12345's avatar
gavin12345
Ultimate User

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

 

Premium_Petware's avatar
Premium_Petware
User
3 years ago

Thanks for the advice Gavin. I added a ridiculous number of items to get the average price correct and was able to update the affected transactions, and removed the added items,

 

Much appreciated.

 

Cheers,

 

Blair