Customer Remark Import Format

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

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

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Customer Code

12

Character

Yes

Enter the customer code for the remark.

Note If you enter a remark for a billing customer, the remark is displayed for all related customers. For more information, see Structure and Concepts.

B

2

Invoice Remark

3

Yes/No

No

Enter Yes to display the remark on invoices.

C

3

Order Acknowledgment Remark

3

Yes/No

No

Enter Yes to display the remark on order acknowledgments.

D

4

Drop Ship Purchase Order Remark

3

Yes/No

No

Enter Yes to display the remark on drop ship purchase orders.

E

5

Pack List Remark

3

Yes/No

No

Enter Yes to display the remark 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

Bill of Lading Child Remark

3

Yes/No

No

Enter Yes to display the remark on bills of lading.

H

8

Bill of Lading All Children Remark

3

Yes/No

No

Enter Yes to display the remark on all bill of lading children.

I

9

Chargeback Remark

3

Yes/No

No

Enter Yes to display the remark on chargebacks.

J

10

Collection Statement Remark

3

Yes/No

No

Enter Yes to display the remark on collection statements.

K

11

       

This field is not used.

L

12

NSF Invoice Remark

3

Yes/No

No

Enter Yes to display the remark on NSF invoice forms.

M

13

Purchase Order Remark

3

Yes/No

No

Enter Yes to display the remark on purchase orders.

N

14

Work Order Remark

3

Yes/No

No

Enter Yes to display the remark on work orders.

O

15

Remark

10000

Character

Yes

Enter the actual remarks to be printed on the selected documents.

P

16

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.

Q

17

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.

R

18

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.

S

19

Pick Demand - Wireless Remark

3

Yes/No

No

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

T

20

Pick Demand - Paper Remark

3

Yes/No

No

Enter Yes to display the remark on printed pick demands.

Prerequisites

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

Import Format Notes