Announcements
No record found.
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 RegradsD365FO_Dev
Hi,
You can use TAXDOCUMENTROWTRANSACTION, TaxDocumentComponentTransaction tables to get the required data. Make a relation of PurchLine with TAXDOCUMENTROWTRANSACTION and TAXDOCUMENTROWTRANSACTION with TaxDocumentComponentTransaction.
both of these tables are empty.
Please suggest any alternative way around.
Best Regards
Please refer to the posts in the following link:
Is there a table that holds TaxGroup, ItemTaxGroup AND TaxCode? (dynamics.com)
Can you show us the query you have given?
Hi Charlotte, unfortunately it does not help. Still no solution
Hi Bharani,
I just call the table data with systablebrowser as an admin.
Issue is still unresolved.
May be you guys have any other pitch to play around?
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.
I checked in PROD environment and we are not filing up theses tables TAXDOCUMENTROWTRANSACTION, TaxDocumentComponentTransaction
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.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 515 Most Valuable Professional
André Arnaud de Cal... 417 Super User 2026 Season 2
CU10121822-0 360
