Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Total and Control Total don't match

Posted on by 45

I've entered a batch of invoices.  When I export my AP Batch Edit report into Excel my total matches my control total.  However, on the AP Batch itself the Debit total is showing up as a slightly higher amount.  Several of us have cross-checked the entry multiple times and see no errors.  Is there any way I can find out why the debit total is not correctly reflecting what was actually entered in the batch?

*This post is locked for comments

  • MARC_ Profile Picture
    MARC_ 620 on at
    RE: Total and Control Total don't match

    Do you have access via SQL?  I would check the APTRAN records for either missing CuryID or DrCr value.

    Also make sure the CuryTranAmt = TranAmt * CuryRate

  • Reid Profile Picture
    Reid 80 on at
    RE: Total and Control Total don't match

    I'm no help but am having this exact issue.  One invoice is left off of the system generated batch total but is entered correctly.  If anyone found a fix please reply, thanks!

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans