Knapp: Origin records are not importing to i21 AR

Issue No: AR-13014
Created 3/5/2021 10:49:31 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 19.1
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-257885 - Not all Origin Store Customer Charges are not all flowing to i21 AR|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-257885]     {panel:bgColor=#E0EFFF} +This company is on Knapp oils server as company 04+   {panel}   *Issue:*   Marion County Housing Authority called because they have not received a statement. In Sales A/R they do not show anything, however when I pull the stations checkouts they are there. I do have tickets to match what the stations have entered, but it is not pulling into A/R. Could you check this out please?     *Steps to Reproduce:*   # enter customer charges into origin s-store checkout ## Customer account number is MARIONCOHA # post checkout # Ticket flow to Petrolac Ticket Entery (ptticmst) # run import invoice from origin (Sales AR - Import)     *Steps Taken:*   * ran query on the store charges and tblARptticmst ** (table from Petrolc Ticket Entry after i21 import) select * from tblARptticmst where pttic_cus_no='' ** (Store posted checkout table) select * from sthssmst where sthss_rec_type='CRG'and sthss_crg_cus_id='' * they both match with 21 records, but nothing posted to the i21 AR invoice Grid * the customer number matches between origin and i21 ** Note: this is just one sample - I think there are more.   *To Do:*   # Determine why the Import from Origin is not pulling in these records.   !pastedImage_d155265_0.png|height=641,width=792!     !pastedImage_d155265_1.png|height=881,width=958!