On Order Quantity in Inventory after Purchase Order Table Import

TechKnowledge Content

Question: 
When using Import Utility to bring in Purchase Orders, the On Order quantity on the Item Quantities Maintenance screen (Cards – Inventory – Quantities/Sites) is not being updated. How does this field become populated? 

Answer: 
After the import of the Purchase Orders you need to do the following steps to update the On Order quantity on the Item Quantities Maintenance screen. If your database is SQL, make a backup of the Company database, otherwise make a backup of the Purchasing and Inventory folders before performing the following steps. 

1. Reconcile Purchase Order (Utilities - Purchasing - Reconcile PO) 

2. Reconcile Inventory (Utilities - Inventory - Reconcile) 

The reconcile Inventory process will print a report telling you that the On Order Quantity has been updated. 

This article was TechKnowledge Document ID: 18415
Properties

Article ID: 850311 - Last Review: 15 Feb 2017 - Revision: 1

Microsoft Dynamics GP 9.0, System Manager

Feedback