Home > Importing Data > Sundry Charges Import

Sundry Charges Import

Overview

This file allows the import of Sundry Charges from a standard Comma Delimited file into the RMS system.

 

You must be able to provide a CSV file in the format as indicated below. It may be necessary to seek technical advice in order to create your file in the format that RMS requires.

 

Sample File - sundrycharges.csv

Important InformationEdit section

  • The file to be imported must be in a comma delimited CSV format.
  • The name of the file must be sundycharges.csv
  • 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 or not, thus it is not necessary to strip the header record (field names) prior to the import

Field Order - All fields must not contain commasEdit section

Order Field Name Field Type Required Max Charaters RMS Equivalent
1 SundryName String Y 50 The name for the Sundry Charge. Must be unique
2 GLCode String Y 30 The GLCode that applies to the Sundry Charge. Must match an existing GLCode in RMS
3 Property String Y   The name of the Property the Sundry is associated to. Leave blank for All properties
4 TaxType Number Y   How this charge is taxed. Valid values below.
5 UnitPrice Number N   The default cost of each item. If not supplied 0 will be used.
6 SecondaryTax_Desc String N 50 The description for any secondary tax that applies to this charge. 
7 SecondaryTax_GLCode String N 50 The GLCode to apply to the secondary tax. Must match an existing GLCode in RMS
8 SecondaryTax_Percentage Number N   The percentage of the charge to be added as tax.
9 Barcode String N 16 The barcode for this sundry charge.
10 CostPrice Number N   The cost price for the sundry charge. If not supplied 0 will be used.

Valid Values

TaxType

  • 3 - Full
  • 2 - Free
  • 1 - Rent
You must to post a comment.
Last modified
12:50, 23 Jan 2015

Tags

Classifications

This page has no classifications.
For support assistance with this article, click once on the Live Support image below
 
btn_LS_on.png