different VAT amounts on the same sales order

(0) Share

Report

Posted on by bert L

Hi,

I'm having a problem with selling products with different VAT percentages. (21% and 6%)

EXAMPLE:

Like it should be

	price excl vat	VAT %	VAT amount	price incl VAT
ITEM1	19,25	21	4,04	23,29
ITEM2	18,5	6	1,11	19,61
TOTAL	37,75		5,15	42,90

How business central reacts

	price exl vat	VAT Posting Group
ITEM1	19,25	M3 (21%)
ITEM2	18,50	G1 (6%)

total excl VAT	37,75
total VAT	2,27
total incl VAT	40,02

I maintained the VAT settings completly. What goes wrong in this case???

Thx,

Bert L

All responses (16)

Answers (1)

bert L 85 on at

Like (0)

Report

RE: different VAT amounts on the same sales order

Thanks Hannes, was a great help! Problem solved!
bert L 85 on at

Like (0)

Report

RE: different VAT amounts on the same sales order

Thanks, was a great help!
bert L 85 on at

Like (0)

Report

RE: different VAT amounts on the same sales order

Thank you! It works!
Verified answer

Teddy Herryanto (Th... 13,622 Moderator on at

Like (0)

Report

RE: different VAT amounts on the same sales order

Go to VAT Posting Setup. There is VAT Identifier there. It is used by BC to group the same VAT percentage.
bert L 85 on at

Like (1)

Report

RE: different VAT amounts on the same sales order

Hi Hannes,

Thanks for your respond.

I don't know what you mean with 'VAT identifier'. Can you give me further explenation? But I do understand what you mean about the test report.

Kind Regards,

Bert
Hannes Holst 5,767 on at

Like (0)

Report

RE: different VAT amounts on the same sales order

hi,

Check "VAT Identifier".

Both lines have the same VAT Identifier and therefor BC summarizes the VAT regardless of the different rates.

This is especially "funny" because the total on the Sales Order/Sales Invoice is correct but when you post/preview post/test report you suddenly see the amount posted to the CLE is different.
bert L 85 on at

Like (0)

Report

RE: different VAT amounts on the same sales order

Hi Joan,

I have changed the status of EU service without result.

Anyway, thanks for your help and time!

Kind Regards,

Bert
JLLAHOZ 35 on at

Like (0)

Report

RE: different VAT amounts on the same sales order

Hi Bert,

Sorry, I don't know. This is not a normal operation in the tax law of my country.

Maybe you should consult someone from the Netherlands Taxes.

Anyway I see that the configuration G1 (6%) has put you as "BINNENLAND" and says that it is an EU service.

(I don't think it affects...)

Regards.
bert L 85 on at

Like (0)

Report

RE: different VAT amounts on the same sales order

He substracts 6% of the amount excl VAT of the first line.

Why?????
bert L 85 on at

Like (0)

Report

RE: different VAT amounts on the same sales order

Hi Joan,

Thank you for your effort. I've inspected both lines as you mentioned above. The line with the VAT of 21% seems OK but when i look at the 6% you can see in the amount incl VAT he is substracting a certain amount. How can that be?

Kind Regards