Load Inventory - SIUTLI
The SIUTLI utility will create/replace inventory information for a product in BusinessPlus from a comma-delimited flat file data. The process will delete all transaction history for a given product/warehouse when "replacing" duplicate inventory data.
You will be prompted for:
- How you want to handle duplicate data (replace inventory in BusinessPlus or report duplicates on the tail sheet).
- The name of the input file. This file must reside in the data directory.
- The product flat file must be comma-delimited in the same format as if it were exported from Excel. The bolded fields cannot be blank.
Common code SIUT/INV is required for the SIUTLI interface. It is used to populate values in the transaction and inventory details when the values in the input file are blank.
Inventory File Format
Col | Contents | Format (Max Length, Decimals) |
|---|---|---|
A | Product ID | CHAR(16) |
B | Warehouse | CHAR(4) |
C | Quantity | NUMBER(10) |
D | Total FIFO Value | NUMBER(20,2) |
E | Bin | CHAR(10) |
F | Floor | CHAR(2) |
G | Row | CHAR(6) |
H | Shelf | CHAR(4) |
I | Status | CHAR(2) |
J | FIFO Cost | NUMBER(10,2) |
K | LIFO Cost | NUMBER(10,2) |
L | Average Cost | NUMBER(20,5) |
M | Committed | NUMBER(10) |
N | On Order | NUMBER(10) |
O | Back Ordered | NUMBER(10) |
P | Miscellaneous Code | CHAR(4) |
Q | Order Point | NUMBER(10) |
R | Calculation Code | CHAR(2) |
S | Maximum Allowed | NUMBER(10) |
T | Safety Stock | NUMBER(10) |
U | Minimum Supply | NUMBER(10) |
V | Maximum Supply | NUMBER(10) |
W | Supply Expressed In | CHAR(2) |
X | Order Limit | NUMBER(10) |
Y | Oldest Date | DATE (MM/DD/CCYY) |
Z | Age Expressed As (D/M/W/Y) | CHAR(2) |
AA | Bundle Amount | NUMBER(10) |
AB | Bundle Percentage | NUMBER(5) |
AC | Last Activity Date | DATE (MM/DD/CCYY) |
AD | Last Count Date | DATE (MM/DD/CCYY) |
AE | Substitute Product | CHAR(16) |
AF | Multiplier | NUMBER(10,3) |