Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SL 2018 CU1, SQL Messa...
Microsoft Dynamics SL (Archived)

SL 2018 CU1, SQL Message 93, GLPostDebug

(0) ShareShare
ReportReport
Posted on by Stuart Nottingham 1,170

My client is testing as part of the upgrade process (from SL 7.0). On releasing an AP batch, one of the users received SQL Message 93. A quick Google search turned up B2551470_FRx_SL2011.zip which alters a trigger for FRx. The batch did make it through to GL. However, when I try to post the batch, nothing happens. I get Process Complete, but the batch remains in the Post Transactions screen. Nothing in the event log either. 

I found and ran the GLPostDebug script, which told me I have "situation 3011," which would be great if I know what situation 3011 meant. Does anyone have a listing of the codes from this debug? Also, will the B2551470_FRx_SL2011.zip script work in SL 2018 CU1?

Thanks!

*This post is locked for comments

  • Suggested answer
    Mark E Profile Picture
    Mark E 6,405 on at
    RE: SL 2018 CU1, SQL Message 93, GLPostDebug

    In SQL, review the GLPostDebug proc.  It calls the pp_01520 proc in debug mode.  Open that proc, and search on the 3011 text, you will see a few references to that situation code.  Review the scenarios where that code is referenced as an output.  One of them will match your situation, and should help you determine the cause of the out of balance error.  You might have a bad or missing CuryID issue or Cury Dr/Cr Amt vs Base Dr/Cr Amt.

  • Stuart Nottingham Profile Picture
    Stuart Nottingham 1,170 on at
    RE: SL 2018 CU1, SQL Message 93, GLPostDebug

    We will be migrating over to MR, just not sure if it’s immediate yet. I’ll drop those triggers and recreate the with the install.

     

    An empty batch was the first thing I thought of. I have reviewed the batch and it does have records. Looked at them in SQL and didn’t see anything jump out at me.

     

    Thanks!

  • Mark E Profile Picture
    Mark E 6,405 on at
    RE: SL 2018 CU1, SQL Message 93, GLPostDebug

    Are you still using FRx with SL2018, or have you migrated over to MMR?  If using MMR, then all the FRx triggers can be dropped.  The 3011 Message can be found in the Messages table (or csv), and indicates the "batch is not in balance and not posted".  You can review the GL Batch in Initialize Mode from the Journal Transactions screen, selecting the AP module.  Hunch is that the Batch has no GLTran records.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans