InteliSys Aviation Systems

• 1 - Core Items
• 2 - Settings
• 3 - Agency Types
• 4 - Agency Account Defaults
• 5 - Payment Methods
• 6 - Agencies
• 7 - Companies
• 8 - Access Note Definition
• 9 - Baggage Rates Setup
• 10 - Quantity Distributions
• 11 - Standard Weights
• 12 - Charge Categories
• 13 - Charge Types
• 14 - Charges
• 15 - Discounts
• 16 - Payment Method Discounts
• 17 - Inventory Setup
• 18 - Fares Setup
• 19 - Cancellation/Modification Charges
• 20 - Infant Allocation Setup
• 21 - APIS Definitions
• 22 - Markup and Commissions
• 23 - Promo Codes
• 24 - Allocation Templates
• 25 - Fare Families
• 26 - Loyalty Program
• 27 - User Profiles
• 28 - Passenger Requests
• 29 - Seat Map and Seat Selection
• 30 - Ancillary Items
• 31 - Prepaid Agency Accounts
• 32 - Multi-Tier Prepaid Accounts
• 33 - Vouchers
• 34 - Passenger Protect
• 35 - eNews - Special Interests
• 36 - Accounting Integration
• 37 - Common Problems and Solutions

Disclaimer

Some features described in this manual are available as separate modules and may incur additional costs in order to be enabled. Please contact your client manager or sales@intelisys.ca in order to request more information, or to make arrangements to enable additional features.

Confidentiality

The contents of this document are governed by the provisions for confidentiality set forth in the commercial agreement and/or any Non-Disclosure Agreement(s) in effect between the recipient and InteliSys.

Distribution, duplication or any other dissemination of this material for uses other than the recipient’s review for the purposes of enhancing their use of, or evaluating the system, is strictly prohibited, and will constitute a material breach of the aforementioned agreement(s).

Introduction

The ameliaRES system is a hosted Reservation and Passenger Management System that allows airlines to manage all aspects of their reservation inventory, fares, sales, revenue and reporting. Deployed from a secure Tier 4 ASP hosting facility, the System allows airlines to utilize a state-of-the-art solution with minimum IT investment. Our architecture and facilities conform to the Payment Industry PCI standards and we utilize high redundancy of all components to ensure a high level of availability. Our scalable system architecture allows for rapid capacity adjustment and accommodation of high demand spikes during seat sales or other sales promotion activities. Our systems are accessed via standard PCs connected to the Internet and no leased lines or other costly connections are required.

...

The amelia architecture allows for rapid implementation throughout your organization. The intuitive User Interface reduces total training time for your staff and the system architecture allows rapid configuration and customization to your organizational model. Web booking portals, dedicated travel agency and corporate interfaces, and GDS sales channels can be quickly configured for deployment to your requirements. Our solution supports a wide variety of payment options, including cash, accounts, multiple credit card gateways, debit cards, payment kiosks, and other interfaces for cash or credit settlement. Our native Departure Control Interface provides a wealth of features for passenger and baggage check-in, additional charge processing, rebooking, and go-show booking. All revenue transactions are continuously maintained with complete audit trail tracking and the capability to communicate to your in-house accounting solutions.

(feature) Accounting Integration

amelia can integrate with certain Accounting packages. The export/import process for Great Plains and Acomba are described herein.

Image RemovedNOTE: Please contact your client manager to enable this feature - some configuration changes are required.

Requirements for Great Plains Integration

The following are required for the proper functioning of accounting integration with Great Plains:

1. amelia Transfer account: An amelia Transfer account must be added to Great Plains. This account will hold any amounts outstanding at the time of export. This is necessary because the amount of charges does not always equal the amount of payments for any 24-hour period. The GL account number for this account must be provided to InteliSys.
   
2. Accounts Receivable GL account number: The GL account number for Accounts Receivable must be provided to InteliSys.
3. Accounts Payable GL account number: The GL account number for Accounts Payable must be provided to InteliSys.
4. Commissions GL account: If used, the GL account number for Commissions must be provided to InteliSys.
5. Public customer number: A customer number for Public bookings/charges/payments must exist in Great Plains. This customer number must be provided to InteliSys.
6. Charge Type GL accounts: Each Charge Type in amelia (Utilities -> Charge Types) must have a Sale Code that corresponds to the GL account number for that Charge Type.
7. Payment Method GL accounts: Each Payment Method in amelia (Utilities -> Payment Methods) must have a Sale Code that corresponds to the GL account number for that Payment Method.
8. Tax GL accounts: If used, the GL account numbers for Taxes must be provided to InteliSys.

amelia will use this information to generate three (3) files to be imported into Great Plains. One file will contain all charges for the last 24-hour period. This file will also contain the total for each Charge Type. Please note that charges are included whether or not they have been paid.

Payments are exported in another file, which will contain all payments for the last 24-hour period. A payment for the total of the day’s charges is also imported into the amelia Transfer account. This will allow for unpaid charges to be placed on the amelia Transfer account until they are paid.

Commissions are exported in another file, which will contain all commission amounts for the last 24-hour period. This file contains relevant details, such as the customer number to which commission was paid, and the associated reservation number.

Requirements for Acomba Integration

The following are required for the proper functioning of accounting integration with Acomba:

1. amelia Transfer account: An amelia Transfer account must be added to Acomba. This account will hold any amounts outstanding at the time of export. This is necessary because the amount of charges does not always equal the amount of payments for any 24-hour period. The GL account number for this account must be provided to InteliSys.
2. Accounts Receivable GL account number: The GL account number for Accounts Receivable must be provided to InteliSys.
3. Accounts Payable GL account number: The GL account number for Accounts Payable must be provided to InteliSys.
4. Commissions GL account: If used, the GL account number for Commissions must be provided to InteliSys.
5. Public customer number: A customer number for Public bookings/charges/payments must exist in Acomba. This customer number must be provided to InteliSys.
6. Charge Type GL accounts: Each Charge Type in amelia (Utilities -> Charge Types) must have a Sale Code that corresponds to the GL account number for that Charge Type.
7. Payment Method GL accounts: Each Payment Method in amelia (Utilities -> Payment Methods) must have a Sale Code that corresponds to the GL account number for that Payment Method.
8. Tax GL accounts: If used, the GL account numbers for Taxes must be provided to InteliSys.
9. Charge Type Product Codes: These product codes are required by Acomba to generate invoices. Each Charge Type in amelia (Utilities -> Charge Types) must have a Usage Code that corresponds to the Product Code for that Charge Type.

Importing the *.adx data file into Acomba

To import an ADX file into Acomba:

1. Log into the Acomba accounting package.
   
2. Click the Input menu.
   Image Removed
3. Select Import Data from the Utilities section.
   Image Removed
4. Select Accounting Data Exchange (ADX) for the Import File Format.
   Image Removed
5. Click the All... button to select all of the checkboxes.
6. Click the Import button and browse to the file downloaded from the FTP site. Click Open to begin the import process.
7. When asked to convert to mixed case, click No to keep the export file’s format.
   Image Removed
8. When asked to delete the import file, click No to retain it for future reference.
9. View the imported transactions in the Transaction Viewer, on the Accounts Receivable tab.
   Image Removed

Troubleshooting Import Errors

Here are some errors you may encounter and the suggested course of action:

1. File error: 20, Procedure: 0, Sub proc: 31 - This usually means that an invoice being imported has an invoice number that matches an existing invoice in Acomba. This can occur if a previous import attempt failed after the invoice in question was successfully imported. In this case, click Ignore until you reach an invoice that was not yet imported, and the process will continue.
   Image Removed
2. This Customer number doesn’t exist - This error occurs if the customer number shown in the error was not found by the Acomba accounting package. The agreed-upon General Public customer number and the company numbers defined in amelia must be present in Acomba for the import process to succeed.
   Image Removed
3. This Account number doesn’t exist - This error occurs if the account number shown in the error was not found by the Acomba accounting package. The agreed-upon amelia Transfer, client accounts, Charge Types, and Payment Methods account numbers defined in amelia must be present in Acomba for the import process to succeed.
   Image Removed
4. Permission Denied OR Access Denied - The logged in Acomba user must have sufficient permissions to perform a transaction import.

Obtaining the Data Export from the InteliSys FTP site

To download the export data:

1. From your Windows desktop, click Start, then Run.
   Image Removed
2. In the Open field, enter the address provided by InteliSys.
   Image Removed
3. When prompted for login credentials, enter the username and password provided by InteliSys and click Log On.
   Image Removed
4. The contents of your export folder will be displayed. The files are named using the YYYYMMDD format. The date in the filename is the day of the transactions in the file.
   Image Removed
5. Right-click on the file you wish to import and select Copy from the context menu.
   Image Removed
6. Browse to the location on your local drive where you want to save the file. Right-click in the folder in question and select Paste from the context menu.
   Image Removed

The files are now ready to be imported by your accounting package.

Common Problems and Solutions

Here are some problems you may encounter and the suggested course of action:

Fare / Flight Visibility Checklist

If you are trying to make a reservation for a specific flight/fare, but they aren’t visible, try the following:

• On the Fares Setup screen, check the On Sale To/From dates and Travel To/From dates. Make sure the booking date is in the On Sale date range, and the travel date is in the Travel date range, where applicable.

• If it’s a multi-city flight, verify the connecting airports are valid connections for the city pair’s fares on the Fares Setup screen.

• Verify the Seat Allocations for the flight - make sure the Class of Service, assigned Agencies, and Booking Codes availability are correct.

• On the Inventory Setup screen, check the Fare Class visibility and Fare Type (One Way / Return).

• On the Inventory Setup screen, check if any companies are assigned to the Fare Class. If so, those companies must be used.

• For multi-city flights, check the stopover times against system defaults on the Settings screen.

...