Microsoft Dynamics GP (Archived)

glpVerifyBatchTransactions: Invalid Posting Status

(0) Share

Report

Posted on by Community Member

I am getting the above error when tried to post; the BCHSTTUS and MKDTPOST are set to 0

What could be the issue and how do I fix it?

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (1)

Rosemary 10 on at

Like (0)

Report

Hi,

Have a look at this post

https://community.dynamics.com/gp/f/32/t/264731

It deals with the same error message.

Hope it helps

Regards

Rosemary

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

That post did not resolve the issue

Was this reply helpful? Yes No
Frank_Heslin 895 on at

Like (0)

Report

What type of batch are you trying to post?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Financial

Was this reply helpful? Yes No
Suggested answer

Frank_Heslin 895 on at

Like (0)

Report

Is it a GL batch, a Purchasing batch, a Check batch, a Sales batch, a Receivables batch...

Where did the batch originate?

Does it have an actual batch name that a user created or is something like 'usernameXXX'?

I would actually follow Rosemary's post & then the link in Mariano Gomez's post, and go to Option 4; Just be sure no one else is in GP when you run it.

My gut tells me that there was an interruption during the posting process, and GP still has the batch tied to the user.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Purchasing, and yes it does have an actual batch name (not the userid). And the batch is not tied to any users.

I the post that you have mentioned were of any help then I wouldn't be posting my questions here.

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (2)

Report

MSQ,

Let's go over this. You said you are attempting to post a Financial batch originated from a transaction in Purchasing. When posting the batch, you get the error glpVerifyBatchTransactions: invalid posting status.

1. Have all users exit GP

2. In SQL, reset the Batch Status (BCHSTTUS) and Marked To Post (MKDTPOST) flags to 0

3. Remove any records in the Batch Activity table for this batch - DELETE FROM DYNAMICS..SY00800

4. Remove any locks - DELETE FROM tempdb..DEX_LOCK

5. Remove any dead sessions - DELETE FROM tempdb..DEX_SESSION

6. Clear the Posting Validation State table - DELETE FROM wkPostingValidationState

Go back into GP and try to post. If this still doesn't work, there are a few more things we can do, but let's start here.

~~~

PS. As a suggestion, please be courteous to other posters. We are all only trying to help and is very difficult sometimes to tell what you have done or not done to try and resolve the issue at hand. Frank was only trying to guide you based on the information you provided. In fact, I would have also suggested you try the steps outlined in the other post.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Mariano,

Thanks for the details but I am already very familiar with these steps and have been using it for a long time.

All these steps were performed last night and I posted my question when it did not resolve the issue.

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

MSQ,

Thanks for the update! I have also seen this issue when there are damaged or missing table auto-procedures for the Batch Headers table.

1. Open the SQL Maintenance window -- Microsoft Dynamics GP > Maintenance > SQL

2. Locate the company database in question

3. Set the Product ddl to Microsoft Dynamics GP

4. Locate the Posting Definitions Master table and highlight

5. Click on Drop Auto Procedure

6. Click Process button

7. Select the Posting Definitions Master once more and click on Create Auto Procedure

Try posting once more.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I will try it this evening and let you know how it goes

Was this reply helpful? Yes No