Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Tax/VAT codes transactions missing depending on Legal entity using Virtual Tables

(1) ShareShare
ReportReport
Posted on by 44
HI Everyone,
 
Appreciate you help here, this very critical. We have five legal entities in same country; they share the same tables for Tax Groups, Item Tax Groups and tax codes using virtual tables.
 
The problem comes when making an order the tax matrix Tax matrix  is working for some companies and not for other companies.
 
for example: On one legal entity when selling a Tax free item to a domestic client the Vat code ZERO "shows correctly in VAT transaction" but if I make the same order in another legal entity No TAX code appears in the Tax transactions (like a missing i join). The only difference that I see is in the the TaxOnItem and TaxGroupData the RecVersion is 1, I dont know if this has any meaning.
 
again greatly appreciated for your time and support.
 
 
                      VAT group = Cust/Vend


Item VAT group = Items                      
S-DOM S-EU S-EU-full S-3RD P-DOM P-EU P-3RD
A  - Full VAT of goods and services doA  euA *(Exempt) euA 3rdA (Exempt) doA  euA **(Use tax) 3rdA 
B  - reduced VAT (processed foods) N/A N/A N/A N/A doB euB N/A
C - reduced VAT (natural foods) N/A N/A N/A N/A doC euC N/A
ASSET - VAT on assets N/A N/A N/A N/A doASSET N/A N/A
FUEL - VAT on fuel - half to be deducted N/A N/A N/A N/A doFUEL N/A N/A
ZERO - Tax free ZERO ZERO ZERO ZERO ZERO ZERO ZERO
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at
    Tax/VAT codes transactions missing depending on Legal entity using Virtual Tables
    Hi CBNestor,
     
    The record version 1 indicates that the record itself was never changed. That is not related to your issue. Can you provide a list with all Tax related tables part of the virtual company? Do you have one or more virtual companies?
     
    Can you also explain what you shared in the VAT group overview table?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans