Trying to open a document in SOP and you get told the following? Your previous transaction-level posting session has not finished processing. Please allow time for it to finish. Second most asked question in support…this occurs when posting routines were interrupted for some reason.
-
Back up your Dynamics and company databases.
-
Note down the GP user ID of the session that is getting the error message. Then get everyone out of GP.
-
Go to MSSQL and open a new query window. Run the following query: Delete dynamics..sy00800
-
Run the following queries against the Company database
-
SELECT * from SY00500 where BACHNUMB = ”
-
If this query returns any rows, then run: Delete SY00500 where bachnumb = ”
-
SELECT * from SY00500 where BACHNUMB = ‘???’ (where ??? is the USER ID of the person getting the problem in GP)
-
If this query returns rows, then run: Delete SY00500 where bachnumb = ‘???’
Hi can you clarify to me why records are locked on that tables? By the way we are using currently this process hierarchy
1. Sales Order
2. Transfer to Sales Invoice
3. Print
4. Look Up Previous Invoice
5. Post Invoice
We don’t do batch posting due to errors encountered on GP not removing allocation on inventory.
By: Kristoper on December 14, 2009
at 07:35
Hi Kristoper,
This error usually occurs because the posting process has been interrupted for some reason. Its not an issue with GP…GP is doingits work, but the posting routine has been stopped prematurely. It could be a system crash,a dropped network connection, or interference from a custom development / trigger that causes some standard GP posting process to fail. Generally,its a dropped network connection. If it is happening frequently, you really need to monitor things to find out why. By the way, what errors did you encounter with P not removing inventory allocations? Have you any custom developments running on the SOP entry window? Even just a badly placed custom trigger can cause problems. What version of GP and service pack?
Send me your email address if you want to take this off line. Post your emal in a comment here, and I won’t publish the comment to keep your privacy.
By: istewart on December 16, 2009
at 22:39
see the full procedure at microsoft’s KB: http://support.microsoft.com/kb/852623
By: adenner on January 5, 2012
at 22:07