eSmartNews

Fall 2007

TRAMS BACK OFFICE


New Value Features
(in soon to be released 3.00.00)

Lloyd West, TBO Product Manager

Value Feature # 1:

In this new version of TRAMS Back Office (TBO), a number of changes have been made to the Canadian and other International versions in the way we capture GST and VAT taxes in the program. Our goal was one of consistency among all the GST/VAT versions. The basic functionality on how the taxes are calculated and what is saved has not changed. What has changed is the setup for capturing these taxes and the fields that they are captured in. Nothing has been taken away from what was in earlier versions. Here are some of the highlights, but be sure to read the 3.00.00 version release notes for more details.

  • Added a "GST/VAT" tax code field to Utilities|Setup|Global Defaults|Tax Related Tab for designating the tax codes for GST and VAT. The 'Download.exe' file was also modified to use the "GST/VAT" tax code field to determine which taxes are for GST/VAT.
  • The 'Tax Related' tab in Utilities|Global Default for all BSP versions has been modified to allow for VAT/GST tax to be applied to any of the Tax 1 thru Tax 4 fields, as contained in previous Australian versions.
  • Client GST/VAT is now captured separately from other taxes, in its own field on the "More Taxes" Tab of the Booking screen, in all BSP versions.
  • The descriptions for the GST/VAT fields on the "More Taxes" Tab of the 'Booking' screen have been changed to "Comm GST" or "Comm VAT" to distinguish from Client GST/VAT.
  • When updating your database using the new TFWUP in the 3.00.00 version, Client GST/VAT amounts will be moved from the previously designated tax field to the new Client GST/VAT Amt fields. For UK, & AMEA versions, the tax field was always tax 4; for Canada, Australia and other BSP countries, the tax field is the one designated with a tax code of XG.

Value Feature # 2:

Changed the look and layout for printing of a Client Voucher and Vendor Voucher to include an “amount” for the voucher of the (+/-) payments on the Voucher and the "Balance" of the Voucher.

  • The invoice type now reads Client Voucher or Vendor Voucher.
  • The payment information now has a column header and the booking header is disabled for vouchers.
  • Vendor payments are listed for Vendor Vouchers.
  • Vendor name and address info is displayed for Vendor Vouchers.
  • Columns have been added for Pay Method & Payment Type (received/made) in the payment summary section.

Value Feature # 3:

Added a third option for a new "American Express KR-1022" file format for the AMEX CC Reconciliation under Reports|Payment.

  • This newer .CSV file format can be readily downloaded by the AMEX user from their web site. You don't have to wait for a disk or e-mail file to be sent to you.

Value Feature # 4:

Added a new Payroll Import for Oryel payroll software, under Payments|Payroll Import|Import Oryel Payroll.

  • Information and contacts for Oryel Payroll can be found on the TRAMS Platinum Partners web page by clicking here.
  • Note: The old KIS Payroll option has been replaced with the Oryel option. Both the KIS and Oryel payroll import files will work using the "Import Oryel Payroll" option.

Value Feature # 5:

Added a new 'Pinnacle PPS' selection to both the 'Setup CC Merchant Processors' Screen under Utilities|Setup|CC Processors and on the 'CC Merchant Reconciliation' Screen under Payments|Reconciliations to accommodate a new Pinnacle processing solution for UATP & Non-UATP Credit Cards.

  • The older selections for both "PRI" and "Pinnacle" have been phased out, so if using Pinnacle for your merchant processing, you would need to upgrade to an existing 3.00.00 beta version or the general release. Contact Pinnacle for further details on switching to the new "Pinnacle PPS" option.

Value Feature # 6:

Added 'Travel Type' as a column to be displayed under the "Columns" button on the Agent Reconciliation Screen under Payments|Reconciliation|Agent Reconciliation.

  • This will allow a user to sort by travel type so they can run one query for one agent for all travel types, sort by Travel Type and easily use the "Global Modify" button to adjust commission rates & amounts for a specific travel type.

Value Feature # 7:

You can now create payments for multiple agents when saving the Agent Reconciliation.

  • When "Enter Agent Payment" is checked on the Agent Reconciliation screen under Payments|Reconciliation, and more than one agent is being reconciled, multiple agent payments, one for each agent reconciled as part of an 'Agent Group', can be created.

Value Feature # 8:

Added a "Group" drop-down field to the Create Agent Adjustment Screen. You can now add an Agent Adjustment 'Category' or 'Description' and save for later use.

  • You can now more consistently associate the agent adjustment with the particular expense it is for. It will standardize the allocation of the agent expenses to a consistent category that can then be more easily sorted and reported on than using the adjustment remarks field.
    • The Agent Adjustment "Group" field has been added to the bottom of the Agent Statement so a user can consistently display Agent Adjustments grouped together by standard categories:
      Issue Date, Amount, Category, Remarks.
    • If a "Group" category is entered, then items of the same "Group" will be displayed together and subtotaled for each "Group."

Value Feature # 9:

During Interface Processing single payments are now created for each booking in the PNR Invoice being processed even if the CC No. is the same.

  • This will allow for easier voiding of tickets during processing when each ticket has its own payment attached.

Value Feature # 10:

We now match Non-ARC/BSP airline bookings to any vendor profile with a matching interface ID. So a ticket sold on United Airlines, but not processed through ARC/BSP, can be added to a single United Airlines Vendor Profile if the Interface ID matches.

Value Feature # 11:

Added a new calculated field for 'Number of Room Nights' to Report Generator Build Reports.

  • Before this field was added, if there is a booking for a hotel and it is for 4 nights and for 4 rooms, the Report Generator report showed this as 4 room nights...not 16.
  • This new 'Number of Room Nights' field takes the number of days from the 'Depart Date', 'Return Date' calculation X the 'No of Rooms' field on the Expanded Fare Tab, to correctly calculate the total number of room nights booked.

Value Feature # 12:

Modified the "Payment Method" field on the Report Generator Print Report 'General' Tab to be bracketed [ ] so that multiple forms of payment can be selected instead of just one. Now you are able to view all Credit Card payments and all CC Merchant payments on one report.

Value Feature # 13:

Added "Total Fare", "Commission Amount" & "Agent Name" as fields to select under Utilities|Setup|Checks (Check Writer) in all versions.

  • The check signing person in an agency will be better able to determine if the check going out to a vendor is correct or not with the additions of the Total Fare & Commission Amount fields printed on the check. If there is an issue with the check, having the Agent Name will speed up resolution of any check issues.

Value Feature # 14:

Added an option in Global Defaults|Interface Mailmerge Prompt to "Ignore GST/VAT for Int'l BSP Air." When the box is checked GST/VAT on International Air will be automatically ignored via Interface and not applied to the booking.

Value Feature # 15:

The PNR History records stored in the database under the RECLOC Button on the Invoice Screen are now compressed to save space in the database.

Articles in This Edition

Tips & Tricks

TRAMS Back Office

ClientBase

Support Helpful Hints

© 2007 TRAMS, Inc. | www.trams.com | From the people at Sabre Travel Network