Forum Discussion

Premium_Petware's avatar
3 years ago

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
    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