Total VAT formula not working on invoice?

(0) Share

Report

Posted on by AleAlonso

133

Hello,

I have created my VAT Posting Setup as below:

Standard rate is 20%

Reduced rate is 5%

I have an invoice with two lines,

Line 1: £100 reduced VAT (5%) so £5 VAT

Line 2: £50 standard VAT (20%) so £10 VAT

However, the system is applying the standard rate to the £150

is this a bug or is there a setting to get VAT calculated line by line?

Thanks

Alejandra

All responses (10)

Answers (0)

AleAlonso 133 on at

Like (1)

Report

RE: Total VAT formula not working on invoice?

Hi Vaishnavi,

I have found the issue! I didn't have any values in the VAT Identifier field on the VAT Posting Setup. I have now added them and VAT amounts are correctly calculated.

Many thanks for your help.

Alejandra
Suggested answer

Vaishnavi J 3,056 on at

Like (0)

Report

RE: Total VAT formula not working on invoice?

Hi,

If you are using windows then type windows + Alt + R this will start the recording once you are done select the pause button this will record the video in This PC section in videos folder.

or you can download any app from this website. Once you have recorder the video there is Insert option. Click on drill down you will get an option Image and Video file and then you can add the video.

www.easeus.com/.../free-video-recording-software.html

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much
AleAlonso 133 on at

Like (0)

Report

RE: Total VAT formula not working on invoice?

Hi Vaishnavi,

No extension installed.

How can I share a video here?

Thanks

Alejandra
Suggested answer

Vaishnavi J 3,056 on at

Like (0)

Report

RE: Total VAT formula not working on invoice?

Hi,

I tried to add vat in Purchase invoice it works fine even if i did preview posting in GB tenant with version 20.2

is there any customization done on your tenant?

If that's the case, please uninstall the extension and try again.

if not then could you share a video of the problem?

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much
AleAlonso 133 on at

Like (0)

Report

RE: Total VAT formula not working on invoice?

Hello,

Version: GB Business Central 20.2

Thanks

Alejandra
Suggested answer

Vaishnavi J 3,056 on at

Like (0)

Report

RE: Total VAT formula not working on invoice?

Hi,

Can you specify your Business Central Localization and version?

And do you have any customization done on it?

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much
AleAlonso 133 on at

Like (0)

Report

RE: Total VAT formula not working on invoice?

Hello Vaishnavi,

I've used the Page Inspection and for the amount including VAT is £105

Line 1 Line 2

Amount 100 50

VAT % 5 20

Amount Inc VAT 105 75

and it gets worst, when I click on Posting Preview I get totally different VAT amounts, see below:

VAT Bus. PG VAT Prod. PG Posting Date Doc Type Base Amount VAT Calculation Type

DOMESTIC STANDARD 24/06/2022 Invoice 50.00 2.50 Normal VAT

DOMESTIC REDUCED 24/06/2022 Invoice 100.00 5.00 Normal VAT

Thanks

Alejandra
Suggested answer

Vaishnavi J 3,056 on at

Like (0)

Report

RE: Total VAT formula not working on invoice?

Hi,

There is field in the line Amount Including VAT which will show the vat amount by line.

If you are working in sandbox then you can add the below field using design method otherwise you have to bring this field on page using customization by setting the visible property true for this field.

if you don't want to display this field on page level you can also check data using Inspection page.

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much
AleAlonso 133 on at

Like (0)

Report

RE: Total VAT formula not working on invoice?

Hi Gavin,

Both VAT Bus. Posting Groups are "Domestic"

Thanks

Alejandra
Gavin 2,350 on at

Like (0)

Report

RE: Total VAT formula not working on invoice?

Hi,

If you pull the "VAT Business Posting Group" on to the line via personalisation is this DOMESTIC for both lines?

Thanks

Gavin