Sage 100

Importing longgggg extended item descriptions. Client wants extended description to appear below 30c standard. Thanks to prior advice here used Temp fields with $0D$ to create CR between 30c Item Description and Extended. However, Temp field is limited to 60c and I need more than that. Is there a way to do without creating multiple CRs?

You can import to the Comment Text field of the item. I believe it has 2048 characters.

Comment Text is only for /C type.

What are you importing from and to? If you are import to a Sales Order or an SO Invoice, the Comment Field is available for ""non-comment"" item types also.

Importing from CSV file into CI_Item. Populating ItemDescription and ExtendedItemDescription.

In the CSV file, is the standard description and the extended description (A) in the same field, with the first 30 characters always the standard description? Or, (B) the two are separated somehow, either by a char sequence within the field, or just in separate fields within the CSV? If (A), do you have the ability to edit the CSV, placing some type of separating character between the standard & extended descriptions? If you can edit the description field in your CSV, to include a special character at the points where you want Carriage Returns (CRs), you can just refer to the field number in your formula without using a TEMP variable. For example, If your CSV file has the Extended Description in the second field, and you can enter piping ""|"" or some other unique char to represent your CRs, the formula SUB(IMP$[2],""|"",$0d$) should work when importing directly to the ItemCodeDesc field.

Grrrrr ... This worked in 2015. Now throwing error 47 in 2016.