Quantities are incorrect for PO, SO or WO in Item Maintenance and Item Inquiry
Description
Enhancement Request submitted defect 107966 to Automate or Schedule Rebuild sorts task. Also see and vote on Sage City, Ideas site for Automatically run rebuild sort files posts.
Cause


Resolution
[BCB:1:Backup warning:ECB]

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

  1. Open Modules, Library Master, Utilities, Rebuild 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.


DocLink: How to Rebuild Sort Files
DocLink: Quantities in Inventory Maintenance or Inquiry are not correct
DocLink: On Backorder quantity does not match the Orders tab in Item Maintenance
DocLink: The quantity On PO is not reflecting the correct open purchase order quantity
DocLink: Qty On PO is incorrectly calculated when using Rebuild Sort Files
DocLink: Item Inquiry On SO quantity does not match the Orders tab total quantity

[BCB:155:Chat 100 US:ECB]

Steps to duplicate
Related Solutions