Home > Importing Data > Receipt Import

Receipt Import

Overview

This file allows the import of receipt transactions from a standard Comma Delimited file into the RMS system. Other types of financial transactions can also be imported separately using the following file definitions:

 

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.

 

Please Note: Depending on your existing system or source data this file format may vary. Please consult RMS support if unsure

 

Sample File - Pending

Important Information

  • Transactions can only be imported after Reservations have been imported or created in RMS.
  • The file to be imported must be in a comma delimited CSV format (Field Delimiter).
  • If a data field within this file contain commas, it should be surrounded with "double quotes" (Text Delimiter).
  • Microsoft Excel is able to save using a CSV format that should match these requirements.
  • 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
  • Guest Accounts cannot be imported for RMSCentral databases.
  • All Date fields must be supplied in DD-MMM-YYYY format.
  • CreditCardTypes must already exist in RMS
  • Transactions will show as being created by the user 'System Import'.

Field Order - All fields must not contain commasEdit section

Order Field Name Field Type Required Max Characters Description
1 Legacy ID Alpha Numeric Y 50 Legacy System ID. (Imported during previous imports. Used to find the correct account for the transaction).
2 Legacy ID Type Numeric Y 1 Specifies the type of Legacy ID provided for the transaction. Valid values below.
3 Account Type Numeric Y 1 The account type for the Transaction. Valid values below.
4 Date

Date

DD-MMM-YYYY

Y   The posting date for the transaction.
5 Comment Alpha Numeric N 100 Any extra information about the transaction
6 Amount Numeric Y  

The amount for the transaction.

 Should be a positive amount.

7 Receipt Type Numeric

Y

1 The type of receipt for receipt transactions. Valid values below.
8 CreditCardType Alpha Numeric Required if Receipt Type of EFTPOS is provided. 50 The Credit card type for Credit Card receipts. 
9 Cheque Number Alpha Numeric Required if Receipt Type of Cheque is provided   The Cheque Number for Cheque receipts.

Valid Values

Legacy ID Type

Edit section

1 - Res
2 - Guest
3 - Company
4 - Travel Agent
5 - Group Res

Account Type

1 - Accom

2 - Extras

3 - Phone

4 - Gas

5 - Electricity

6 - Water

8 - Internet

Receipt Type

1 - Cash

2 - Cheque

4 - EftPOS

5 - Journal

8 - DirectCredit

You must to post a comment.
Last modified
12:03, 13 Jul 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