Tax Report Grid shows Taxable and non-taxable sales incorrectly

Issue No: AR-5000
Created 7/17/2017 9:49:58 AM
Type Bug
Priority Major
Status Closed
Resolution Fixed
Fixed Version 17.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-202965 - iRely Tax Grid|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-202965] This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-201939 - Tax Grid|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-201939] This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-201420 - The sales Tax Report Grid does display correct Information|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-201420] This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-199460 - 17.1 Tax Report Grid|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-199460] Version: 17.1.0712.110   Database: T1   *Steps to recreate:*   Sales > Tax Report Grid.   *Issue: The Taxable sales and non-taxable sales are showing the incorrect balances. It is showing the same amount on each line of the invoice.*   *It should show the following:*   * *Taxable sales = line total per rate* * *Non-taxable sales = line total per rate* * *Total Sales = Invoice subtotal (not including tax)* * *Invoice tax = line total per rate* * *Tax collected = invoice total* * If by % ** SI-1 *** Line #1 **** Unit Sold X Unit Price = 100 widgetA X $1.00 = $100.00 = Taxable Sales **** $100.00 X 7% = $7.00 = Invoice Tax **** $28.00 = Tax Collected **** $100 + $ 300 + $600 = $1000 Total Sales *** Line #2 **** Unit Sold X Unit Price = 200 widgetB X $1.50 = $300.00 = Non-taxable Sales **** $350.00 X 0% = $0 = Invoice Tax **** $28.00 = Tax Collected **** $100 + $ 300 + $600 = $1000 Total Sales *** Line #3 **** Unit Sold X Unit Price = 300 widgetC X $2.00 = $600.00 = Taxable Sales **** $600.00 X 7% = $21.00 = Invoice Tax **** $28.00 = Tax Collected **** $100 + $ 300 + $600 = $1000 Total Sales * If by Unit * SI-2 ** Line #1 *** Unit Sold X Unit Price = 100 widgetA X $1.00 = $100.00 = Taxable Sales *** 100 widgetA X .05 cents per widget = $5.00 = Invoice Tax *** $20 = Tax Collected *** $100 + $ 300 + $600 = $1000 Total Sales ** Line #2 *** Unit Sold X Unit Price = 200 widgetB X $1.50 = $300.00 = Non-taxable Sales *** 200 widgetB X .0 cents per widget = $0 = Invoice Tax *** $20 = Tax Collected *** $100 + $ 300 + $600 = $1000 Total Sales ** Line #3 *** Unit Sold X Unit Price = 300 widgetC X $2.00 = $600.00 = Taxable Sales *** 300 widgetC X .05 cents per widget = $15.00 = Invoice Tax *** $20 = Tax Collected *** $100 + $ 300 + $600 = $1000 Total Sales