• Navigation: Tab Report > Total Transaction report
• Requirement:
  • Add a field Search By (1)
  • Change name Created Time column into Posted Date (3)

• Field Search By (1) includes 2 options:Transaction DatePosted DateonSelect: Search By = Transaction Date and press Search:The system filters the list of transactions with Transaction Date in the range @From – @ToTransactions with Transaction Date = NULL will not be displayedThe system updates the label @Date type (2) = Transaction DateData in the Transaction Date column is displayed according to the rules in the Business Rules section (*)onSelect: Search By = Posted Date and press Search:The system filters the list of transactions with Posted Date in the range @From – @ToThe system updates the label @Date type (ID2) = Posted Date

• Posted Date (3):

      onSelect: Search By = Transaction Date and press Search:
      The Posted Date column is still displayed but does not affect the filter results
      onSelect: Search By = Posted Date and press Search:
      The system filters the list of transactions with Posted Date in the range @From – @To

* Business Rules section:

            . For Financial Type is ‘Revenue’

Context	Revenue Type	Transaction Date	Posted Date
Room fee/ Service
Create new booking, ORUpdate booking (related to Arrival date/ Departure date, or Room fee/ Breakfast/ Special service)	Room fee + Breakfast/ Special service (Included in Room charge)	Transaction Date = Night audit date(Need to run Night audit for report to appear)	Posted Date = Night audit date
Add service directly to an In-house booking (Combo, Room service, Housekeeping service)	Combo, Room service, Housekeeping service	Transaction Date = Night audit date(Current Night audit date, no need to run Night audit to display report)	Posted Date = Date service was added
Advance room charge	Room fee/ Service	If Night audit has not been run: Transaction Date = NULL (leave blank)If Night audit has been run: Transaction Date = Night audit date	Posted Date = Date Room fee/ Service is Advance room charge
FnB/ KTV
FnB/ KTV:Revenue date = or ≠ payment date, ANDChoose Pay at table to pay on the spot	FnB/ KTV	Transaction Date = Night audit date(Current Night audit date, no need to run Night audit to display report)	Posted Date = Date the final Bill was created (the date the customer paid the bill)
FnB:Revenue date = or ≠ payment date, ANDSelect Post to room to debit the booking Folio and pay later	FnB		Posted Date = Date revenue is recorded Post to room

For Financial Type is ‘Payment’

Context	Transaction Date	Posted Date
Payments are entered into PMS via the Pay function (Booking details > Tab Folio)	If Night audit has not been run:Transaction Date = NULL (leave blank)	Posted Date = Date the payment was entered into the system
Payment for FnB/ KTV is paid on the spot via Pay at table	If Night audit has been run:Transaction Date = Night audit date	Posted Date = Date the final Bill was created (the date the customer paid the bill)

<