Share
ReportIt 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’re offline. This is a read only version of the page.
6,775
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
The most common article of Dynamics GP,
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!!!
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.
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.
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.
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
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.
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.
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?
You have unposted invoices sitting in sales batches. You will need to post those invoices.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (