Navigation: Report menu > Night audit group > Night audit report 

Display correct data in 3 columns “Price include tax”, “Price exclude tax” and “Total” on the Night audit report, not affected when transferred to another room.

“Price include tax” column (1): rename the column to “Total before discount”. Display the value of the room price for 1 night generated on the corresponding audit date, the value includes room price + service fee (with include in room charge enabled) and includes tax fee, excluding discount/ surcharge. Get data in the Total column + data in the Discount column.

“Price exclude tax” column (2): display the value of the room price for 1 night generated on the corresponding audit date, the value includes room price + service fee (with include in room charge enabled) and does not include tax fee, including discount/ surcharge. Get data from the price_sum column in the master_invoice_items table and have Type = “Room Fee”

The ”Total” column (3): displays the value of the room rate for 1 night generated on the corresponding audit date, the value includes room rate + service charge (with include in room charge enabled) and includes tax, after calculating the discount. Get data from the total_amount column in the master_invoice_items table and have Type = “Room Fee”.

<