Hi,
I would like to know which tables holds the tax group, tax code and tax amount for each purchline (not invoiced) ?
Thanks in advance.
Best Regrads
D365FO_Dev
Hi,
Please check the table TaxItemGroupHeading for the field ItemTaxGroup,TaxGroupData table for the field TaxGroup,TaxTable table for the field TaxCode to see if it meets your requirements.
I checked in PROD environment and we are not filing up theses tables TAXDOCUMENTROWTRANSACTION, TaxDocumentComponentTransaction
Do you have any purchlines with tax in your dev vm? If not please ask the fc to repro. Then from my previous response you can use those table to make a query and find the tax data.
Issue is still unresolved.
May be you guys have any other pitch to play around?
Hi Bharani,
I just call the table data with systablebrowser as an admin.
Hi Charlotte, unfortunately it does not help. Still no solution
Can you show us the query you have given?
Hi,
Please refer to the posts in the following link:
Is there a table that holds TaxGroup, ItemTaxGroup AND TaxCode? (dynamics.com)
Hi,
both of these tables are empty.
Please suggest any alternative way around.
Best Regards
Hi,
You can use TAXDOCUMENTROWTRANSACTION, TaxDocumentComponentTransaction tables to get the required data. Make a relation of PurchLine with TAXDOCUMENTROWTRANSACTION and TAXDOCUMENTROWTRANSACTION with TaxDocumentComponentTransaction.
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156