Small and medium business | Business Central, N...

VAT Statement calculation - substation formula

(0) Share

Report

Posted on by Afazal

135

Dear All,

In VAT statement, is it possible to calculate subtract formula in VAT statement, issue is that there are two rows XX and YY. I want to subtract XX from YY. how it possible in row 71/72 as below.

I have the same question (0)

All responses (5)

Answers (0)

DAnny3211 11,397 on at

Like (0)

Report

hi

it is possible to calculate a subtract formula in the VAT statement in Business Central. You can achieve this by creating a new line in the VAT statement with the formula that subtracts the value in row XX from the value in row YY.

To do this, follow these steps:

Navigate to the VAT statement in Business Central.

Click on the "Edit" button to open the statement in edit mode.

Add a new line to the statement by clicking on the "New" button.

Enter the appropriate information in the new line, including the relevant account number and transaction type.

In the "Amount" field, enter the subtract formula that calculates the difference between the values in row XX and row YY. For example, if row XX is on line 71 and row YY is on line 72, the formula would be "=72-71".

Save the changes to the VAT statement.

Once you have saved the changes, the VAT statement will display the calculated value in the appropriate row.

DAniele

Was this reply helpful? Yes No
KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

For You current setup the easiest way would be to just mark on the row XX column Calculate with = Opposite Sign

then on the 71/72 line the result should be correct.

Was this reply helpful? Yes No
Afazal 135 on at

Like (0)

Report

In my case row type is row totaling, so system cant allow to change the opposite sign. as attached image:

Was this reply helpful? Yes No
Afazal 135 on at

Like (0)

Report

Sir, I am not able to see the amount field in vat statement, is it possible to share the screen shot of vat statement with require settings.

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

If You can choose the option Type=Formula, then in Row totaling You can add the *-1 for the row to change the sign.

Otherwise, just create duplicate lines with other numbers for the lines 54,55,56,57,61,63 - and provide them that they are calculated with opposite sign.

Was this reply helpful? Yes No