However, if somebody can show me how to get the information directly, I will be appreciated.
Hi @ray20,
ARTaxTran is DAC where this is directly NOT available in the database but this DAC is inherited from the TaxTran DAC (Database table available).
You can get the tax amount directly from TaxTran table by passing the required parameters. Please find the screenshots for reference.
Hope this helps!!
@Naveen B Hello Captain, yes, TaxTran is having the Tax information. But it is having the whole Document. What I am want is by single line. No worries, I already get this information I want. I am just wondering, if I have to recalculate it.
Hi @ray20 Great :)
Just wanted to know that, are you looking for line-level tax information?
@Naveen B Sorry for the late reply. weekend leave. Yes, I am looking for the line-level tax information.
Line-level tax information is only available when using taxes with a line-level calculation rule:
In the case of an AR Invoice, the information will be available in ARTax.TaxAmt; there’s one row per line and tax type. Other modules have similar tables: APTax, SOTax, POTax, etc…
Here’s how it will look in the table if you use line-level tax calculation rules:
In my jurisdiction we use document-level tax calculation, and I would have to manually calculate the tax amount for every line myself to get this information; if you’re using a document-level calculation rule, the calculation you make at the line level will not always match the total tax total on the document because of rounding differences.
@Gabriel Michaud Fantastic, Gabriel, thank you so much for sharing with me the information I didn’t know. You knows Acumatica inside out. It is amazing. Thank you. We are using document-level calculation, so that is why the line level is empty while I check in DB.
Line-level tax information is only available when using taxes with a line-level calculation rule:
In the case of an AR Invoice, the information will be available in ARTax.TaxAmt; there’s one row per line and tax type. Other modules have similar tables: APTax, SOTax, POTax, etc…
Here’s how it will look in the table if you use line-level tax calculation rules:
In my jurisdiction we use document-level tax calculation, and I would have to manually calculate the tax amount for every line myself to get this information; if you’re using a document-level calculation rule, the calculation you make at the line level will not always match the total tax total on the document because of rounding differences.
Thank you so much for sharing this, it has helped me a lot too. Hugely grateful.