How to load Customers without Customer Number, Account Number using FBDI

Summary:

We have a requirement to load new customers into the application (Accounts Receivables) using the extracted data from source system (eBS) which do not have the Party Number, Account Number or any references. These values (which are null in the import file) should be autogenerated during import process. We tried the following but encountered an error:

Approach #1: FBDI CSV file generation using Upload Customer Template

Result: No csv file was generated and a message prompt was displayed:

Upload Customers: You must enter a value in the “Customer Number” attribute at row #6 in the Customers worksheet. Detailed steps can be found in the attached file.