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

(0) Share

Report

Posted on by Community Member 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

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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.
Deseree Krumm on at

Like (0)

Report

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.