Unbalanced Transaction Total - Invoice

[Former Member]

Hi,

I am using the DI API to connect to a webservice which is pulling back Reserve Invoices placed on an online store and the payments. These have to equal the same amount.

I am creating the invoices but there are some which are having rounding problems which result in the payment equaling a different amount to the invoice.

Is there a way that you can explicitly set the document total so that it is always equal to the payment amount using the DI API which will use a rounding amount to automatically correct any differences?

For example:

Web invoice & payment total = $100.00

Sap calculated invoice total = $100.01

Using the DI it would automatically calculate - Invoice DocTotal $100.00 + Rounding Required $0.01

If this was possible it would allow me to ensure the payments would reconcile exactly for each transaction.

Any help appreciated

[Former Member]

Hi Johan,

I can see this works but the issue is that I don't know the Invoice total that SAP will calculate before adding it, only the invoice total from the web.

I am applying the Invoice lines and a frieght charge but ocasionally, due to rounding of $0.01-$0.02, the invoice total from the web order is different to the total amount SAP calculates.

Is there a way for me to sent the DocTotal and SAP automatically calculate the amount required for rounding?

[Former Member]

You can use workaround - create first the invoice as draft, get the doctotal, remove draft and create invoice once again with known doctotal.

[Johan_H]

Hi James,

I have not had to do this myself yet, but the invoice object has two properties (actually 4) pertaining to rounding:

oInv.Rounding = BoYesNoEnum.tYES
oInv.RoundingDiffAmount = 0.01

You could do some testing to see if these might be any help.

Good luck,

Johan