DAILY REPORTS IN AMADEUS: Sales report
It is very important to have instant access to the sales we make daily in our agency. To do this, it is very useful to use this type of report and to know the information that we can obtain through the GDS. Below we will see a series of Amadeus transactions and briefly explain the information that we can obtain:
TJQ: Displays the list of sales on the current date of the user who requests it
TJQ/D-15OCT Shows list of sales on a specific date
AGY NO - 7800000 QUERY REPORT 15OCT CURRENCY EUR
OFFICE - MADI00000 SELECTION:
AGENT - 000018AS 05 DEC 2020
-------------------------------------------------- -----------------------------
SEQ NO A/L DOC NUMBER TOT DOC TAX FEE COM FP PAX NAME AS RLOC TRNC
-------------------------------------------------- -----------------------------
198349 075 3131313131 -178.53 -43.53 0.00 0.00 CA GONZALEZ AB QFXX7B RFND
198350 075 3030303030 -178.53 -43.53 0.00 0.00 CA MARTINEZ AB QFXX7B RFND
198351*996 0123456789 129.21 27.21 0.00 0.00 CA SANCHEZ AB OCXXP8 TKTT
198354*996 0987654321 134.21 27.21 0.00 0.00 CA PEREZ AB WIXX9V TKTT
TJQ/SOF: Displays the list of sales on the current date of all SIGN INs for a specific office.
TJQ/D-01JUL31JUL Displays sales list in a date range
TJQ/QVP-AF Displays list of sales on the current date with a certain airline
TJQ/QVP-AF/D-15NOV Shows a list of sales on a specific date with a specific airline
TJQ/V Shows list of sales on the current date only of VOID tickets
These transactions (TJD) also show total amounts and balances. They can also be very useful
TJD: Displays the total issued and refunded documents, total amounts and agency balance with the BSP on the current date.
TJD/D-01NO31JUL Displays the total number of documents issued and refunded, total amounts and agency balance with the BSP in a date range.
AGY NO - 7800000 DAILY REPORT 01NOV-30NOV CURRENCY EUR
OFFICE - MADI00000
AGENT - 0000AS 05 DEC 2020
-------------------------------------------------- -------------
PAYMENTS X DOCUM SALES REFUNDS BALANCE
-------------------------------------------------- -------------
FARE AMOUNT CA 2306.00 45293.00- 42987.00-
TAX AMOUNT CA 2975.00 1117.02- 1857.98
FEE AMOUNT CA 0.00 0.00 0.00
DOC AMOUNT CA 5281.00 46410.02- 41129.02-
COMM AMOUNT CA 0.00 0.00 0.00
REMIT AMOUNT CA 5281.00 46410.02- 41129.02-
-------------------------------------------------- -------------
FARE AMOUNT CC 0.00 0.00 0.00
TAX AMOUNT CC 0.00 0.00 0.00
FEE AMOUNT CC 0.00 0.00 0.00
DOC AMOUNT CC 0.00 0.00 0.00
COMM AMOUNT CC 0.00 0.00 0.00
REMIT AMOUNT CC 0.00 0.00 0.00
-------------------------------------------------- -------------
FARE AMOUNT TOT 2306.00 45293.00- 42987.00-
TAX AMOUNT TOT 2975.00 1117.02- 1857.98
FEE AMOUNT TOT 0.00 0.00 0.00
DOC AMOUNT TOT 5281.00 46410.02- 41129.02-
COMM AMOUNT TOT 0.00 0.00 0.00
REMIT AMOUNT TOT 5281.00 46410.02- 41129.02-
-------------------------------------------------- -------------
-------------------------------------------------- -------------
FORM OF PAYMENTS SALES REFUNDS BALANCE
CA/CASH 5281.00 46410.02- 41129.02-
-------------------------------------------------- -------------
-------------------------------------------------- -------------
DOCUMENT VOLUME ISSUED CANCELLED SOLD AMT DOC SOLD
EMDS 2 0 2 96.00
RFND 22 0 22 46410.02
ELECTRONIC 16 1 15 5185.00
-------------------------------------------------- -------------
I'm sure you'll find it helpful and will use these transactions quite a bit.
No comments:
Post a Comment