You’re offline. This is a read only version of the page.
1,890
With respect to running an Inventory Reconcile for a customer with a very large Inventory file - that is too big to complete in an overnight run, we have been trying to understand how the Reconcile goes about its work.
We are running it without reconciling Inventory History.
We have broken the runs down to do set ranges of items - to try to understand the best way to break up the reconcile into several runs.
We timed the progress bar on a full run to 2% and then forecast that 10% of the whole file run would take 4 hours.
But if we took an item range that totalled 10% of the overall Item Codes and ran that range, it only took some 2 hours to run.
So can anyone tell me how it does its work? Is it based on the number of transactions related to each given Item?
Does the reconcile search the open transactions in the SOP Sales Orders/Invoices file etc, the Purchase Orders files and the Inventory Files – and if it finds the item, it will cross check the respective transactions and quantities and then update the correct allocated and on-hand amounts (etc)?
*This post is locked for comments
As for your differences in timing calculation, the time to run is based on a number of factors, one of which is the number of transactions for the items selected. It's like Microsoft Time on a file copy, hard to accurately project.
I recommend using Frank's sequence of reconciles (as it is also in our Maintaining GP book in that order) and using the PSTL reconcile.
This is the order in which Reconcile should be run, based on the modules you are using:
1. Sales Order Processing
2. Purchase Order Processing
3. Inventory
4. Project Accounting (if used)
5. Field Service (if used)
Running Reconcile in this order is important because of the interaction between the modules affecting Item Quantities. Running Reconcile in a different order can result in incorrect Item Allocation Quantities.
The illustration mentioned above includes the supply chain in details. As shown in step (4), quantities in Sales Amount work will be calculated to update the allocated quantity in IV00102.
Although, this reconciliation will not result with any corrections of any corrupted sales documents. If this is the case, start with Sales then IV reconcile.
I have previously provided an outline for the Inventory Reconciliation Flow, it is illustrated in my post below;
You could try the PSTL Item Reconciler, which could be much more efficient in terms of times to be completed, since this feature runs only on items that needs to be reconciled. Otherwise, they are basically the same in functionality.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (