Deposit Report (REP_DEPOSIT.REP with REP_DEPOSIT.FMX)

This report gives an overview of business block deposits that have been requested and received. Room and Catering deposits are listed separately, if they have been requested that way. Otherwise, the combined deposit type ALL will print.

The report can be ordered by deposit due date or by business block arrival date range.

Note: When printing this Report help topic, we recommend printing with Landscape page orientation.

Note: This report requires that the user be granted the BLOCK PRINT permission in the selected property to run the report. Also, the Property LOV in this report is further limited by the properties to which the user has the appropriate access granted.

Selection Criteria

Property. Only available when OPS_MHT2 license is active. Multi select LOV to choose the property for which the report should be printed.

Arrival Period Start/End. Allows entry of an arrival date range. All business blocks with an arrival date within the selected range will print on the report.

Deposit Due From/To. Allows entry of a date range for which deposits have been requested. All business blocks that have one or more deposit request with a due date within this date range will print on the report.

Note: Either the Arrival Period (Start/End) dates or Deposit Due (From/To) dates must be populated for this report to run.

Business Block. Use this option to filter the report for one or more business blocks.

Bus-Block Status. Use this option to filter the report by specific Block Status.

Catering Status. Use this option to filter the report by specific Catering Status.

Paid, Unpaid, Both. Select one of the following three options:

• Paid – if arrival dates are defined, all paid deposits for business blocks during that period will be printed. If deposit due dates are defined, all paid business block deposits made in that period and any unallocated payments for any period will be printed.
• Unpaid – unpaid deposit requests due during the defined period will be printed.
• Both – both the paid and unpaid deposit information will be printed.

Block Type

Rooms, Catering, Both. Allows the selection of Business Block Room Type only deposits to print (type 'R'), Catering Only Business Block Type deposits (type 'C'), or both Business Block Room Type and Catering Business Block Type (R, C and All) deposits.

Button Functions

Preview. Use the preview option to view the generated output of this report in PDF format.

Print. Use the Print button to print the report to the selected output.

File. Prints the generated report output to an *.rtf file.

Close. Closes this report screen.

Report Data

The report will print a separate section for each business block, in booking id order. The business block details printed include rooms status, catering status, business block name, booking id, arrival date, departure date, company account name, company contact name, agent or source account name and agent or source contact name. The deposit data contains the deposit type, percentage of the total that the deposit represents (if it has been entered that way), deposit requested amount, due date of the deposit, deposit comments, total amount paid and the total amount unpaid for each specific request.

Deposit types can be Room, Catering or All. If a deposit payment has been posted without a deposit request being present or the payment has not been offset against an existing request when posting it, the deposit record will be listed on this report as 'Unallocated' and only the total amount paid will show a figure.

The 'total unpaid' figure is calculated for each request record by deducting the paid amount from the request it has been allocated to.

A report grand total is printed as a summary after all details for the Total Paid and Total Unpaid columns.