Inbound Tax Report Sum by tax code

Issue No: AP-6547
Created 8/13/2018 12:16:28 PM
Type Gap
Priority Major
Status Closed
Resolution Fixed
Fixed Version 19.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-225396 - BPR - Tax Reporting Menu - Inbound Tax Report|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-225396] This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-207860 - 19.1 How do I print a sales tax free report? - MFT and Other tax reporting.|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-207860]     This is to create the report in the software. This is linked to a previous task created for a customer using dashboard. This will eliminate the use of dashboard query.     # There is an inbound tax report in Purchasing # It does not suffice origin and ease of filing tax returns. # Inbound Tax report looks at receipt detail and not voucher detail. # When they file taxes the totals are based on received product. # Which means, they may have received in inventory, but have not recieved the voucher from the vendor.   This report should include all receipts for the time selected, including AP clearing. The date is based on Receipt Date, *not* voucher date.   Origin   Vendor - In origin this is the vendor ship and not pay to vendor. All receipts entered in origin are from the ship from vendors.   Item - Item code   Location - Company Locations   Class - Item Category   Carrier - Carrier   Origin - This is a text field in origin during receipts. In i21, this is the ship from vendor location In i21, this is the ship from vendor location state (Change the field to "Origin State").   Receipt Date - Receipt Date including AP clearing   Vendor Tax State - In origin vendor maintenance has a tax state setup, in i21, this is the vendor ship from state (Origin state)   Additional fields that will help using i21 MFT per [~wei.chen]   * Tax Code Filter * Destination State (ship to company location)   !pastedImage_d103035_0.png!   With tax amount amount checked.   !pastedImage_d103035_1.png!   Bottom recap total.   !pastedImage_d103035_2.png!       *With tax amount unchecked.*   !pastedImage_d103035_3.png!   Bottom recap total   !pastedImage_d103035_4.png! !pastedImage_d103035_5.png!