Skip to main content
All CollectionsItemsCommonly asked questions
Why do AGR stock and ERP stock not match?
Why do AGR stock and ERP stock not match?
Updated over 3 months ago

There can be a number of reasons why the stock in AGR does not match the stock in the ERP:

  • This could be due to a stock transaction that has been posted to the Item Ledger Entry table (BC) or appropriate transaction table for your ERP since midnight. AGR takes a snapshot of the data at that point, so if e.g. a purchase order was receipted after the snapshot was taken, it will show in the stock the next time AGR updates data (tomorrow).

NOTE
In this case, the quantity will show as Undelivered in AGR, and therefore order calculations and Estimated Stock would show the same results, as they consider both Stock Qty and Undelivered

  • Is the ERP stock considering the same location(s) as AGR? You can see which locations AGR is considering in the Locations section of the ERP Settings, accessed via the Navigation bar:

For BC/NAV ERPs, if an Item number is changed, it can cause discrepancies in the Item Ledger Entry table and therefore cause incorrect stock quantities to be presented in AGR

Did this answer your question?