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

I have the same question (0)

All responses (16)

Answers (1)

JLLAHOZ 35 on at

Like (0)

Report

Hi Bert,

Looks like he's applying 6% to both lines.

It would be necessary to look at the configuration of the VAT groups.

Send an image and we look at it

Best Regards

Was this reply helpful? Yes No
bert L 85 on at

Like (0)

Report

Hi JLLahoz,

Thanks for your help. Hereby the VAT setup page, procut posting group and business posting group.

Was this reply helpful? Yes No
bert L 85 on at

Like (0)

Report

Hi Joan,

If I switch the lines op position, he's applying 21% to both items. I'm not sure if the problem is situated in the VAT groups.

Best Regards

Was this reply helpful? Yes No
JLLAHOZ 35 on at

Like (0)

Report

Hi Bert,

Have you set up VAT Groups manually or is it a migration?

If a migration validates that the fields are loaded correctly, there are some fields that are not visible on the screen that are not calculated if not done manually or validated.

If you say, when you change the order, change the% ... you would have to see exactly what product VAT group value is loaded on the sales line.

Best Regards

Was this reply helpful? Yes No
bert L 85 on at

Like (0)

Report

Hi Joan,

It's a new company I have created with sample data. So the VAT posting groups are setup correctly for the region I'm working in.

I can't add the field vat% to the sales order, instead I've added the VAT product posting group. As you can see according to the VAT setup G1 = 6%, M3 = 21%.

Kind Regards,

Bert

Was this reply helpful? Yes No
JLLAHOZ 35 on at

Like (0)

Report

Hi Bert,

(it looks as if you put the% IVA of the last line read ...)

To see% of the line do the following:

1. Open the Sales document

2. Go to "Help and Support" and open "Inspect pages and data"

3. Once you have opened the screen on the right click on the lines and the fields of the selected line will open.

4. Look at the "VAT%"

Don't you have any adaptation to keep a single VAT by document?

Regards.

Was this reply helpful? Yes No
bert L 85 on at

Like (0)

Report

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

Was this reply helpful? Yes No
bert L 85 on at

Like (0)

Report

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

Why?????

Was this reply helpful? Yes No
JLLAHOZ 35 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
bert L 85 on at

Like (0)

Report

Hi Joan,

I have changed the status of EU service without result.

Anyway, thanks for your help and time!

Kind Regards,

Bert

Was this reply helpful? Yes No