I’m setting up Sales Tax Reporting and I’m getting weird results in the Calculations… possibly human error. Grand Total Lines seem to be adding themselves to other totals, sometimes twice.
In this case, it’s not possible for me to use line 13 (a total, not a group) in another total in the Grouping screen. How did it get included in Calculation Rule? What am I doing wrong? Version 2022 R1.
Here are my Reporting Groups. I expect group 8 to be in 4 calculations (total lines 12, 13, 14, 15) and 13, 14 to not be used in Calculation Rule column:
Thank you in advance for your advice!
Best answer by Laura02
Here are the steps I completed to solve my weird sales tax reporting problem.
Deleted all lines out of Sales Tax Reporting Groups screen for the Tax Agency.
In Sales Tax Reporting Settings, I created a new report version (this action creates a copy of the previous report version).
I deleted all data from both tabs of the new report version in Reporting Settings screen, Saved the blank report version, and then retyped the Sales Tax Reporting lines and Sales Tax Reporting Groups “from scratch.”
On the second try, the Calculation fields look normal. I guess the problem was caused by revising version 1 of the report several times, causing ‘hidden’ records or report lines (orphans/database residue) that no longer existed in a usable condition to mingle with newer versions of the report. Hope this helps someone.
There’s no way I added lines 13 and 14 in -- the second screen shot displays the list of first 8 lines I must choose from when creating the totals. I am not able to choose 13 and 14.
I’d like to post an Idea for improving Sales Tax Reports, but I don’t have a suggestion yet. The order of implementation is to configure Tax Report Groups first, so when we add Taxes we can connect them to a Report Group.
After importing taxes, categories, zones, we test and on this last Testing step we find out report groups need improvement…. it’s too difficult to change the tax groups - even if tax report wasn’t released. Am I missing something? If so I hope someone will point out my error. The system lets me change the reports but I see the weird results above.
I know there is also a Revision system we can use when reports have been prepared & released that I’ll try next. If I can’t get around the problem then I’ll copy the Tax Agency Vendor, assign all taxes to the new vendor and create a brand new report and try to get it Absolutely Perfect on the first go because…. correcting reports is not working for me.
I’ll post back later if I find a different answer.
There’s no way I added lines 13 and 14 in -- the second screen shot displays the list of first 8 lines I must choose from when creating the totals. I am not able to choose 13 and 14.
I’d like to post an Idea for improving Sales Tax Reports, but I don’t have a suggestion yet. The order of implementation is to configure Tax Report Groups first, so when we add Taxes we can connect them to a Report Group.
After importing taxes, categories, zones, we test and on this last Testing step we find out report groups need improvement…. it’s too difficult to change the tax groups - even if tax report wasn’t released. Am I missing something? If so I hope someone will point out my error. The system lets me change the reports but I see the weird results above.
I know there is also a Revision system we can use when reports have been prepared & released that I’ll try next. If I can’t get around the problem then I’ll copy the Tax Agency Vendor, assign all taxes to the new vendor and create a brand new report and try to get it Absolutely Perfect on the first go because…. correcting reports is not working for me.
I’ll post back later if I find a different answer.
Thanks again.
My only next idea would be to ask Acumatica support. It’s odd that 13 is there twice and you cant seem to add it.
Here are the steps I completed to solve my weird sales tax reporting problem.
Deleted all lines out of Sales Tax Reporting Groups screen for the Tax Agency.
In Sales Tax Reporting Settings, I created a new report version (this action creates a copy of the previous report version).
I deleted all data from both tabs of the new report version in Reporting Settings screen, Saved the blank report version, and then retyped the Sales Tax Reporting lines and Sales Tax Reporting Groups “from scratch.”
On the second try, the Calculation fields look normal. I guess the problem was caused by revising version 1 of the report several times, causing ‘hidden’ records or report lines (orphans/database residue) that no longer existed in a usable condition to mingle with newer versions of the report. Hope this helps someone.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.