Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

Not all ARTran records move to GLTran.

Posted on by Microsoft Employee

Good afternoon, all! I hope that you are doing well and avoiding COVID-19.

My client has an AR Batch that shows as Unposted in GL. They tell me that the batch released in AR without issue, but when they attempt to post in GL they receive an "Out of Balance" error. 
In SQL I looked at the Batch and GLTran records, and it is indeed out of balance. Stepping back a bit more and looking at ARTran, I found that a good number of the records did not release and are are still in the table with  a Rlsed = 0 status. 
My question is twofold:
1. Any idea on how this would happen?
2. How to go about fixing this? my initial thought was to change the batch to "S" status and release it again, but I'm not sure how that would affect the records already in GLTran.
Any help, as always, is greatly appreciated.
Stuart Nottingham
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Not all ARTran records move to GLTran.

    That did the trick, Jana! Thanks!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Not all ARTran records move to GLTran.

    Thanks for your response, Jana. Yes, the GLTran records do reflect the released ARTran records. I was thinking of exactly the process you suggest to rectify the problem, and am glad to get the verification that's the correct procedure to follow. Will update once I have the solution in place.

  • Verified answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Not all ARTran records move to GLTran.

    Dear Stuart,

    What are the gl trans, do they represent the released artrans only?

    You can create a new AR batch by opening up the invoice screen putting in a transaction and saving..you can then delete the transaction.

    Now you can update the unreleased trans to the new batch number and release it.

    The original Gl batch can be corrected by just changing its total to have it recalculate. 

    Best Regards,

    Jana MacDonald

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Not all ARTran records move to GLTran.

    I reset the batch record to 'S' and the Rlsed field in Batch to 0. I then ran ARDEBUG on the batch and got the results below. The only obvious error relates to the HistSlsTax table; since there are five (verified) records in that table related to the "Released" records in the AR batch, I would expect the error. Anyone see anything in here I'm missing? I'd like to clear this up for the client.

    debug_5F00_200317.txt

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans