The values used in the report for taxes is incorrect.
The values the report is currently using are the "Total" value that includes the tax amount added to the previous line amount. In the screen shot below, you can see the values from the "Total" column are the numbers in the report.
The numbers that should be used are those in the "Amount" column.
Please let me know if this is unclear. We need the data source for the taxes to be corrected.
Additionally, in the case of the tax being "NCEXEMPT" the "Amount" column is left blank. However, when that is used in the report it should be "0" because blank is not valid.
The values used in the report for taxes is incorrect.
The values the report is currently using are the "Total" value that includes the tax amount added to the previous line amount. In the screen shot below, you can see the values from the "Total" column are the numbers in the report.
The numbers that should be used are those in the "Amount" column.
Please let me know if this is unclear. We need the data source for the taxes to be corrected.
Additionally, in the case of the tax being "NCEXEMPT" the "Amount" column is left blank. However, when that is used in the report it should be "0" because blank is not valid.
BKM