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
|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.|