| Client
Reports |
| Report: |
Description: |
| activ1.rpt |
Client Activity
Report. Shows specified clients activity for specified date range. |
| aircust.rpt |
Air Travel Management
Report. Shows client sales for each airline. For product codes 0 and
1. |
| arrdep.rpt |
Arrival and Departure
listing for airline pickup. For product codes 0 and 1. |
| clntair.rpt |
Summarizes gross
amount and ticket count by airline and client. |
| clntal.rpt |
Client Activity
by Airline. Shows all client activity by airline. For product codes
0 and 1. |
| corpdpt.rpt |
Shows passenger,
invoice, and itinerary information. Summarizes by client and department.
|
| credit.rpt |
Detail report showing
credit card number, invoice number, invoice date, ticket number, passenger,
routing, and gross amount. |
| depbudgt.rpt |
Client Departmental
Budget Report. Shows sales, budget, and the difference for each department
of a client. |
| fee1.rpt |
Monthly Service
Fee Report. Shows passenger name, invoice number, date and FOP. For
product code 7. |
| fop.rpt |
Shows invoice number,
invoice date, ticket, passenger, form of payment, credit card number,
itinerary, and gross amount. |
| lowfare.rpt |
Detail sales report
showing passenger, invoice date, invoice number, ticket number, city
pairs, gross amount, low fare, and exception codes. |
| mileage.rpt |
Shows invoice,
ticket, passenger, airline code, departure city, arrival city, and mileage
for each client. |
| passdpt.rpt |
Shows passenger,
invoice, and itinerary. Summarizes by client, passenger, and department.
|
| savings1.rpt |
Shows gross, reference,
low fare and savings for specified client and dates. |
| savings2.rpt |
Shows gross, reference,
low fare, savings, savings offered, and Purchase Order number. |
| segcount.rpt |
Detail report showing
invoice number, invoice date, ticket number, passenger, city pairs,
and segment count for each client. |
| slsnvch.rpt |
Shows complete
invoice detail including vouchers for specified client and date range.
|
| Sales
and Reference Reports |
| Report: |
Description: |
| airall.rpt |
Shows total air
volume for all airlines and all clients for the specified date range. |
| airanal.rpt |
Allows you to choose
an airline and date range. Can show detail or summary with analysis
at the end. |
| airavg.rpt |
Summarizes gross
amount, transaction count, and averages for each airline. |
| aircuts.rpt |
Airline Summary
Showing Totals, Transaction Count, Average Price Per Ticket, Comm, And
Average Comm For Each Airline. Option To Group By Client Selection. |
| aircuts2.rpt |
Airline Summary
Showing Totals, Transaction Count, Average Price Per Ticket, Comm, And
Average Comm For Each Airline With An Option To Group By Client Selection.
This Version Prompts For Domestic, International, Or Both. |
| arrival.rpt |
Select records
based on arrival city and arrival date. |
| carsumm.rpt |
Summarizes number
of days, rate, and voucher total for each vendor and client. |
| citypr1.rpt |
Selects records
based on a departure city and arrival city. |
| citysum1.rpt |
City Pair Summary
Report. Based on Leg Price, shows city name and totals leg price and
count. For product codes 0 and 1. |
| client.rpt |
Client Name Report.
Lists all clients name and numbers in 2 columns. |
| corpavg.rpt |
Shows average gross
and commissions for corporate clients. |
| cos.rpt |
Shows Sales/Cost
Of Sales amounts for each open invoice. |
| depdate.rpt |
Sales report based
on selected departure date. Shows passenger, departure and arrival cities,
departure date, ticket number, and gross amount. |
| dlcomcut.rpt |
Shows Passenger,
Date, Tkt #, Selling Fare, Gross, Comm, And Routing. User Is Prompted
To Show Details Listed Above With Analysis Or Analysis Alone. Built
For Delta Commission Cuts, But Runs For Any One Airline At A Time. |
| domint.rpt |
Summarizes sales
by domestic and international segments for each airline. |
| dori.rpt |
Shows invoice,
passenger, ticket, gross amount, commission amount, and domestic/international
indicator. |
| fees.rpt |
Detailed report
showing fees. Defaults to having product code 8 set up for service fees,
although this can be changed. |
| hotels.rpt |
Detail hotel sales
report showing voucher number, vendor number, invoice date, voucher
total, and number of days. |
| invavg.rpt |
Summarizes for
each client the invoice count, gross amount, average gross amount, commission
amount, and average commission amount. |
| legs.rpt |
Detail report showing
invoice number, invoice date, ticket number, passenger, and city pairs,
leg fare and mileage. Summarizes leg price, mileage and segment count
by client. |
| lost1.rpt |
Shows lost commission
due to International commission caps. |
| lost5%.rpt |
Summary report
breakdown by airline showing 8% cap commission, 5% cap commission, and
the loss of commission based on 8%. |
| monthly.rpt |
Summarizes sales
for each month by client. |
| newlost1.rpt |
Shows Lost Commission
For Domestic Flights Only For A Date Range. |
| newlost2.rpt |
Shows Lost Commission
For Domestic Flights Only For A Date Range. Revised Version Shows Ticket
Count And Averages Per Airline. |
| sales.rpt |
Summarized sales
report that shows airline activity, hotel activity, and car activity.
Totals for the date range selected and YTD. |
| sales2.rpt |
Sales report that
shows passenger, invoice number, ticket number, invoice date, gross
amount, and service fee (based on the service fee product code). Shows
MTD and YTD totals. |
| sales3.rpt |
Same as SALES.RPT,
but does not summarize for each client. Can be selected to summarize
by one client, a range of clients, or all clients. |
| tkttype.rpt |
Client Ticket Type
Report. Shows number of paper vs. E-tickets by client and date. |
| topsale.rpt |
Shows the top 5
clients with details. The top 5 parameter can be changed. |
| vchsales.rpt |
Shows invoice,
passenger, vendor, arrival date, voucher total, commission amount, and
commission paid. |
| vendsum.rpt
|
vendor summary
report. shows agent, dk #, date, passenger, gross, comm., and depart
date grouped by vendor number. |
| void.rpt |
Shows all voided
tickets and their amounts for specified clients and dates. |
| volume.rpt |
Good example of
using subreports. Summarizes gross amount for each airline, voucher
totals for each hotel/car vendor, and gross amount for each non-ARC
vendor. |
| Other
Reports |
| Report: |
Description: |
| label.rpt |
Custom labels (Avery
5160 - 3 across, 10 down) to select clients with a sale that has a commission
over $50.00. |
| paxarr1.rpt |
Passenger Arrival
Report. Shows what passengers are coming in on which airlines and what
time. For product codes 0 and 1. |
| paxdep1.rpt |
Passenger Departure
Report. Shows what passengers are leaving on which airlines and at what
times. For product codes 0 and 1. |
| paxtvl1.rpt |
Passenger Travel
Summary. Lists date, itinerary, amount, and FOP for the specified passenger.
RUNS FOR EXACT SPELLING ONLY. |
| paxtvl2.rpt |
Passenger Travel
Summary. Lists date, itinerary, amount, and FOP. This version looks
for passenger names STARTING WITH what you enter. |
| ren.rpt |
Refund / Exchange
Notice form. Allows you to print REN’s for all sales that were
refunded in the specified period. Some information about the new ticket
will have to be manually entered. |
| tasf.rpt |
Travel Agent Service
Fee form. Allows you to print out the TASF form if you process service
fees through ARC. |
| ten99.rpt |
1099 forms –
only to be used for vendors marked as outside sales agents with a Tax
ID 1 field of 9 characters or more. Allows you to input the year and
your agency’s Federal Tax ID number. |
| ten99v2.rpt |
1099 forms for
any vendor with a Tax ID 1 field of 9 characters or more. Also allows
you to input the year and your agency’s Federal Tax ID number. |
