Inventory Reconcile Cannot Be Run While Users Are Posting Invoices

Microsoft Dynamics GPIf you try to run the Inventory Reconcile utility ((Inventory area page » Utilities » Reconcile)) when users are posting invoices, the following error message will be displayed (the same message will be displayed during a Year-End Close):

You cannot complete this process while invoices are being posted

You cannot complete this process while invoices are being posted

If users are not posting invoices, this KB article shows all of the tables which need to be cleared down.

This came up for a client recently. The above KB article requires all users to be out of the system to clear the tables down. In the middle of the working day we wanted to avoid this if we could; so we checked the Batch Activity (SY00800) table and were able to identify the user locking the process and get them to log out.

Leaving the Dex… tables alone we then tried the Reconcile utility again and found it worked fine. In many cases, all three tables will need to be cleared, but sometimes just the SY table will be sufficient.