powered by

New Reports

Tour Party Receivables Reports (by Booking Date and Depart Date)

Navigate from Reservations, Partys, Select a Filter and Select a Report.

Tour Party Receivables by Booking Date.  Sorted by Reservation book date.

Tour Party Receivables by Depart Date.  Sorted by Tour Depart Date.

Partys with outstanding balances appear on this report. 

Tour Amount = Tour net price to customer, includes price adjustments and options.

Applied Receipts = Portion of original receipt applied to tour.  Includes Receipts, Refunds, Reduced $ Paid, Charges, Adjustments and Transfers.

Balance Amount = Amount customer owes for tour.

On Account Amount = Amount of cash customer has on account.

Modified Reports

Tour Profit Report and Bag Base

Bag Base is included in these sections of the Tour Profit Report:

Cost/Pax; Sug/Pax, Estimated Cost, Tour Variable Cost, Cost/Stay and Cost/Pax.

Bag Base will calculate even if no hotel costs are entered in the component screen.

Tour Profit Report and Number of Nights per Hotel

Tour Profit Report now calculates the number of nights at each hotel correctly.
Multiple hotels applied on the same day shows hotel number (1, 2, etc.).

 

 

 

Tour Profit Report and Two Hotels on One Night

If two hotels are entered for a specific night, the tour profit report includes the costs for both hotels for all the passengers.  Work around:  Tour Builder must use entered balances (based on # of pax and room type) for each hotel at the component screen.

Tour Profit Report and Options

"Basis" number in the option section of the tour profit report is equal to the number of pax who have selected the option.

Added Cost and Cost/Pax columns.  Cost is total cost of option to the tour.  Cost/Pax is the cost of the option per pax for tour.

Cost information comes from the "adult base" field in the component screen.  Options Sales information comes from the adult price field in the component screen.

Tour Summary Report

Column headings clarified:

"Pax #" changed to "Room # " which comes from the customer screen.

"Tour" Column + "Options" column = "Total" column.

"Receipts" Column changed to "Applied Receipts" which is the amount of the receipt that has been applied to this particular tour.

"Tour" = tour price to customer.

"Options" = tour option price to customer.

"Total" = total price to customer.

Tour Audit Report

"Tour Audit Trail Report" name added to report.

Receipt Column is now populated with receipt amount, transactions and applied to tour amounts, type & notes.

 

 

Rewards Paid for a Date Range (& by Vendor name) Report

Navigate from Finance to Rewards to Select a Filter:  Rewards due by Vendor name:  Vendors no longer appear on this list if the reward from the vendor has been overpaid.

Training Issues: To change a reward amount after it has been authorized, navigate from Finance to Rewards to Select a Filter.  Find Reward, Change amount & update. Reward amount will change in Main Tour Screen ‘show amounts due’ & Finance, Reward.

If Reward is changed using "Received" button (not recommended), Main Tour Screen now shows reward amount and modified paid amount under 'show amounts due'.

Overpayments:
Navigate from Finance to Rewards to Select a Filter:
"All Active", "Rewards paid for date range", "Rewards paid for date range by vendor" both original and modified amounts appear as expected. FYI: Rewards entered prior to this version will show up with original amounts, not modified amounts.

Navigate from Finance to Rewards to Select a Report:  amounts paid appear as expected.

Navigate from Finance to Paid Rewards to Select a Filter & Select a Report:  paid amounts appear as expected.

Underpayments:
Filters & Reports appear as expected for Rewards & Paid Rewards.

Daily Receipts & Receipts By Receipt Type Reports

Daily Receipts Report: Report Name Appears on Report, headings have been clarified:  Now includes "Amount" (of original receipt) and "Applied" (amount of receipt applied to tour) columns, "Daily Receipts": includes adjustments, refunds, charges, credit cards, transfers and reduced $ paid.  Includes detail on transfers.

Receipts by Receipts Types Report:  Report Name Appears on Report, Headings have been clarified:  Now includes "Amount" (of original receipt) and "Applied" (amount of receipt applied to tour) columns; "Receipts by Receipts Types" includes adjustments, refunds, charges, credit cards, transfers and reduced $ paid. Includes detail on refunds.

Daily Receipt Report

Headings on report clarified:  
"Amount" = the original receipt amount.
"Applied" = the amount of receipt applied to the tour.

Report Name changed to "Daily Receipts Report" on report.

 

Receipts by Receipt Type Report

Headings Clarified and Column added:
"Amount" = the original receipt amount.
"Applied" = amount of the original receipt applied to a specific tour.

Name now appears on report as "Receipts by Receipt Type Report".

In filter parameter:  "To Date" now defaults to 2007 instead of 2008.

Customer Amounts Paid Report

Calculation for "Amount" Column is:

The original receipt amount + the adjustment amount - the refunded amount - the transferred amount.

Customer Summary & Transferred Money

Customer Summary:
Transferred In $ and Transferred $ Out are now clarified with detailed information in the Customer Summary report in the payment history section.

Party Summary & Transferred Money

Party Summary:
Transferred In $ and Transferred $ Out are now clarified with detailed information in the Party Summary report in the payment history section.

Refund Check Request

Refund check request no longer says "This report contains no data".

Filter Issues

Cash on Account Filters

Navigate from Finance to Receipts to Select a Filter. 

"Cash on Account List" filter removed from Finance, Receipts, Select a Filter since it duplicated "Cash on Account".

"Cash on Account" is ordered by date/time cash on account originated.

"Cash on Account by Customer" is ordered alphabetically by customer last name.

Return Date Profit & Revenue Reports Filter Parameter Screen

Navigate from Reservations to Tours to Select a Report.

Set Filter Parameters have been changed for:

Tour Return Date Revenue Report
Tour Return Date Revenue By Type
Tour Return Date Revenue By Office Stage Return Date

"From Date" now reads "From Return Date"
“To Date" now reads "To Return Date"

Change Open/Closed/Canceled to:
Open=O, Closed=C, Canceled=X

Change 'Receipts/Balances" and "Display Bal Due or Amount Paid" to
Receipts=R, Balances=B

Depart Date Profit & Revenue Reports Filter Parameter Screen

Navigate from Reservations to Tours to Select a Report.

Set Filter Parameters have been changed for:

Tour Depart Date Revenue Report
Tour Depart Date Revenue By Type
Tour Depart Date Revenue By Office Stage Return Date

"From Date" now reads "From Depart Date"
"To Date" now reads "To Depart Date"

Change Open/Closed/Canceled to:
Open=O, Closed=C, Canceled=X

Change “Receipts/Balances” and “Display Bal Due or Amount Paid” to:
Receipts=R, Balances=B

 

 

Tour Party Receivables by Depart Date Report Filter

Navigate from Finance to Rewards to Select a Filter.

Tour Party Receivable Report by Depart Date "Set filter parameter" Screen now reads:

"Cut Off Depart Date"

Rewards Paid by Date Range by Vendor Name Filter

Navigate from Finance to Rewards to Select a Filter.

Rewards paid by Date Range by vendor name filter now returns only selected vendor rewards when vendor is entered.

Payables by Vendor Name (Batch Pay) Report Filter

Navigate from Finance to Payables to Select a Report.

Payables by Vendor Name (Batch pay) report is now visible.

Payables Paid for a date range Filter and Report Filter

Navigate from Finance to Payables to Select a Filter and Select a Report.

Payables Paid for a Date Range now produces a list or report for only specified vendor when vendor name is entered.

Tour Return Date Revenue By Type Report Filter

Navigate from Reservations to Tours to Select a Report.

Tour Return Date Revenue and Tour Return Date Revenue By Type, Print Report:

The parameters "Display Bal Due or Amount Paid" have been changed to:
"Receipts=R, Balances=B"

 

 

 

 

Boarding List & Pickups Boarding List Birthdates and Phone Number

Navigate from Reservations to Tours to Select a Filter (choose a tour). At Main Tour Screen Select a Boarding List or Pickups Boarding List Report.

"Y" and "y" is now an acceptable response for "Show birth date" and "Show phone numbers" when printing boarding list.

Receipts by Receipt Type Report Filter

Navigate from Finance to Receipts to Select a Report.

"Receipts by Receipt Type" Report Filter: Changed "To" parameter default date from 2008 to 2007.

Tours Created For Date Range By User Office Depart Date Filter

Navigate from Reservations to Tours to Select a Report.

Changed Set Filter Parameter Screen

Changed "From Depart Date" to" Created From Date"

Changed "To Depart Date" to" Created To Date"

Tours Created For Date Range By Office User Depart Date Filter

Navigate from Reservations to Tours to Select a Report.

Changed Set Filter Parameter Screen

Changed "From Depart Date" to" Created From Date"

Changed "To Depart Date" to" Created To Date"

 

 

 

Null Pointer Exceptions

Reservations, Partys, Null Pointer Exception

Navigate from Reservations to Partys to enter party entityid on customer screen, fails when Back button clicked.  Null Pointer Exception fixed.

Finance, Receipts Null Pointer Exception

Navigate from Finance to Receipts to Select a filter:  Select All Active Members & Receipts for Date Range, fails when Back button clicked.  Null Pointer Exception fixed.