We recommend to create an Excel sheet with the columns that need to be updated (possibly first create a report in RamBase and start from that). ACCOUNT must be customer number (without CUS/ in front). In addition, the address fields on the customer (CUS) must be entered: (NAME; FIRSTNAME; POCODE; CITY; CCODE; STATE).


STATE is only required for customers who have COUNTRY: USA / CANADA. A validation of the address is done against the post code archive (POC), so if the address on the customer does not match this, the customer will not be updated. Save the excel file as CSV and load it using INP/58042.