RE: Posting Batch Fail

[Janakiram M.P.]

Don,

Sometimes logging out and logging in will help for this kind of issue if it
is happening for only one user and not for everyone. However, if the issue
persist, Try below.

1. Take a Backup of DYNAMICS and Your Company Database
2. Go to Maintenance=>SQL=>Select Your Company Database under Database and
Product Microsoft Dynamics GP. Select Posting Definitions Master as Table and
Then Mark Drop and Create Auto Procedure and Hit Process.
3. Now Check if the error is continuing to come or not.

Thanks
Janakiram M.P.
MCP-GP

"Don Lai" wrote:

> Hi All,
>
> I did post a Batch Number but it's failed with message: "The stored
> procedure glpPostBatch returned the following results. DBMS:0, Microsoft
> Dynamics GP:20774
>
> Anyone has any idea what's wrong, please let me know.
>
> Thanks and Appreciations!
>
> --
> Toi Day

[Don Lai]

[Don Lai]

Thanks Janakiram. I tried 3 steps that you provided and it works even I have
not seen Process button was disable, I mean I skipped the step of Hit Process
because it's not allowed me.

Thanks for your help.

-Don Lai

[Janakiram M.P.]

Don,

Its because you might not have logged in as "sa".

[Richard Whaley -- MVP 2006-2008]

Don,

First of all, If you don't hit Process, you have only logged off and on and
not performed the rest. But that's ok if the batch posted.

If not, before you blow away the stored procedures for those tables and
recreate them, look into this.

Do you have multi-currency turned on?

Does the company have multicurrency access to the currency used in the
transactions? Someone could have entered a transaction and then disabled
access to the currency. That's what DBMS:0, Microsoft Dynamics GP:20774
means.

BTW...GP: definitions can be found in the GPS_SQL_Error_Codes table in the
Dynamics db.

--
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com