Perform calculation directly in the amount field (Invoice only)

In Acubiz Invoice Management, amounts can be calculated directly in the amount field per line.

4 calculation methods can be used.

• + (plus)
• - (minus)
• * (multiply)
• / (divide)

The calculation methods can be used in combination within the same calculation.

Using calculation methods can be relevant in relation with the fact that the line in Acubiz must reflect the gross amount, but the invoice itself states the net amount (without VAT). in Acubiz, the gross amount is used, since a VAT code is supplied to the ERP system, which then calculates the VAT amount.

Examples of calculation methods::

An invoice with 2 lines, of which they appear without VAT on the invoice. But in Acubiz we must have the amount incl. VAT. thus::

In the first line of Acubiz, enter the following calculation method:

=2550*1,25

We take the amount on the line on the invoice and add 25% VAT by multiplying by 1.25. 

Since there are only 2 lines on the invoice, the remaining line will be correctly calculated, as it is the residual. The result is then:

Example with 2 lines + freight

Another example is the same invoice charged with freight, where VAT is not to be deducted.

Entered as follows in Acubiz::

Gives total invoice amount: 4,125.00

Line 1: 

=2550*1,25

Line 2.

=350*1,25

Line 3 (the residual) should not be calculated, as it must be the gross amount because there is no VAT on freight.