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