Tax information for each purchline

(0) Share

Report

Posted on by D356FO_Dev

144

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

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can use TAXDOCUMENTROWTRANSACTION, TaxDocumentComponentTransaction tables to get the required data. Make a relation of PurchLine with TAXDOCUMENTROWTRANSACTION and TAXDOCUMENTROWTRANSACTION with TaxDocumentComponentTransaction.

Was this reply helpful? Yes No
D356FO_Dev 144 on at

Like (0)

Report
Copy link

Link copied!

Hi,

both of these tables are empty.

Please suggest any alternative way around.

Best Regards

Was this reply helpful? Yes No
Suggested answer

Charlotte X Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please refer to the posts in the following link:

Is there a table that holds TaxGroup, ItemTaxGroup AND TaxCode? (dynamics.com)

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you show us the query you have given?

Was this reply helpful? Yes No
D356FO_Dev 144 on at

Like (0)

Report
Copy link

Link copied!

Hi Charlotte, unfortunately it does not help. Still no solution

Was this reply helpful? Yes No
D356FO_Dev 144 on at

Like (0)

Report
Copy link

Link copied!

Hi Bharani,

I just call the table data with systablebrowser as an admin.

Was this reply helpful? Yes No
D356FO_Dev 144 on at

Like (0)

Report
Copy link

Link copied!

Issue is still unresolved.

May be you guys have any other pitch to play around?

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
D356FO_Dev 144 on at

Like (0)

Report
Copy link

Link copied!

I checked in PROD environment and we are not filing up theses tables TAXDOCUMENTROWTRANSACTION, TaxDocumentComponentTransaction

Was this reply helpful? Yes No
Suggested answer

huijij 19,811 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No