Rounding Difference from Sales Invoices Received via Interface

You can open the function or view sales invoices by selecting Sales > Sales invoices.

Sometimes when sales invoices are imported into Netvisor from an interface, there may be rounding differences on the invoices. In such cases, the total amount brought to the invoice does not match the amount calculated by Netvisor from the row sums as follows:

The rounding differences are usually due to the fact that rounding is done differently in another system than in Netvisor.

If the total amount of the invoice is imported from another system, Netvisor respects this information and sets it as the total amount on the invoice.

If the row sums are not separately imported from the interface, Netvisor calculates the amount for the voucher based on the invoice rows. This can lead to a difference between the total amount imported to the invoice and the row sum calculated by Netvisor.

If the amounts differ, resolve the situation in one of the following ways:

• Do not import the total amount of the invoice from the interface at all, so that the total amount will be the row sum calculated by Netvisor.

  1. Set the value of the salesinvoiceamount element in the sales invoice message to 0 <salesinvoiceamount>0</salesinvoiceamount>.
  2. Alternatively, leave the salesinvoiceamount element empty in the form <salesinvoiceamount />.
  3. Make sure that the total amount of the invoice is not imported from the interface in any other way.

• If it is not possible to omit the total amount of the invoice, import the row sums as given in the invoice message so that Netvisor uses the amounts provided in the message.

  1. Add a row sum element <salesinvoiceproductlinesum> to the invoice message for each invoice row.
  2. Provide in the <salesinvoiceproductlinesum> element a pre-calculated row sum that replaces the row sum calculated by Netvisor.
  3. Also add the row’s tax amount <salesinvoiceproductlinevatsum> for each row, because importing the row sum makes this element mandatory.
  4. Make sure that the row sums and tax amounts correspond to the calculation used in the other system.

For changes, you should turn to the integration implementer, as any changes to the import of invoices are made by the integration implementer.

Frequently asked questions

What usually causes rounding differences in a sales invoice in Netvisor?
Rounding differences are usually due to the fact that rounding is done differently in another system than in Netvisor, in which case the total amount brought to the invoice does not match the amount calculated by Netvisor from the row sums.

How does Netvisor handle the total amount of an invoice imported from the interface?
If the total amount of the invoice is imported from another system, Netvisor respects this information and sets it as the total amount on the invoice.

How does Netvisor calculate the invoice amount if row sums are not imported from the interface?
If the row sums are not separately imported from the interface, Netvisor calculates the amount for the voucher based on the invoice rows, which can lead to a difference compared to the total amount imported to the invoice.

How can I remove rounding differences if I do not want to import the total amount of the invoice?
Remove the total amount of the invoice from the interface by setting the value of the salesinvoiceamount element in the sales invoice message to 0 or by using an empty element <salesinvoiceamount />, in which case the total amount will be the row sum calculated by Netvisor.

How can I remove rounding differences if it is not possible to omit the total amount of the invoice?
Import the row sums as given in the invoice message using the <salesinvoiceproductlinesum> element and at the same time import the row’s tax amount <salesinvoiceproductlinevatsum> for each row, so that Netvisor uses the amounts provided in the message.

Who should I contact if changes are needed in the import of invoices?
For changes, you should turn to the integration implementer, as any changes to the import of invoices are made by the integration implementer.

Keywords

sales invoice, interface, rounding differences, total amount, row sum, salesinvoiceamount, salesinvoiceproductlinesum, salesinvoiceproductlinevatsum, Netvisor, integration implementer