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.
- 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.
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.
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..