Skip to main content
Skip table of contents

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)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.