Dear Team,

The Sales Tax Detail Report's "Tax Code" filters are not working as required.

This has been tested in a demo database in version 949.

Steps to replicate:

1. Login into POS
2. Make a sale of a product "01078"
3. Process this
4. Generate the Sales Tax Detail Report without any filters
   • The report displays the figures correctly - Figure 1
5. Filter the same report by:

• Tax Code 1: TAXIN Amount Inclusive of Tax [9.00% Inclusive]
• The Taxin column is blank - Figure 2

Figure 2

Please take a look.

Regards
Aarti

Hi Alvis, 

I have studied the case. According to "LT_RPT_POS_SalesTaxDetails" data for the Tax Code filter is coming from "LBS_POS_OrderDetailTax" table.

This table uses the "tax code" from the details, but the report filter is loading the tax code from the header.

For Example, the report filter loads "Tax Code" as "TAXIN". When I run the report, the tax breakdown is 0, refer to Figure 1. However, when I run the report with tax code as "A", data is populated, refer to Figure 2.

Figure 1.Sales Tax Detail Report with TAXIN filter

Figure 2: Sales Tax Detail Report with A filter.

Please correct this.

Thanks
Rashna

1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

1. Changed report parameter description to: "Tax Detail Code" and look up to list data from tax details.
2. Changed report title to "Sales Tax Detail Report"
3. Changed Tax Maintenance form in back-office to display "Tax Detail Code" instead of "Tax Code"