Skip to main content
Question

PO Tax Amount in report


Hi! Can anyone help me how to include tax amount under taxes tab in purchase order report base on tax type.

Thank you. I hope to hear your response as soon as posible

 

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 691 replies
  • October 25, 2022

Hi @elcaz! Currently do the amounts not display at all or do they just not display the correct tax amount?

I would expect that you could use an IIF statement to say IIF([POTaxTran.TaxID] = ‘X’, [POTaxTran.TaxAmt], ‘’), then just have one of these for each tax you are trying to display.

It might help though to know what the current behavior is doing and what you are using to get the tax amount (I see a subreport and variables being used?)


  • Author
  • Freshman I
  • 2 replies
  • October 26, 2022
BenjaminCrisman wrote:

Hi @elcaz! Currently do the amounts not display at all or do they just not display the correct tax amount?

I would expect that you could use an IIF statement to say IIF([POTaxTran.TaxID] = ‘X’, [POTaxTran.TaxAmt], ‘’), then just have one of these for each tax you are trying to display.

It might help though to know what the current behavior is doing and what you are using to get the tax amount (I see a subreport and variables being used?)

Hi Si @BenjaminCrisman, it only shows one tax amount in a report section. I want to display sum of tax amount base on the tax id. I created a sub report, and it goes like this:

 

Can you help to solve this issue? Thank you so much.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings