Index Of Reports – TravCom CS



Index Of Reports – TravCom CS

Client Reports

|Air Travel Management.rpt |Client’s Count And Gross Totals By Airline For A Date Range. Prompts For Client(s), Date Range, And Branch(es), And Provides A |

|(AIRCUST.RPT & CLNTAIR.RPT) |New Page For Each Client. |

|Airline Average By Client.rpt |Client’s Gross, Count, And Average Ticket Cost By Airline For A Date Range. Prompts For Client(s), Date Range, Domestic Tickets, |

|(AIRAVG.RPT & CLNTAIR.RPT) |International Tickets, Or Both, Branch(es)And A New Page For Each Client Or Not. |

|Arrival And Departure Listing.rpt |Departure/Arrival Info By Passenger Name. Prompts For Transaction Date(s) And Branch(es). |

|(ARRDEP.RPT) | |

|Client Activity By Airline.rpt |Detailed Ticket Information By Carrier For Each Client. Prompts For Client(s), Date Range, And Branch(es), And Provides A New |

|(CLNTAL.RPT) |Page For Each Client. |

|Client Airline Analysis.rpt |One Airline’s Activity Including Passenger, Date, Tkt #, Selling Fare, Gross, Comm, And Routing. Prompts For Airline, Date Range, |

|(Airline Analysis.rpt) |Client(s), Branch(es), And Detailed Or Summarized Report. |

|Client Departmental Budget.rpt |Client’s Activity And Budgets By Department. Does Not Include Sales Without A Department Code. Prompts For Client(s), Date |

|(DEPBUDGT.RPT) |Range, And Branch(es). |

|Client Volume.rpt |Shows Air, Car/Hotel, And Other Activity By Client. Prompts For Client(s), Date Range, And Branch(es). Car/Hotel Amounts Are |

|(VOLUME.RPT) |Based On Bookings Only. |

|Client Volume With YTD.rpt |Shows Air, Car/Hotel, And Other Activity By Client For The Specified Date Range And Year To Date. Prompts For Client(s), Date |

|(SALES3.RPT & VOLUME.RPT) |Range, And Branch(es). Car/Hotel Amounts Are Based On Bookings Only. |

|Cost Savings Analysis.rpt |Client’s Cost Savings Per Ticket. Prompts For Client(s), Date Range, And Branch(es). |

|(SAVINGS2.RPT) | |

|Credit Card.rpt |Client’s Activity By Credit Card Number For A Date Range. Prompts For Client(s), Date Range, And Branch(es). |

|(CREDIT.RPT) | |

|Form Of Payment.rpt |Client’s Activity By Form Of Payment. Prompts For Client(s), Date Range, And Branch(es). |

|(FOP.RPT) | |

|Frequent Flyer Mileage.rpt |Shows Mileage By Client With Detail And A Graph. Prompts For Client(s), Date Range, And Branch(es). |

|(MILEAGE.RPT) | |

|Low Fare.rpt |Client’s Activity With Low Fare And Gross Amount. Prompts For Client(s), Date Range, And Branch(es). |

|(LOWFARE.RPT) | |

|Monthly Product Code.rpt |Shows Client’s Transactions For The Specified Product Code. Prompts For Client(s), Date Range, One Product Code, And Branch(es). |

|(FEE1.RPT) | |

|Monthly Service Fees.rpt |Shows Client’s Service Fees. Prompts For Client(s), Date Range, Service Fee Product Code(s), And Branch(es). Multiple Product |

|(FEE1.RPT) |Codes Can Be Entered If You Use More Than One For Fees. |

|Sales And Vouchers.rpt |Client’s Activity (Including Cars/Hotels) By Invoice. Prompts For Client(s), Date Range, And Branch(es). |

|(SLSNVCH.RPT) | |

|Segment Count.rpt |Client’s Activity With Segment Count (Based On Number Of Legs In The Itinerary). Prompts For Client(s), Branch(es), Date Range, |

|(SEGCOUNT.RPT) |And One Airline Or All Airlines. |

|Specific Credit Card.rpt |Shows Clients Activity On The Specified Credit Card Number. Prompts For Client(s), Date Range, Credit Card, And Branch(es). |

|(Credit Card.rpt) | |

|Voucher Savings.rpt |Shows Savings For The Specified Voucher Product Code. Prompts For Client(s), Date Range, Voucher Product Code, Branch(es), |

| |And Whether To Combine Selected Clients Or Not. |

Sales/Reference Reports

|Agency Service Fees.rpt |Shows Agency’s Service Fees. Prompts For Branch(es), Date Range, And Service Fee Product Code(s). |

|(FEES.RPT) | |

|Agency Volume.rpt |Shows Air, Car/Hotel, And Other Activity By Branch. Prompts For Branch(es) And Date Range. Car/Hotel Amounts Are Based On |

|(VOLUME.RPT) |Bookings Only. |

|Agency Volume With YTD.rpt |Shows Air, Car/Hotel, And Other Activity By Branch For The Specified Date Range And Year To Date. Prompts For Branch(es) And |

|(SALES3.RPT & VOLUME.RPT) |Date Range. Car/Hotel Amounts Are Based On Bookings Only. |

|Airline Analysis.rpt |One Airline’s Activity Including Passenger, Date, Tkt #, Selling Fare, Gross, Comm, And Routing. Prompts For Airline, Date Range, |

|(AIRANAL.RPT & DLCOMCUT.RPT) |Branch(es), And Detailed Or Summarized Report. |

|Airline Legs.rpt |Shows Client’s Activity. Prompts For Client(s), Date Range, Airline Number, And Branch(es). |

|(LEGS.RPT) | |

|Arrivals.rpt |Shows Arrival Information By Arrival Date And City. Prompts For Client(s), One Arrival City, Arrival Date(s), And Branch(es). |

|(ARRIVAL.RPT) | |

|Avg Comm – Corp Clients.rpt |Shows Count, Total Gross, Average Gross, Total Commission Amount, And Average Commission Amounts By Corporate Client. |

|(CORPAVG.RPT) |Prompts For Client(s), Date Range, And Branch(es). |

|Client Sales By Month.rpt |Shows Client’s Sales By Month. Prompts For Client(s), Date Range, And Branch(es). |

|(MONTHLY.RPT) | |

|Departures.rpt |Shows Departure Information By Departure Date And City. Prompts For Client(s), One Departure City, Departure Date(s), |

|(ARRIVAL.RPT) |And Branch(es). |

|Departure Date.rpt |Shows Client’s Departures For One Departure Date. Prompts For Client(s), Departure Date (1), And Branch(es). |

|(DEPDATE.RPT) | |

|Domestic Or International.rpt |Shows Activity By Client With Totals For Domestic And International. Prompts For Client(s), Date Range, And Branch(es). |

|(DORI.RPT) | |

|Domestic vs International.rpt |Shows Domestic vs. International Bookings By Airline, With Totals For Each. Prompts For A Date Range And Branch(es). |

|(DOMINT.RPT) | |

|Internal Airline Average.rpt |Shows Gross, Count, Average Ticket Cost, Commission, And Average Commission By Airline For A Date Range. Prompts For |

|(AIRCUTS2.RPT) |Branch(es), Date Range, Domestic Tickets, International Tickets, Or Both. |

|Invoice Average.rpt |Shows Client’s Totals And Averages. Report Does Not Include Vouchers In Totals. Prompts For Client(s), Date Range, And Branch(es). |

|(INVAVG.RPT) | |

|Lost Commission - 5%.rpt |Shows 5% Commission Cap vs. 8% By Airline. Prompts For Date Range And Branch(es). |

|(LOST5%.RPT) | |

|Passenger Arrivals.rpt |Shows Arrival Info By Date, By Time, Then By Passenger For An Arrival City. Prompts For Arrival City, Arrival Date(s), |

|(PAXARR1.RPT) |And Branch(es). |

|Passenger Departures.rpt |Shows Departure Info By Date, By Time, Then By Passenger For A Departure City. Prompts For Departure City, Departure Date(s), |

|(PAXDEP1.RPT) |And Branch(es). |

|PC Comparison – Monthly.rpt |Shows Sales, % Of Total, And Item Count By Product Code For The Specified Date Range, Same Month Last Year, And Same Month 2 |

| |Years Ago With An Average Sale Amount Over The 3 Months. Prompts For Current Date Range (Monthly), And Branch(es). |

|PC Comparison – Yearly.rpt |Shows Sales, % Of Total, And Item Count By Product Code For The Specified Date Range, Same Period Last Year, And Same Period 2 |

| |Years Ago With An Average Sale Amount Over 3 Years. Prompts For Current Date Range (Yearly), And Branch(es). |

|Plated Airline Sales.rpt |Shows Airline Sales And % For 5 Specified Airlines And All Others For Either Clients Or Agents. Prompts For Date Range, Client/Agent |

| |Based Report, 5 Airlines, And Branch(es). |

|Refund Tickets.rpt |Shows Refunded Items (All But Vouchers) By Client With Recap Showing The Number Of Refunds Per Ticketing Agent. Prompts For |

|(VOID.RPT) |Client(s), Date Range, And Branch(es). |

|Specific City Pair.rpt |Shows Information By Client For The Specified City Pair. Prompts For Client(s), Date Range, Departure City, Arrival City, |

|(CITYPR1.RPT) |And Branch(es). |

|Ticket Type.rpt |Compares Paper vs. E-tickets By Client. Prompts For Client(s), Date Range, And Branch(es). |

|(TKTTYPE.RPT) | |

|Top Client Sales.rpt |Picks The Top 5 Out Of The Specified Clients And Shows Their Activity. Top 5 Is Changeable, But You Must Have Crystal 7 Or Higher. |

|(TOPSALE.RPT) |Prompts For Client(s), Date Range, And Branch(es). |

|Travel Activity.rpt |Shows One Passenger's Travel Activity. Allows User To Enter All Or Just Part Of The Passenger Name. Prompts For Date Range, |

|(PAXTVL1.RPT) |Passenger Name, Whether You Entered The Full Name Or Partial Name, And Branch(es). |

|Vendor Summary.rpt |Shows Vendor’s Activity. Does Not Include Vendor 30. Prompts For Vendor(s), Date Range, And Branch(es). |

|(VENDSUM.RPT) | |

|Void Tickets.rpt |Shows Voided Items (All But Vouchers) By Client With Recap Showing The Number Of Voids Per Ticketing Agent. Prompts For |

|(VOID.RPT) |Client(s), Date Range, And Branch(es). |

|Voided Tickets.rpt |Simple List Showing Only Ticket Numbers For The Specified Client(s), Specified Date Range, And Branch(es). |

Agent Reports

|1099 – 2 Part Form.rpt |Report For Printing 1099 (2 Part) Forms Through TravCom CS For Outside Agents. Agents MUST Have A Tax ID Field With 9 |

|(TEN99.RPT) |Characters Or More. Prompts For Tax Year, Agency Tax ID, And Branch(es). |

|1099 – 3 Part Form.rpt |Report For Printing 1099 (3 Part) Forms Through TravCom CS For Outside Agents. Agents MUST Have A Tax ID Field With 9 |

|(TEN99.RPT) |Characters Or More. Prompts For Tax Year, Agency Tax ID, And Branch(es). |

|Agent Airline Volume.rpt |Shows Sale Information By Airline(s) By Agent(s). Prompts For Agent(s), Airline(s), Branch(es), And A Date Range. |

|(AGTAL.RPT) | |

|Agent Listing.rpt |Shows Inside, Outside, Or All Agents. Prompts For Agent(s), Inside/Outside Or All Agents, And Number Or Name Order. |

|Agent Productivity.rpt |Shows Agent’s Activity Detail And Summarizes Gross Amount In A Pie Chart. Prompts For Agent(s), Date Range, And Branch(es). |

|(AGTPROD.RPT) | |

|Agent Sales By Client.rpt |Summarizes Booking Agent’s Activity By Client With A New Page For Each Agent. Prompts For Agent(s), Date Range, And Branch(es). |

|(YTDAGT.RPT) | |

|Agent Sales By Vendor.rpt |Summarizes Booking Agent’s Activity By Vendor With A New Page For Each Agent. Prompts For Agent(s), Date Range, And |

|(YTDAGT.RPT) |Branch(es). |

|Booking Agent Payables.rpt |Shows Open Payables By Booking Agent. Will Only Show AP Invoices Created Through Sales Posting. Any Other AP Invoices Will Not |

| |Show On This Report Because They Are Not Associated With An Agent. Prompts For Agent(s), Ageing Periods, And Branch(es). |

|Commission.rpt |Shows Tickets With Commission Equal To Or Less Than The Specified Amount By Client. Prompts For Client(s), Branch(es), |

|(COMMISH.RPT) |Date Range, And Commission Amount. |

|Debit Memos.rpt |Shows Debit Memos By Client Then By Booking Agent. Prompts For Agent(s), Client(s), Branch(es), And A Date Range. |

|Outside Agent Commission.rpt |Shows Outside Agent’s Activity With A New Page For Each Agent. Prompts For O/S Agent(s), Date Range, And Branch(es). |

|(OSCOMM.RPT) | |

General Ledger Reports

|Budget Variance.rpt |Shows Balance, Budget, And Difference Per GL Account Per Branch. Report Starts With Current Accounting Month And Goes Back |

|(BUDGET1.RPT) |11 Months Prior. Also Shows Year To Date Info Per Account. Prompts For Branch(es). |

|Budget.rpt |Coming Soon |

|(BUDGET2.RPT) | |

|GL Posting Transactions.rpt |Shows G/L Transactions By Account And Posting Source Within The Specified Dollar Amount Range And Date Range By Branch. |

|(GLTRANS1.RPT) |Prompts For Branch(es), Date Range, System Or Transaction Date, And Amount Range. |

Other Reports* (Must Be Downloaded Separately)

|Template.rpt * |Basic Template For Creating Your Own Reports. Has All Parameters Available From The Custom Reports Window Included, But Only |

| |Currently Prompts For Transaction Date Range, A Client Number, And Branch(es). |

|***NOTES*** |To Be Able To Utilize These Two Report Files, You Must Have Crystal 7 Professional Or Higher. |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download