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

  • 0
    SUGGESTED

    Run the Rebuild Sort Files utility for the PO module and click Yes to the prompt.  Sometimes the value gets out of synch, and that should fix it.

  • 0 in reply to Kevin M

    Thank you, Kevin - I'm little worried about data mess up. Will try in Test environment and get back to you. Appreciate your response Slight smile

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

  • 0 in reply to Kevin M

    Kevin, Yesterday we ran our Rebuild Sort file , Modules SO PO & Inventory Management and  the issue got fixed - Thank you guiding me Slight smile

  • 0 in reply to BigLouie

    Louie, Will follow your suggestion Slight smile of running the file once a month along with Inventory 

  • 0

    Can this "out of sync" issue happen when using the "Multiple PO's" feature during Receipt of Goods in PO Module? We keep having to rebuild the sort files everytime we do a receipt of goods that has multiple PO's being received. It will update (reduce) the quantities of "ON PO" column but ONLY by the "Primary" PO's quantity that we received against.

    All the other quantities of that same item, but received against the "non-primary" PO#'s during that receipt entry do NOT get updated in the Quantities Detail Window of I/M Module, Item Maintenance Window, Main Tab.

    It is consistently happening during "Multiple PO's" receipts for all inventory items. Very frustrating. (the 7. Orders Tab shows the correct quantities remaining on PO's but still, having to rebuild the sort files after-hours when everyone is out of sage and batches are closed is getting very annoying and impacting others to get their tasks completed in Sage100.)

    We're in Sage100 Advanced 2021, v. 7.00.4.0, 32-bit. *We have the DSD Multi-Currency Module installed and these PO's are received in YEN (JPY) Currency.