It is saying that you can’t run the process while invoices are being posted. Users are logged in but no one is processing invoices.
*This post is locked for comments
You have unposted invoices sitting in sales batches. You will need to post those invoices.
What if none of those sales orders have the item in question listed as line items/allocated? Do those invoices still need to be posted?
Good question. I have never tested that. I would guess not. I think it just looks for unposted invoices and not items on those invoices.
I have never tested that as well, but I would assume that the result "would" be the same since the posting process is one of the processes that "Reconcile" checks as a prerequisites in order to ensure that the starting point for the process (calculating quantity on hand, checking purchase receipt details ...etc) should ensure totally fixed and precise values.
Therefore, reconciliation prevents any transaction posting (related to Inventory Module) until the process is totally completed, and the report is printed.
Mr. Richard
Regarding the error above "You cannot complete this process while invoices are being posted.", in case none of the users is posting any transaction that is related to the inventory module, wouldn't having one the associated transaction windows "for instance, Sales Transaction Entry Window" open stop the item reconciliation from processing ? Since there are open sessions in locked records in the following tables:
How would the reconciliation process be stopped by having unposted invoices?
I do believe that even if you have unposted invoices in the Sales Module for instance, the reconciliation would still process unless one of these document is being posted or having one of the associated windows open. Right ?
Would appreciate your illustration
Run the reconcile just for that item - not all items.
If you still get the issue - run the techknowledge for stuck batches:
Sample here: dynamicsgp.wordpress.com/.../batch-stuck-in-posting-receiving-busy-etc-etc
Make double sure everyone is out of GP - then, Just run the two sets of 5 queries.
And then re run the reconciliation for just one item.
Let us know if that resolves.
Ian.
Mahmoud, I may need to stand corrected here. Upon further search, I came across this.
You don't need everyone logged out. The system checks the DYNAMICS..SY00800 table for specific transaction entry windows (pop, iv, sop, etc.). If those windows are closed, reconcile will run. Users who try to open a trx window during reconcile will get a message that says something about another user is running a process that must be completed. At least, that's how it works in GP2010 at our office. I still think it's better to run it with users out of the system.
Hi Ian,
I am encountering this issue while closing out some inventory items even though they are showing in our Location. Those items show-up in the Serial # in GP as in our site, but cannot be transacted due to “Insufficient Quantities”. I got the same error message when I try Reconcile 1 item.
How do I know whether there is a stucked batch when running the script below?
"UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’XXX’
(Where ‘XXX’ is the batch ID of the batch that is stuck in posting / Reeiving / Busy / Marked etc.)
Thanks in advance for your advice.
Make sure all the users have logged of from GP and run the below query to identify the stuck Batch IDs.
SELECT BACHNUMB,MKDTOPST,BCHSTTUS FROM SY00500 WHERE MKDTOPST<> 0 AND BCHSTTUS <> 0
If above query returns any of result, run the below query with user of the Batch Number returned from above query to update the batch status for stuck Batches.
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’XXX’
Hope this helps!!!
The most common article of Dynamics GP,
A batch is held in the Posting, Receiving, Busy, Marked, Locked, or Edited status in Microsoft Dynamics GP
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
