web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

VAT Statement calculation - substation formula

(0) ShareShare
ReportReport
Posted on by 145

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.

VAT-Statement.png

I have the same question (0)
  • DAnny3211 Profile Picture
    11,423 Super User 2026 Season 1 on at

    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

  • KasparsSemjonovs Profile Picture
    4,849 Super User 2026 Season 1 on at

    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.

  • Afazal Profile Picture
    145 on at

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

    vat-sta.png

  • Afazal Profile Picture
    145 on at

    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.

  • Suggested answer
    KasparsSemjonovs Profile Picture
    4,849 Super User 2026 Season 1 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 563 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 374 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 331 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans