web
You’re offline. This is a read only version of the page.
close
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) / 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

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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 on at

    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?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans