Atrieve Finance
Atrieve Finance
Breadcrumbs

Stock File Interface

Non inventory stock items can be imported into the TSC stock file using this interface.  A fixed or delimited file is supported.

Import File Directory:

  • Enter the directory where the file is located. The default is your login directory. The directory will be the directory that was FTP'd to.

Import File Name:

  • Enter the file name that was used for the import file. The default is STOCK.EXP. 

Year to Process:

  • Enter the stock file year that the stock items will be imported to. The default is the current stock file year, defined in the ATS master profile.

Commodity Code:

  • Enter the commodity code to be assigned to the stock items. Only one commodity code can be selected. Use the Lookup, to access a list of available commodity codes.

Category Code:

  • The category code will default to 'N' (non-inventory stock). Only non-inventory items can be created through this import. This prompt may be used for a future enhancement to allow inventory items to be imported.

Preliminary/Final Processing

  • Enter 'P' to run in preliminary mode. A report will be created, however, the stock items will not be created.

  • Enter 'F' to import the stock items. A report will still be generated.

It's recommended that the import is run in preliminary mode first. The report that is produced includes a status and error message column.

Status messages:

  • Created - This is a new stock item that did not previously exist.

  • Update - This is an existing stock item that will be updated only.

  • <Blank> - A blank status indicates that there is an error with this stock item. The stock item will not be created.

Error messages:

  • Invalid Purchase UPM -  This field requires a numeric value.

  • Invalid Issue UPM - This field requires a numeric value.

  • Invalid Cost Price - This field requires a numeric value. Commas and dollar signs also need to be excluded.

  • Invalid Tax Code  The tax code does not exist within the 'Tax Code Database' in atrieveFinance.

  • Stock Category does not match The stock item being updated has a category code of 'I'. It cannot be updated by this import.

Notes:

If a tax code is not defined for a stock item, the default GST tax code defined in the atrieveFinance master profile will be assigned to the stock item.

The vendor purchase history will be updated with an entry titled 'ATS Price Initialization'.