Landed Cost Import Format

A

1

Record Type

1

Character

Yes

Enter P to import a landed cost for a product.

Enter L to import a landed cost for a product and location.

B

2

Product Code

40

Character

Yes

Enter the product code for the landed cost. For information on setting up product codes, see Product Maintenance.

C

3

Location Prefix

3

Character

Yes, only if L is entered for the Record Type field

Enter the location prefix for the landed cost. For information on setting up location prefixes, see Location Maintenance.

D

4

Charge Type

10

Character

Yes

Enter an additional charge type if you want to enter an additional charge associated with the product's landed cost. You can only enter additional charges for which the Include in Landed Cost check box is selected in Purchase Additional Charge Maintenance.

E

5

Amount

11

>>,>>9.9999

Yes

Enter the amount of the landed cost.