General Ledger Setup setting: Bill-to/Sell-to VAT Calc.

Fred_CIT

In the General Ledger Setup is a field 'Bill-to/Sell-to VAT Calc.'. It seems this field does not work correctly, but i'm unsure. Unfortunately F1 does not work in this field.

I define 2 customers....

Customer C001 (local)
Country: GB
Customer Posting Group: DOMESTIC
Gen. Bus. Posting Group: NATIONAL
VAT Bus. Posting Group: NATIONAL
VAT Registration No.: 123456789

Customer C002 (EU)
Country: DE
Customer Posting Group: EU
Gen. Bus. Posting Group: EU
VAT Bus. Posting Group: EU
VAT Registration No.: 333333333


Then I create a Sales Order with the setting of the 'Bill-to/Sell-to VAT Calc.' field on 'Bill-to/Pay-to No.'

Sales Order
Sell-to: C001 (local)
Bill-to: C002 (EU)

View the fields using zoom CTRL-F8:
Customer Posting Group: EU
Gen. Bus. Posting Group: EU
VAT Bus. Posting Group: EU
VAT Registration No.: 333333333
VAT Country/Region Code: GB


If I change the setting of the 'Bill-to/Sell-to VAT Calc.' field to 'Sell-to/Buy-from No.' and create an other sales order, i get the following result:

Sales Order
Sell-to: C001 (local)
Bill-to: C002 (EU)

View the fields using zoom CTRL-F8:
Customer Posting Group: EU
Gen. Bus. Posting Group: EU
VAT Bus. Posting Group: NATIONAL
VAT Registration No.: 333333333
VAT Country/Region Code: GB


In this last example, I expected 'VAT Registration No.' to be 123456789 (of C001) and 'VAT Country/Region Code' to be 'DE'.
Is my judgment wrong?

nunomaia

When you select a customer by default VAT Business Posting group is coming from Sell To customer. If want to use from Bill To customer vat customer group you must select Bill-to/Pay-to No option.

Fred_CIT

It seems that regarding the setting of 'Bill-to/Sell-to VAT Calc.', the VAT entry is always the same.

In the VAT entry always the VAT Country GB (local customer C001) is used in combination with the VAT Reg. No. 333333333 (eu customer C002).
Are you saying this is right?

nunomaia

I have made a test with Cronus.

In G/L Setup I have: Bill-to/Pay-to No.

In Sales header:
1. Inserted C001 in Sell to, VAT Bus. Posting Group became NATIONAL
2. Insert C002 in Invoice To, VAT Bus. Posting Group became EU


Change G/L Setup to Sell-to/Buy-from No.

Repeat steps 1 and 2. I you will notice that Invoice VAT Bus. Posting will remain has NATIONAL

Fred_CIT

That is absolutely true, but it's not my question. [-X

The question is: What happens to the 'VAT Registration No.' and 'VAT Country/Region Code' fields. Is this right?

If my G/L Setup setting is 'Bill-to/Pay-to No.', I expect both fields to be filled with the values of the Bill-to Customer.
And with the 'Sell-to/Buy-from No.' setting both fields filled with the values of the Sell-to Customer.

Now the 'VAT Registration No.' is always coming from the Sell-to Customer and 'VAT Country/Region Code' is always coming from the Bill-to Customer. Regarding the setting 'Bill-to/Sell-to VAT Calc.' in de G/L Setup. This cannot be right!

tinoruijs

Fred_CIT wrote:

In the General Ledger Setup is a field 'Bill-to/Sell-to VAT Calc.'. It seems this field does not work correctly, but i'm unsure. Unfortunately F1 does not work in this field.

I guess Microsoft is waiting for a good explanation of the field here on Mibuso to put into help!

Btw; Welcome on Mibuso, Fred! 8)

nunomaia

Fred_CIT wrote:

That is absolutely true, but it's not my question. [-X

The question is: What happens to the 'VAT Registration No.' and 'VAT Country/Region Code' fields. Is this right?

If my G/L Setup setting is 'Bill-to/Pay-to No.', I expect both fields to be filled with the values of the Bill-to Customer.
And with the 'Sell-to/Buy-from No.' setting both fields filled with the values of the Sell-to Customer.

Now the 'VAT Registration No.' is always coming from the Sell-to Customer and 'VAT Country/Region Code' is always coming from the Bill-to Customer. Regarding the setting 'Bill-to/Sell-to VAT Calc.' in de G/L Setup. This cannot be right!

Yes that is wrong.
Only VAT business posting group will be updated. I can’t tell what is the purpose of that filed since only field is updated. In Portugal that field useless

Fred_CIT

@Tino Thanks, off course i'm a rookie

@nunomaia Thanks, we have the same conclusion.