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

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Web Service - Create Sales Invoice - Distributions does not equal actual amount

(0) ShareShare
ReportReport
Posted on by

We are using the GP Web Services to create Sales Invoices.  We can create the batch.  But when we open the batch in the Sales Batches window and create the Edit List report.  Then we get these errors:

**ERROR:  The receivables distribution(s) does not equal the actual amount.

**ERROR:  The sales distribution(s) does not equal the actual amount.

We can get around these errors by opening the Distributions window and clicking on the Default button.

I can see that the problem is that the amounts in the SOP10100 table have 2 decimal places and the amounts in the SOP10102 table have 5 decimal places.  If I update the amounts on the SOP10100 table to have 5 decimal places to match the SOP10102, then the problem goes away.  Or when I click on the Default button, it changes the SOP10102 amounts to be only 2 decimal places. 

Is there a way to get the decimal places to be the same?

*This post is locked for comments

I have the same question (0)
  • Deseree Krumm Profile Picture
    Microsoft Employee on at

    Are you hand keying the transactions or are them being imported?  If you enter the same transactions in a rich client of GP, do you see the same results?  Please advise.

  • Community Member Profile Picture
    on at

    The transactions are being imported using the GP Web Services.  If we enter the same transactions in a rich client of GP, then we don't have the problem.

    The problem was because we had the Policy "Calculate Total Amount" set to Calculate.  When we changed this Policy to "Do Not Calculate" and we passed in the amount to the GP Web Service.  Then the problem was resolved.  

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans