Physical Accounting
You can use a hand-held bar code device to conduct your physical counting event. To ensure data transfer accuracy, first configure the download and upload file formats for the counting sheet according to the layout presented in the next table. All fields must be left-justified, with a space between each field.
| Field | Comments | Format |
|---|---|---|
|
INV_ITEM_ID |
Required. |
Char 18 |
|
STORAGE_AREA |
Required. |
Char 5 |
|
STOR_LEVEL_1 |
Required, if set up for the storage area. |
Char 4 |
|
STOR_LEVEL_2 |
Required, if set up for the storage area. |
Char 4 |
|
STOR_LEVEL_3 |
Required, if set up for the storage area. |
Char 4 |
|
STOR_LEVEL_4 |
Required, if set up for the storage area. |
Char 4 |
|
UNIT_OF_MEASURE |
Required. Must contain the stocking unit of measure (UOM) at the location. |
Char 3 |
|
STAGED_DATE |
Required. If the item is staged-date controlled, this field must contain the appropriate staged date. If the item is not staged-date controlled, include the filler default value that you established on the Installation Options - Inventory page in the Installation Options component. |
MMDDYYYY |
|
SERIAL_ID |
Required. If the item is serial-controlled, this field must contain the appropriate serial ID. If the item is not serial-controlled, include the filler default value that you established on the Installation Options - Inventory page in the Installation Options component. |
Char 20 |
|
INV_LOT_ID |
Required. If the item is lot-controlled, this field must contain the appropriate lot ID. If the item is not lot-controlled, include the filler default value that you established on the Installation Options - Inventory page in the Installation Options component. |
Char 15 |
|
CONTAINER_ID |
Optional. |
Char 10 |
|
QTY |
Required. Must contain a quantity; zero is valid. |
Nbr 16 |
|
UNIT_OF_MEASURE_COUNT |
Required. Must contain a valid UOM for the item. If this UOM is different than the stocking UOM noted above, then the quantity is converted to the stocking UOM before updating the database. |
Char 3 |
|
ITEM_DESCR |
Optional. For informational purposes only. |
Char 30 |
|
COUNT_DTTM |
Must contain a date. If the field is blank then the system does not update the row. |
MM/DD/YYYY HH:MI:SS |
Related Topics