In the Invoices Form, Tax Details tab there can be instances where 2 taxes are applied as below.
We need to get both these tax values to the report. I have used this join for that purpose.
But this join takes only one tax ID to the report and the detail lines end up getting duplicated. How can I avoid this issue?
Best answer by TharidhiP
View original
+8
Please see the below link to Acumatica Report Designet for your reference.
https://openuni.acumatica.com/wp-content/uploads/2017/08/S150_Report_Designer_2021R1-1.pdf
+8
you don’t need multiple sub report for tax because when you pass the keys (DocType and RefNbr) to the sub report as parameters, sub report will return and print the applicable taxes.
but if you want multiple sub report (that I don’t believe you need) you can add as many as subreport you want and set visibility conditions on them
+2
To print a specific tax value you can simply specify the tax value in the join as below. You can do this multiple times with different Child Aliases. Sub-reports don’t always like to play nice with the page counter, so we avoid them.
+8
when new tax may be added, you will need to revise all your reports as well.
I have worked with sub reports for many years since Crystal Reports introduced, and unless some rare cases for page breaks, everything works just fine.
+2
if you filter out some taxes, the amount due won’t agree to what is printed or math won’t add up.
LOL, it depends on your math.
when new tax may be added, you will need to revise all your reports as well.
Again, it depends on your logic. Saying “need” is incorrect.
Our implementation works and will remain correct, no matter what taxes are added.
+8
if you filter out some taxes, the amount due won’t agree to what is printed or math won’t add up.
LOL, it depends on your math.
when new tax may be added, you will need to revise all your reports as well.
Again, it depends on your logic. Saying “need” is incorrect.
Our implementation works and will remain correct, no matter what taxes are added.
😅 my math is not so great really.
Not sure where you guys are but for me in Canada that we have many different types of sales taxes ie HST, QST, PST, GST, MVPT, … and rate of each one by Province is different, we have many taxes. The way you suggest I have to left join my document to each single tax type and name them accordingly (that also causes performance issues) and then add each single tax to the bottom of my report but with Sub Report just I will pass to parameters and get the taxes and if new type of tax is added it will work without any maintenance need.
Thank you for your suggestions
Hi, this issue was fixed by using a sub report with the same joins specified. Then I filtered the specific tax IDs and computed the calculations using conditional statements. To ensure two or more different taxes are represented I also used different header sections with visibility conditions. Hope this helps!
Thank you for sharing your solution with the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
