Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / An error has occurred ...
Microsoft Dynamics SL (Archived)

An error has occurred while validating check amounts SL 2011 FP1 Version 8

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

HI. My client is receiving the Error when they try to print a check. Please see screen shot. This is accruing when they print a check for a Prepayments document. When you view the batch in "Edit/ Select Documents for Payment", SL has added hundreds of Debit Memos that have nothing to do with Check batch. I have deleted the lines out of the check batch that don't belong there. When I go and preview the check under reports, all the documents are the with (-) balances and the documents that is supposed to be there has a zero balance now.

 

Any assistance will be appreciated.

 

Thank you.

 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: An error has occurred while validating check amounts SL 2011 FP1 Version 8

    Thanks StacieH. That was exactly the problem. After applying at the AD documents to the correct VO's they are now able to run they checks again.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: An error has occurred while validating check amounts SL 2011 FP1 Version 8

    Based on the description is sounds like the vendor has several debit adjustments that are being selected for payment along with the vouchers.     Could these debit refnbrs be assigned to the open vouchers?    Look in document maintenance>  Apply adjustment tab on the voucher to see if the debits are assigned.    Or select applyrefnbr from apdoc where refnbr = 'voucher'       ** replace 'voucher' with the appropriate refnbr.  

    If you do not want to use the debits you can clear them from the applyrefnbr.         

    If the applyrefnbr is not populated I would need to see the records to identify the cause.   

    Is the problem only occurring on one vendor?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: An error has occurred while validating check amounts SL 2011 FP1 Version 8

    I have tried that and it did not resolve the issue. When I recreate the check I receive exactly the same error. When I check in APCHECK and APCHECKDET the check amount is '0' and there are a bunch of things in there that should not be there.

    I restored a backup of the live system into my test company and deleted all transaction in those two tables. I then created a new check and received the same error. When I went back into the tables (After creating the new check) those random transaction where siting there again.

    The next logical step would be to check the transaction that keep on popping up but I cant see anything wrong with them. I also ran the AP Integrity check and hopped for some luck but that did not  help either.

    Any Idea why SL keeps on trying to print zero checks?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: An error has occurred while validating check amounts SL 2011 FP1 Version 8

    Hi,

    The AP payment selection/check printing uses records in the work tables apcheck and apcheckdet along with an apdoc record.   The message you are receiving indicates that the sum of the apcheckdet records for the  vendor does not equal the apcheck record.    It is possible to correct the check batch via SQL but the easiest method is to just clear the payment selection batch in SL and then create a new payment selection batch.

    Use the following steps to clear the selection on this batch.

    AP> Processes>  Payment selection.     F3 and select or input batch 004657.

    On the document tab click in the Payment Selection box.  Use the dropdown and select the  'Clear Selections Only' option.    Then click begin processing.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans