web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

System Message 6019: Batch is out of balance and not released.

(0) ShareShare
ReportReport
Posted on by 198

We are on Dynamics SL 2011, FP1. Sql Server 2012 and Windows Server 2012, R2. I have a partially released AP batch (From Voucher and Adjustment entry). It has 65 documents in it, 3 of which had payments applied in Manual Check/Payment. I did not see the original event log error message, but when I try to release the batch now, it looks to release, but if I exit out of the Release AP Batches Screen and get back in, the batch is still there. The event log created when I try to release the batch now has a sizeable file, but at the end has “System Message 6019: Batch is out of balance and not released”. I have checked the Batch, APDoc, APTran tables and nothing seems to be out of order.  Exported data from all three tables and checked totals and everything adds up to the batch total. The Batch Status is “S” and Rlsed in both APDoc and APTran are all 0. In APDoc, for the three documents that had checks already applied, the DocType is “VC” and Status is “T”. All the other records in the APDoc table are “VO” and “A”, respectively.  APAdjust has no records at all. 

 I have read everything I can find related to Partially Released AP Batches, but no luck. Can I just go into Initialize mode and delete the batch and re-enter it. I would certainly prefer an easier solution, but just don’t know how to find the issue.  Any help would be appreciated.  Thank you.  

*This post is locked for comments

I have the same question (0)
  • Stuart Nottingham Profile Picture
    1,226 on at

    Jim, have you tried running the AP_DEBUG stored procedure?

  • Jim Walker Profile Picture
    198 on at

    I had not as I did not know it existed.  I went ahead and ran it.    Not sure about all the output, but in the midst are the following lines.  

     Batch Diagnostics

    Error 6019, APTrans are missing or the sum of amounts does not match the APDoc

     Warning: The join order has been enforced because a local join hint is used.

    BatNbr,refnbr,msg

    225731    ,106917    ,APTrans are missing or the sum of amounts does not match the APDoc

     

    I checked and Refnbr 106917 is in the  APDoc table, but not APTran.

    All values in APDoc record though, are 0.  I checked the Voucher and Adjustment batch and that document doesn’t have anything in the transaction section.  I backed up and restored our DB to TEST and tried deleting that document, but it still failed to post.

  • Verified answer
    Community Member Profile Picture
    on at

    Jim, after deleting the apdoc for that reference number, did the release of that batch fail with the same reason?  Did you check the debit and credit totals in the batch record to make sure they matched the sum of the debits and credits in the aptran records for that batch?

    The one other possible cause might be that one or more of the aptran records are using a gl account or sub-account that are now flagged as inactive or that the account/sub-account combination has been set to an invalid combination (if you are using the account/sub-account maintenance to control what can be posted to).

  • Jim Walker Profile Picture
    198 on at

    Rick,

    I had originally tested deleting the document in the Voucher batch in our TEST DB.  When I released it, I got SQL errors so never looked at the Event Log.  I just tried it in our live DB so I could check the event log and it posted fine.  invoices are on the Vendor Accounts!  Not too sure why it didn't release in the TEST DB.  Anyway, all is good.  Thank you for the response.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans