CLONE - Missing customer and Bill To Null in ptcusmst when creating new customer in i21

Issue No: AR-11686
Created 3/26/2020 11:51:23 AM
Type Bug
Priority Critical
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-246411 - House Charges not importing from store report|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-246411]       This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.     [HDTN-245102 - STORE HOUSE CHARGES NOT IMPORTING TO SALES IN I21|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-245102]     This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.     [HDTN-243936 - C-STORE CUSTOMER CHARGES NOT IMPORTING TO i21 sales|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-243936]     This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-242580 - AR charged not importing from C-stores|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-242580]     This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-209300 - 18.1 Missing House Charges - store 2017 on 1/29/18|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-209300]     Bill To Customer Code NULL.     17.3.0129.   *Steps to recreate:*   1. Create a new customer in i21.   !pastedImage_d131821_0.png!   2. Save   3. *Issue #1* Search the ptcusmst table for the customer created. Notice it is missing.   select ptcus_bill_to,* from ptcusmst where ptcus_cus_no like '%TEST%'   4. Bring up the customer again in i21 and change one of the fields and save.   5. Search the customer in ptcusmst table and now it is there.   select ptcus_bill_to,* from ptcusmst where ptcus_cus_no like '%TEST%'   6. *Issue #2* , ptcus_bill_to is Null. This should equal the Bill To entity No selected in the Customer in i21. When ptcus_bill_to is blank, it cause the issue in http://jira.irelyserver.com/browse/AR-6678   !pastedImage_d131821_1.png!     *To Do:*   1. Update program to save the customer information to the ptcusmst table   2. ptsuc_bill should equal the 'Bill To' entity number selected for the customer in i21   3. Make the 'Bill To' section in the customer information mandatory (if this is not already).