Data entity: Customers V3
Data entity: Vendors V2
Data entity: Customer Postal Addresses
We are loading master data. Customers and Vendors have mailing/business addresses that need to be imported into D365.
In SAP, the address data is captured in separate fields. There is a Street1, and a Street2, etc.
In D365, there is a single field that contains the street address information. This field ADDRESSSTREET presents the address block, for example:
123 Main Street
Building A
Office No. SO541
When entering the address data in D365 manually, the user must use the carriage return to separate the rows, so that they present as a proper address block on forms, identical to the above example.
The ISSUE: Our SAP program extracts the data and populates the ADDRESSSTREET field. This is a single field in the template. So, it is in a single string. In this example it would be:
123 Main Street Building A Office No. SO541
When this imports into D365, it is a WRAPPED string. There are no distinct rows, with carriage returns to stack the address.
Our question: what 'special' code is used to cause the import program to recognize the carriage return in this string? I'm certain we are not the only client to face this data migration issue.
Our developer found a suggestion to insert /n/r where a carriage return is needed. That didn't work.
Thanks for your help.
