Hi,

We're very new to Sage 100 and are currently in the middle of our data migration phase, moving over from another ERP system. In looking at importing our BOM's, we're running into two issues with the comment line data:

1. We use a number of carriage/hard returns for multiple lines of text in the comment field. Sage allows multiple lines of text for this field, but the import file is interpreting the second line of text as a completely new entry. How can we format the import file to properly import these multiple lines of text for this field?
2. Any instances of the quote mark being used (") is replaced with a double quote ("") when we convert our excel import template into a CSV. This results in double quotes being imported that way into Sage. How can we prevent this? Will the import still work if we use a find and replace method on the CSV to remove all single quotes (") and then replace all double quotes ("") with a single quote (")?

Please see below for screenshot of example CSV. Any help or feedback would be greatly appreciated.

Thank You!