If you try to run the Inventory Reconcile utility (( )) 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
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 t 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.
This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect.
I was somewhat surprised that the most recent version available was the 2011 version; I think this shows that Node Builder is not a very popular product, but I am slightly surprised by this as SmartConnect seems to be a popular choice for integrations. I have manually written eConnect stored procedures for new nodes and Node Builder is an easier and quicker way of creating the nodes.
I assume though that people are generally either creating the stored procedures manually or are doing direct updates to the database. If this is the case, then it would seem that the people mainly using SmartConnect are more technical users.
It does not need to be this way and, for a lot of the SmartConnect projects I’ve had a hand in delivering, it hasn’t been this way as we have installed and configured SmartConnect and then trained users on creating and maintaining integrations.
Node Builder compliments this approach by allowing non-technical users to create new nodes as required rather than needing a SQL develop with experience of Microsoft Dynamics GP and eConnect.
I’ll do a series in a few weeks on using Node Builder to create a node for use with SmartConnect.