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 Reply Children
  • It looks like the conversions are all correct. I'm noticing that the Unit Cost is jumping dramatically between the Order Entry and the Shipping Entry. Is there some reason that would happen?

  • 0 in reply to David @ Happy Veggie World

    The costs in order entry are based on the most recent cost (fairly certain) and not a reflection of true costs once product comes in.  Example would be if you entered an item that is not is stock.  it will still show you a cost.  But that cost can be totally different by the time you bring in new stock.  The true costs will be reflected on the OE Invoice after a day end.

    I find it easier to just use Transaction History Inquiry to see what is happening with receipts and any additional costs, or if some user did an IC Adjustment such as a QTY change instead of a BOTH increase/decrease.  That will screw your costs pretty quickly too.