Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

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

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Web Service - Create Sales Invoice - Distributions does not equal actual amount

    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.  

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

    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.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans