Deposit Reconciliation to GL or DBR Report

This program prints a detailed report of deposits within the following categories:

Posted deposits on open reservations including those with a pickup date in the future.
Posted deposits on open RAs
Posted deposits on closed RAs where the opening date of the RA and the deposit date are earlier than the cut off date and the closing date is later than the cut off date
Non-refunded posted deposits on canceled and no-show reservations
Non-refunded posted deposits on Voided RAs

To access the Deposit Reconciliation to GL OR DBR Report, type DEPDBR (RET) at any menu "OPTION:" field of the appropriate line number on the Deposit Reports Sub-Menu of the Month End menu. The screen will then display:

OPTION: __ DEPOSIT RECONCILIATION TO GL OR DBR

1 Start Date 10-05-11
2 End Date 10-05-11
3 Location ALL (Loc, +Group, or ALL)
4 Check res's also Y (Y,N)
5 Detail/Summary D (D,S)
6 Open Deposits Only N (Y,N)
7 Print/Display P Printer /dev/tty
8 Create File N (Y,N)
9 Report Type D (G=G/L,D=DBR)

1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8

Enter data as follows:

1. START DATE	Enter the starting date for this report. The meaning of this date is influenced by the following additional fields: If in Field 9 the format "G" is selected and in Field 6 "N" is entered, this date is ignored and all open deposits from the start of time are reported if the deposit is not part of a closed and posted RA. If in Field 9 the format "G" is selected and In Field 6 "Y" is entered (only open deposits are requested), then deposits with a deposit date earlier than this are ignored. Only deposits taken within this date range and which are not on closed and posted RAs will be reported. If in Field 9 the format "D" is selected then deposits with a deposit date earlier than this are ignored. Only deposits taken within this date range are selected and which are not on closed and posted RAs will be reported. EXAMPLE: Type (RET)
2. END DATE	Enter the starting date for this report. Press RET to default to yesterday. EXAMPLE: Type (RET)
3. LOCATION	Enter: A single Location Code for the location whose deposits are to be reported. A Location Group Code The word "ALL" for all locations EXAMPLE Type (RET)
4. CHECK RES'S ALSO	Enter: N = No. Only deposits taken on RAs. Deposits taken on reservations will not be included. Y = Yes. Both deposits taken on reservations (open reservations, and unrefunded deposits on no-show and cancelled reservations) as well as deposits on RAs (open RAs, unposted closed RAs, and unrefunded deposits on voided RAs) will appear on the report. This is the response that should be used when trying to reconcile to the G/L customer deposits account. Deposits on cancelled and no-show reservations and voided RAs are indicated on the report with "C", "N", or "V" respectively. EXAMPLE: Type Y (RET)
5. DETAIL/ SUMMARY	Enter 1 alpha character to select the report format. D = Detail S = Summary EXAMPLE: Type D (RET)
6. OPEN DEPOSITS ONLY	Enter: Y = Yes, only those deposits that are still open as of the date and time the report is run will be reported. N = No, all deposits whether open or part of a closed RA will be reported. EXAMPLE Type N (RET)
7. PRINT/ DISPLAY	Enter: P = Print a hard copy of this report on your terminal's assigned printer D = Display this report on your terminal screen EXAMPLE: Type P (RET)
8. CREATE FILE	Enter: Y = Yes, an ascii comma delimited file should be created of the reported data. N = No, only produce the report, do not create a file of the reported data. EXAMPLE Type N (RET)
9. REPORT FORMAT	This report is available in two different formats. Enter one of the two codes listed below to select the desired format: G = G/L format - designed to reconcile to the General Ledger account used for Customer Deposit Liability D =DBR format - designed to reconcile to the DBRA report run for the same date range Note: This field affects the meaning of the Start Date field, Field 1 above. EXAMPLE: Type G (RET)

PRESS "F1" AT "OPTION:" TO BEGIN PRINTING.