Issue -- Manage invoice lines error "ORIG_SYSTEM_BILL_ADDRESS_REF is invalid"

Issue: Error in Auto Invoice lines: The original system bill-to customer address reference {ORIG_SYSTEM_BILL_ADDRESS_REF is invalid. Due to this issue, users cannot import transactions transferred.

Solution:

Please follow the below steps for the downloaded “ManageAutoInvoiceLines.xlsx”:

1. Fill in the customer number in all rows in column OA "BillCustomerAccountNumber".

2. Fill in the site number in all rows in column OB "BillCustomerSiteNumber".

3. Delete values from columns HR "OrigSystemBillAddressRef" and HU "OrigSystemBillCustomerId".

4. Click on upload, click on search and click on submit. This should resolve the issue.

If the issue still not resolved, then please check if the Customer for whom transaction is created does have valid profile for the transaction date. If no site profile exists at account site, then please create profile as on transaction date to resolve this issue.
 

 

To implement the solution, please execute the following steps:

1. Navigate to Billing Work area > Manage Customers.

2. Search for Customer and click edit customer account or site

3. Create an active profile such that profile is active as on transaction date and click save and close.

Issue get resolved.