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
The time period must be configured as daily inventory totals and not monthly inventory.
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. |