Origin GAP - Print tblARInvoice.strInvoiceOriginId on Customer statement

Issue No: AR-4896
Created 6/26/2017 7:04:43 AM
Type Gap
Priority Major
Status Closed
Resolution Fixed
Fixed Version 17.3
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-197919 - Customer invoice number from Store on statement in i21 A/R|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-197919] Business Reason: When a customer receives a receipt from the store it will print an invoice number. Then that same invoices number transfers to Origin Petrolac as its invoice number. Then that same invoice number would print on the customer statement.   Since we are importing origin invoices from the store, i21 creates its own invoice number SI-.... We need the origin invoice number to display on the statement like it did in origin. This is the only way to tie out the invoice to the customer's actual receipt received at the store.   Steps to Recreate:   1. You will need customer database to test.   2. Print a customer statement that has transactions from imported invoices from origin. Here are some examples.   select strInvoiceOriginId, * from tblARInvoice where dtmDate = '06/01/2017' select pttic_tic_no, pttic_cus_no, * from tblARptticmst where pttic_rev_dt = '20170601'   3.