Product Remark Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Product Remark Import.

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Product Code

40

Character

Yes

Enter a valid product code for which you want to import remarks. For information on setting up product codes, see Product Maintenance.

B

2

Invoice Remark

3

Yes/No

No

Enter Yes to display the remarks on invoices.

C

3

Order Acknowledgment Remark

3

Yes/No

No

Enter Yes to display the remarks on order acknowledgments.

D

4

Drop Ship PO Remark

3

Yes/No

No

Enter Yes to display the remarks on drop-ship purchase orders.

E

5

Pack List Remark

3

Yes/No

No

Enter Yes to display the remarks on pack lists.

F

6

Pick Demand Remark

3

Yes/No

No

Enter Yes to display the remark on both the printed pick demands and handheld devices for Wireless Warehouse picking tasks.

G

7

Purchase Order Remark

3

Yes/No

No

Enter Yes to display the remarks on purchase orders.

H

8

Remarks

10,000

Character

Yes

Enter the remarks to be printed on the selected documents.

I

9

Work Order Remark

3

Yes/No

No

Enter Yes to display the remarks on work orders.

J

10

Start Date

10

99/99/9999

No

Enter the first date for which to display the remark on documents. The date that is compared to this date depends on the document for the remark. For information on which date applies for each document, see Remarks.

K

11

End Date

10

99/99/9999

No

Enter the last date for which to display the remark on documents. The date that is compared to this date depends on the document for the remark. For information on which date applies for each document, see Remarks.

L

12

Repeat Yearly

3

Yes/No

No

Enter Yes to include the remark on documents for the date and month range set up in the Start Date and End Date fields for every year.

Example You enter 1/1/2020 for the Start Date field and 1/31/2020 for the End Date field. You enter Yes for the Repeat Yearly field, and the remark is included on documents during January for 2020, 2021, 2022, etc.

This field is only used if you enter a date for both the Start Date and End Date fields.

M

13

Pick Demand - Wireless Remark

3

Yes/No

No

Enter Yes to display the remark on handheld devices for Wireless Warehouse picking tasks.

N

14

Pick Demand - Paper Remark

3

Yes/No

No

Enter Yes to display the remarks on printed pick demands.

Prerequisites

Before using this import, the following must be set up: