When the reconcile is run and manufacturing has been installed, there are three reports which the user will be prompted to print. Let me talk through these reports as a way of explaining the processing.

1. When manufacturing is loaded, the allocated quantity for items is set to zero.
2. The first report is the Inventory Reconcile Report. Prior to the printing of the report, the system does the basic inventory reconcile. This includes verifying the allocated and on hand quantities within the core Great Plains application. The report should show the allocated quantities being increased from zero to the appropriate quantity to reflect the transactions within core Great Plains (modules such as Inventory, Sales Order Processing, and Purchase Order Processing would have an effect).
3. The second report is the Picklist Reconcile Inventory Allocation Report. After the reconcile completes in the core, it switches to the additional code provided by the manufacturing series. The pick documents are read and the allocated quantity from manufacturing is used to adjust (increase) the allocations for each item.
4. The third report is the Picklist Reconcile Report. There are a few different tables used to store the pick documents in manufacturing. The records in these tables are compared and based upon the differences, the tables may be adjusted to ensure accuracy. This process may result in a change to the quantity issued for a particular MO.

My suggestion would be to reconcile a smaller group of items at one time an compare. For example, run it for item that begin with A-D, compare reports, run it for item that begin with E-G, compare the reports.

Inventory reconcile when manufacturing is present needs to be more streamline, the process should happen all at once rather than having to manually reconcile 3 different reports
Needs Votes