2,488
Hello Experts,
Is it possible to show one line in posted sales tax per tax code which will be the sum of all sales tax on each sales order line provided sales tax on each line is same?
Suppose, Line 1 is having item A & sales tax group is XXX and Line 2 is having item B and sales tax group is XXX. As the sales tax group is same on both the lines, there should be one line created in posted sales tax which would be the same of line 1 & line 2 sales tax amounts.
Thanks & regards,
Raziq Ali
Hello Raziq,
With the new grid control feature you can group the tax transactions in the online form by tax code.
You can also calculate an overall total of each column but not by group.
At least I have not been able to get this work.
An alternative is exporting the data to excel and then doing the grouping and calculations e.g. in a pivot chart.
Best regards,
Ludwig
Share
Report
All responses (
Answers (
