Open PO Qty vs On PO qty discrepancy

SUGGESTED

Hello All,

We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty.

SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts

In the below example, in main I m seeing a open PO qty but in the orders, it is fully received

p.s : Checked with accounting and that PO is closed

Parents
  • 0
    SUGGESTED

    What you see in the white box is based on sort files for quick display. Some times these tables get out of sync from the detail tables for various reasons. The sort files are just used for display purposes so rebuilding them will not change the details tables except for the Inventory Sort rebuild which will clear the Qty Committed field which is why you should only run the Inventory Sort Rebuild when there are NO open batches in Sales Order.  

    Generally I rebuild all sorts after doing month end close others need to do it once a week.

Reply
  • 0
    SUGGESTED

    What you see in the white box is based on sort files for quick display. Some times these tables get out of sync from the detail tables for various reasons. The sort files are just used for display purposes so rebuilding them will not change the details tables except for the Inventory Sort rebuild which will clear the Qty Committed field which is why you should only run the Inventory Sort Rebuild when there are NO open batches in Sales Order.  

    Generally I rebuild all sorts after doing month end close others need to do it once a week.

Children