Financial Transactions with Generates (finjrnlbytrans2 with CAS2.FMX)
Note: When printing this Report help topic, we recommend printing with Landscape page orientation.
The report output lists each transaction code and the corresponding amounts for the dates specified in the filter. Also included is a breakdown of the taxes and package credits attached to each transaction code posted as well as the user that posted each transaction.
The balance of the finjrnlbytrans2 report will be equal to that of the finjrnlbytrans and findeptcodes reports for the corresponding date. Ensure when comparing that you are balancing the figures for “Gross” amount, as this is the only way to balance all three reports.
From Date/To Date. Enter a date range that is equal to, or less than the Business Date and does not exceed the maximum of 35 days.
Room Class. Multi select LOV for filtering on specific room classes. Available when the General>Room Class application function is active.
Transaction Code. Multi-select LOV for filtering on specific transaction codes. Only include the selected transaction codes and their amounts. The list of values will not include the transaction code that has been set for the Cashiering>Deposit Ledger Trn Code application setting and other "internal" transaction codes. When the OPV<version_number> OPERA VOS license is active, internal codes 7070i (Owner Revenue Posting), 7080i (Travel Agent Commission), 9902i (Stored Value Redemption), 9908i (Reserve Credit), and 9909i (Owner Payment) will be displayed.
Note: The Cashiering>View Cash Transactions on Reports permission must be granted in order to select transaction codes configured for cash payment types.
Room. Multi-select LOV for filtering on specific Room Numbers. Only include those transaction codes that are attached to the room number.
Cashier. Multi-select LOV for filtering on specific Cashiers. Only include those transaction codes that were completed by the selected cashiers.
Room Type. Multi-select LOV for filtering on specific Room Types. Only include those transaction codes that are attached to the room types selected.
Tran. Code Group. Multi-select LOV for filtering on specific Transaction Code Groups. Only include those transaction codes that are part of the specific Code Group.
Note: The Cashiering>View Cash Transactions on Reports permission must be granted in order to include transaction codes configured for cash payment types.
Tran. Code Subgroup. Multi-select LOV for filtering on specific Transaction Code Subgroups. Only include those transaction codes that are part of the specific Code Subgroup.
Negative Postings Only. Select to only display negative postings on the report.
Include Currency Exchange. Select to drive the inclusion of the foreign currency on the cash transaction code as defined in the Cashiering>Cash Trn Code application setting.
The following is an example to explain the functionality or this check box.
Let's say that the Cashiering>Cash Trn Code application setting is 9000 (Cash) and the Cashiering>Currency Exchange Paidout Trn Code is 7040 (Currency Exchange Paidout)
1. A currency exchange has been preformed. When this report is run, the amount associated to Trn Code 7040 always will show. If this check box is not selected, then the counter posting for the Cash Trn Code 9000 is not shown. But if the check box is selected, then the counter posting for the Cash Trn Code 9000 will be displayed.
2. A payment on Trn Code 9000 has been made in a foreign currency. When running this report and not selecting this check box will result in the counter posting on Trn Code 9000 to not be displayed. Select the check box to display the counter posting on Trn Code 9000.
3. An additional cash transaction code (9001) has been configured. When a payment has been posted to this additional transaction code (9001), no matter if the check box is selected or not, this transaction will always display because the transaction code is not defined in the Cashiering>Cash Trn Code application setting.
Rental Rooms Only. Available when the OPV_<version number> Opera Vacation Ownership license code is active, select the check box to only display Rental Rooms in the report output. When this check box is not selected, then both Owner Rooms and Rental Rooms will display in the report output.
Supp./Ref./CC Num. Select to display any information that is entered in the Supplement or Reference fields and the Credit Card Number on the report.
Revenue Net or Gross. Select if the revenue posted should display as Net (not including taxes) or Gross (inclusive of taxes).
Net always shows the total excluding the tax, regardless of whether the tax is inclusive or exclusive. Gross always shows the total with inclusive or exclusive taxes added in.
For example, say you posted 110.00 against transaction code 7000 which has an inclusive tax of 10%, and you posted 110.00 against transaction code 7070 which has an exclusive tax of 10%. When running the report on Gross, the total for transaction code 7000 will be 110.00 and the total for transaction code 7070 will be 121.00. When running the report on Net, the total for transaction code 7000 will be 100.00 and the total for transaction code 7070 will be 110.00.
Group By. Cashier, Transaction, Check No., Room, Room Type, Trx. Group, Trx. Subgroup, Market Code.
Sort Order. Cashier, Check No., Chronological, Room, Room Class, Transaction Code.
Preview. Select to preview the report in a PDF format.
Print. Select to print the report.
File. Select to save the report as a file.
Close. Select to exit the specific report
Passer appears for Passerby transactions in the Room No. column. (Available when the Cashiering>Passerby application function is set to Y.) The room number appears in the Room No. column for transactions (including currency exchange) if the transaction is associated with an in-house guest.
Post It appears in the Name and Room No columns for Post It transactions. (Available when the Cashiering>Post It application parameter is set to Y.)
AR appears in the Room No. column for accounts receivable transactions. (Available when the Cashiering>Accounts Receivables application function is set to Y.)
Date. Date the transaction took place in the short date format defined for this property.
Time. Time when the transaction occurred.
Room No. Room number that the transaction was debited/credited for.
Name. Name of the guest responsible for the transaction posting.
Trn. Code. Transaction code used for the posting.
Description. Description of the transaction code.
Check No. This field is auto-filled with a check number by the End of Day process if the End of Day>Auto Check Number application parameter is set to Y. It also shows the check number for transactions entered by a POS.
Currency. The currency code for the currency that was used for the transaction.
Debit. Amount of debit to the guest's account.
Credit. Amount of credit to the guest's account.
Tax Generates. Taxes that have been added to a guest's bill for this particular transaction code that was selected for the posting. The 1, 2. and 3 columns display the subtotal bucket that holds the transaction amount on which the generates are based (called the base transaction) based on the configuration of the property.
Cash ID. Cashier ID number of the cashier who posted this transaction.
User Name. User name of the person who was logged in that completed the posting.
Supplement/Reference/Credit Card No. Column displays any information that has been entered into the Supplement and Reference fields and if a credit card was used for the transaction, then the credit card number is displayed here also.
Exp. Date. Expiration date of the credit card used for the transaction.
Receipt No. Receipt number assigned to the transaction.