Troubleshooting Average Cost Errors

SOLVED

Hello, I noticed that a lot of my items have average costs that are way higher than the Most Recent or Last Cost. I know that I can make an inventory adjustment to bring it in line, but I'm wondering where I would look to troubleshoot why they are all calculating so strangely (input error?) Any help would be greatly appreciated.

Thanks,
David

Parents
  • verified answer

    Hi David - The Inventory Movement report is an excellent place to start.  This will provide a transaction-by-transaction account of an item's cost history.  After each listed transaction, you can calculate the unit cost by dividing the cost by the qty.  A common issue in these situations is a scenario such as:
    1. PO is issues for item x @ $100
    2. Item is received @ $100
    3. Supplier invoice is entered against the receipt @ $120

    This will create an invoice adjustment that would appear on the Inventory Movement report.

  • Thank you so much, this was exactly what I needed. I was able to identify all the transactions where the cost was off. It showed that when transfers were being made between warehouses it would transfer the product at CASE price for EACH bag inside the CASE even though the request and transfer units matched. Very strange.

    So each case of 30 bags was costing $60x30 instead of $2.00x30 every time a transfer was made.

    Thank you for your help.
    David

Reply Children