NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Inventory Cost Adjustment Import.
|
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
|
A |
1 |
Product Code |
40 |
Character |
Yes |
Enter a valid product code of the product for which you are adjusting the cost. The product must exist in the warehouse location for which the cost adjustment is to be imported. |
|
B |
2 |
Unit of Measure |
8 |
Character |
Yes |
Enter a valid unit of measure for the cost adjustment. The unit of measure must be a valid unit of measure for the product in the location. |
|
C |
3 |
Location Prefix |
3 |
Character |
Yes |
Enter a valid warehouse (location) prefix for which the cost adjustment is to be imported. |
|
D |
4 |
New Cost |
16 |
>>>>>>>>9.999999 |
Yes |
Enter the new cost for the product in the location. |
|
E |
5 |
Adjustment Code |
10 |
Character |
Yes |
Enter a valid adjustment code for the inventory cost adjustment. Adjustment codes govern the general ledger account that the adjustment will use in posting to the General Ledger module. These codes are defined and maintained in Inventory Adjustment Code Maintenance. |
|
F |
6 |
Remark |
256 |
Character |
Yes |
Enter a remark for the inventory cost adjustment. |
Before using this import, the following must be set up:
products
units of measure
locations
inventory adjustment codes
There must be a record of blank space(s) at the end of an import file.