Can't Enter SOP Entry screen - previous posting... 1

[Borvik]

I have a user that can't enter the Sales Order Entry screen.

She keeps getting the message:

Your previous transaction-level posting session has not finished processing.

Please allow time for it to finish. If you believe it has failed, log out of Microsoft Dynamics GP and log back in to recover transactions.

I have had her log out of GP and log back in, and it still does it. I've looked at the Master Batch Recovery - nothing to recover.

Any ideas on what I can do?

 

[RobertC22]

There are a few of things you might need to check directly on the database.

In the SY00500 table, is there a record where the SERIES = 4 and the BACHNUMB equals the User's ID and the BCHSOURC equals 'Sales Transaction Entry' or '*Sales Transaction Entry'. If so, delete it.

Secondly in the SOP10100, are there any records where the BACHNUMB equals the User's ID and the BCHSOURC equals '*Sales Transaction Entry'? The leading asterisk is important.
If so, you need to amend the BCHSOURC value to remove the asterisk so the user can access these unposted SOP documents.

Finally, in the DYNAMICS database, check the SY00800 and SY00801 tables for any records where USERID is equal to User's ID. Assuming the user is NOT in DynamicsGP, remove these records as well.


------
Robert

 

[Borvik]

SY00500 - the only record with that user's user id as the BACHNUMB has a BCHSOURC of 'Sales Void' - does this count?

There is nothing in the SOP10100 table with the BACHNUMB equal to the user's id.

Clearing the SY00800 and SY00801 tables (nobody was in the system), did not help at all.

 

[barbola]

Did you check the wkpostingvalidationstate table? Also you can check the temp database to see if she has any locked sessions. dex_session and dex_lock tables.

 

[Borvik]

At the same time I cleared the SY00800 and SY00801 tables I cleared the DEX_SESSION and DEX_LOCK tables - no effect.

wkpostingvalidationstate table - which one is that, I'm not seeing that in the resource description (Tables) in the Sales section (or a few others I checked), in fact (checking a printout) I hardly see any tables with a technical name that starts with "w".

 

[barbola]

WkPostingValidationState is a table in the company database. It contains the following fields (some of our data):

BCHSOURC BACHNUMB GLBCHVAL DEX_ROW_ID
GL_Normal GLTRX070217 <Binary> 4686
GL_Normal GJ-1/31/07-EE <Binary> 4739
GL_Normal GLTRX070859 <Binary> 4733
GL_Normal GLTRX070945 <Binary> 4734
GL_Normal JE-4/27/7-ZZ <Binary> 4740
GL_Normal JE-4/1/7-TT <Binary> 4735

 

[RobertC22]

Borvik,

That entry in SY00500 with BCHSOURC of "Sales Void" does count. I had not previously encountered it, but have been able to replicate that type of entry.
If the BCHSTTUS field is not zero, that is the row causing the problem and needs to be removed.

-------
Robert

 

[Borvik]

RobertC22 - that worked! Thanks.

barbola - ah, that is the actual table name. I'm so used to having to search for the actual table name that I immediately assumed that's what I had to do.