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 |
|
Sample File
Stock Control.csv
How could we improve this answer?