Contact Support


    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

    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Contact Support