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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156