Show TOC

Background documentationInventory Upload Trigger File Format

 

File [UPLOAD.ASC]

This file supports the Inventory Upload feature in Store Manager and is used to define the dates to trigger the upload extract for that function. At End-Of-Day a search is carried out to determine if any uploads are to be generated for the current EOD. If the search results are positive, the upload extract function is run. An inventory file is created containing inventory information for each PLU. The output of this process is placed in the POS Server’s upload directory. During the End-of-Day process (EODPROC.BAT), a custom program reads the inventory file and produces the monthly, weekly. and/or reorder inventory files.

The counterpart file for this function is the Inventory Upload file format.

The file is comma delimited and downloaded in its entirety when a change is made. The file sent to a store defines the triggering requirements for that store. This format can only be used for a Store Manager Deluxe license version of the software.

Note Note

The time period must be configured as daily inventory totals and not monthly inventory.

End of the note.

Field Number and Name

Length/Type

Possible Values

1 Store Number

Decimal 6.0

1 - 999999

No check is done on this field at the store.

2 Type

Decimal 1.0

1 - Inventory

Used to determine the type of function to trigger. Only type 1 is implemented at this time.

3 End-Of-Day

String 10

YYYY/MM/DD

The EOD business date on which to trigger the extract.

4 From Date

String 10

YYYY/MM/DD

Date to start the accumulation of sales quantities (inclusive.)

5 To Date

String 10

YYYY/MM/DD

Date to end the accumulation of sales quantities (inclusive.)

6 Identifier

Decimal 4.0

Used in naming the output file. The output file name would have format SSSSDDDD.dat where SSSS is the store number and DDDD is the identifier.

7 Drive and path of directory

String 256

If the directory does not exist then the directory will be created (only one level.) If no directory is specified or the directory cannot be created, then the POS Server’s upload directory is used.