Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Voiding a Negative Check
Microsoft Dynamics SL (Archived)

Voiding a Negative Check

(0) ShareShare
ReportReport
Posted on by WillM 45

I have a user who entered a voucher that had 2 distribution lines - a large negative amount and a much smaller amount that was positive. After the batch was posted they printed the check.

Somehow the check came out with as transaction type CK with a  negative amount (not as a ZC or VC with a zero amount as I would have expected.

Even stranger in the ledger, the check shows up as a positive amount - the sum of the 2 distribution lines as absolute values. Because of this, the check won't void.

When I look in the Batch table I can see that there is no DR amount. I can fix that, but that same batch # in the AP tran table only has one row (for checking account, not the accounts payable account). And nothing gets created in the APDoc table. So it appears to me that mid-way through the release process it's stopping.

I could try and force it by inserting the other rows of data but I'm concerned I'll just make the problem worse. Is there anyway I can fix the vendor payables balance in the system?  

Thanks,

Willis

*This post is locked for comments

  • WillM Profile Picture
    WillM 45 on at
    RE: Voiding a Negative Check

    Elaine - thanks so much for the response.

    I was able to fix this yesterday by making the APDoc balance match the APTran balance, as well as changing the balance in the APAdjust table. Once that was done we were able to successfully void the check and then enter adjustments to remove it altogether. The voucher was definitely a problem, but we needed to void the check first in order to be able to address the original transactions that caused this mess.

    That vendor record now has a proper balance of zero and the ledger is correct.

    Thanks again for the response - it's very appreciated.

    Regards,

    Willis

  • Community Member Profile Picture
    Community Member on at
    RE: Voiding a Negative Check

    Willis,

    Typically when a void check fails to release, the problem is with the original check batch.

    You might choose to delete the apadjust records for the check and aptrans for the check.  You could update the check to type = VC and status to V and update the perclosed value..   Then open the voucher again by updating the docbal/curydocbal/opendoc/perclosed.   It sounds like the voucher is the issue -what to do with the voucher.  You may instead want to update the voucher to a VT type rather than a VO type.   A VT type would be a voucher voided before it is released.  Then delete the  aptrans for the voucher.

    I am making assumptions here based upon what you are reporting.

    Now GL will be incorrect so you will likely need to make a GL entry to back out whatever went to GL from these batches.

    Lastly, the vendor balance may be incorrect.  You can change the balance in Vendor Maintenance and Vendor history in the Vendor History screen while in Initialization  mode.

  • WillM Profile Picture
    WillM 45 on at
    RE: Voiding a Negative Check

    I did a little more research in the tables & saw that part of the problem is that the APTran amount doesn't match the APDoc amount. I can change one or the other, but I want to make sure that I don't make the issue worse. Has anybody had an issue like this before?

    Thanks,

    Willis

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans