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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Total SOP invoice amou...
Microsoft Dynamics GP (Archived)

Total SOP invoice amount is not correct

(0) ShareShare
ReportReport
Posted on by Brian Girard

I have an issue with an SOP invoice that dynamics totaled incorrectly.  The subtotal and the distributions show one amount but when you add up each individual line it comes up with the correct subtotal.  It was posted this way and we caught the error only when we reconciled the monthly sales numbers. I reprinted the batch posting journal and it is plain as day that there is a difference between the subtotal on the order and the subtotal of the line items.  Any ideas on the cause and/or how to correct it?  I can forward the PDF of the posting journal if anyone needs/wants to see it.

*This post is locked for comments

  • Verified answer
    Richard Whaley Profile Picture
    Richard Whaley on at
    Re: Total SOP invoice amount is not correct

    The causes can be several (someone shut down their workstation before exiting GP, power failures, more)  This issue is a frequent occurance.  If it is caught BEFORE posting, the easy fix is to run the Reconcile process against the individual Sales Transaction.  This process will add up the individual line items, fix the totals and the fix the distributions.

    Since you have already posted, corrections depend on what the specific situation is.  What has the customer been told they owe?  Is it the same as the amount posted to their account?  Adjustments may be needed to bring their account in line with the amount they believe they owe.  If you have not yet mailed the invoice, I would void the original transactions and re-key an order and invoice it.

    Quantity adjustments to inventory should not be needed.

    GL Postings must be examined (if the incorrect invoice is not voided) and any adjustments needed made.  There should not be any standalone adjustments as any adjustments to receivables will also post to GL.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans