Date: 2-OCT-2024
Keywords: Reconcile Inventory Quantities, Speed
If you have a lot of Item Numbers and/or Location Codes it creates an enormous number of Item-Site combinations, all of which combine to give the Inventory Reconcile process a lot to do! Running Inventory Reconcile may take many tens of hours. It may take days. Perhaps it takes so long that you only run it over holidays.
There is a relatively simply way to make it run 5x faster. In true social media style, this is definitely a “hack”. While we have tested this and it does work, you may have other modules installed in your system or other unique characteristics that could cause this trick to not work. Please be sure to trial it in a test company before running it on your live data.
When you click the PROCESS button on Reconcile Inventory Quantities the Inventory Reconcile routine adds an activity record in DYNAMICS..SY00800. If you have Manufacturing installed it also adds “locks” in the company database MOP10223. If you attempt to start another IV Reconcile process from a second GP client it is these activity records which prevent it.
How do you make IV Reconcile run 5x faster? Run it simultaneously on five GP clients!
Divide and conquer. Figure out how to divide your inventory into equal sized groups, such as A-K and L-Z (this would not actually work because it would miss everything after “K” such as “KA”, but you get the idea). Technically A-K and K-Z would only overlap on a single Item Number “K”.
Log into the first GP and start IV Reconcile on the first range of items. Then delete the Reconcile record from SY00800 and everything from MOP10223. Note that MOP10223 holds MO locks for other parts of Manufacturing, such as MO Entry, so clearing this table should only done when you know that users are not going to be working in Manufacturing.
Now start IV Reconcile on a second GP client. Clear the tables again if you are going to start a third processor. This process can be repeated as many times as you like. Do NOT delete the records after starting the last processor.
Most of the “work” of the reconcile process is performed within the GP client so this procedure splits the workload allowing you to run IV Reconcile more quickly on a given range of items, or to get through more items in the same amount of time.