Quantities are incorrect for PO, SO or WO in Item Maintenance and Item Inquiry in Sage 100

Summary

In Inventory Management, On Purchase Order (On PO), On Sales Order (On SO), or On Work Order (On WO), quantities are not correct.

Resolution

Rebuild sort files for the Inventory module and the individual modules with incorrect quantities.

  1. Open ModulesLibrary MasterUtilitiesRebuild Sort Files.
  2. Review the warning, and click OK.
  3. From the Rebuild Sort Files window, select an application from the Module field, and a Company Code from the Company field.
    • Select the module where the column is incorrect. For example, On SO is wrong select Sales Order (see below).
  4. Click Proceed, and select responses to the questions pertaining to certain modules (see below).
  5. Close the Rebuild Sort Files window.

______________________
Purchase Order:

In response to the question, “Would you like to recalculate open purchase order quantities in the inventory masterfile also?”

  • click Yes to recalculate the On PO quantity in Inventory Maintenance/Inquirybased on the open orders in the Purchase Order entry files.

Sales Order:

In response to the question, “Do you want to recalculate open sales order quantities in the Inventory masterfile also?”

  • click Yes to recalculate the On SO quantity in Inventory Maintenance/Inquiry based on the open orders in the Sales Order entry files.

Work Order:

In response to the question, “Do you want to recalculate Open Work Order Quantities in the Inventory Masterfile also?”

  • click Yes to recalculate the On WO quantity in Inventory Maintenance/Inquiry based on the open orders in the Work Order entry files.