Stock Control Import
Information on the requirements for the Stock Control Import available in RMS.
Import Information
- The file to be imported must be in a comma delimited .csv format.
- Microsoft Excel is able to save using a .csv format that should match these requirements.
- The fields within this file must not contain commas.
- RMS is able to determine whether the first record is a header record.
- Corresponding Sundry Charges must exist in RMS prior to commencing this import.
Field Order
Order | Field Name | Field Type | Required | Max Characters | Description | Notes |
---|---|---|---|---|---|---|
1 | Sundry | String | Y | 50 | Name of Sundry Charge | Must already exist in the database |
2 | Supplier | String | Name of Supplier | Must already exist in the database | ||
3 | StockCategory | String | Stock Category | Must already exist in the database | ||
4 | StockSubCategory | String | Stock SubCategory | Must already exist in the database | ||
5 | StockLocation | String | Stock Location | Must already exist in the database | ||
6 | PartNumber | String | Part Number | |||
7 | PropertyName | String | Y | Property Name | Must already exist in the database | |
8 | InStock | Number | Current Stock Level | This number will set the current level regardless if an in stock level already exists for that sundry | ||
9 | ReOrderLevel | Number | ReOrder Level |
|