Import from Excel format includes line comments print flags

Four columns are added to the Sales Order Entry-Import From Excel function to indicate the documents on which line comments on an imported order are printed. This augments an earlier enhancement that supported printing line comments on Delivery and TWL Packing documents. Now, when you import sales orders with line comments, you can also indicate all documents on which those comments should be printed.

These new columns are added:
  • Print Invoice
  • Print Ack
  • Print TWL Pack
  • Print Delivery

A value of Yes in any column overrides the Print Option selection for the order and replaces it with the new selections.

Note: The columns may be in any order, but each heading must be spelled exactly as noted.

Line comments in an Excel import file are now formatted in the Line Information section as:

Excel Column A B O
Heading Product Description Print Option
Row 11-999 Values COMMENT This is the comment text. Yes
Excel Column P Q R S
Heading Print Invoice Print Ack Print TWL Pack Print Delivery
Row 11-999 Values Yes Yes Yes Yes

If the values in the Print columns (noted above as columns P-S) are all No, the Print Option selection is applied. And, if Print Option is Yes, line comments are printed on the Invoice and Acknowledgment documents only. A value of Y or Yes is treated as YES, and any other value in these columns is treated as NO.

Note: The columns can be added anywhere after Column B. The position of the new columns is not important. The import process extracts the data in a column based on its heading text.

Feature activation

Update all of your Excel files used to import sales orders in Sales Order Entry-Import From Excel to add the new columns to enable printing line comments on additional documents..