O/S Deposits Report
Back Office Menu -> Reports ->
O/S Deposits Report
Reports Menu -> Automatic
Reporting -> Function RSCH41 -> runs O/S
Deposits Report
This report is useful to identify all deposits for contracts,
counter worksheets, reservations, sales orders and work orders
which are still outstanding.
This report should be printed at the end of the month, and be
compared to the G/L Account for Customer Deposits, to ensure that
they agree.
The O/S Deposits Report can be setup to be run
automatically with the results emailed to staff, by setting up
RSCH41 with the relevant filters and email addresses in the
Automatic Reporting.
Note: Any contract deposits which are marked CLOSED = Y
on the report are still outstanding, even though all equipment has
been returned the deposit amount has not been used.
These deposits should either be refunded, or be charged against an
invoice in order to clear them from the system.
To print the report the prompts are:
-
- O/S WORKSHEET DEPOSITS
- Uncheck this box to exclude Outstanding Counter Worksheet
deposits on the report.
Check this box to include Counter Worksheet deposits on the
report.
O/S CONTRACT DEPOSITS
- Uncheck this box to exclude Outstanding Contract deposits.
Check this box to print Outstanding contract deposits on the
report.
- CONTRACT STATUS
- Select one of the following contract status options:
- Open to only include deposits for open Contracts.
- Closed to only include deposits that have not been used
for closed Contracts.
- Both to include Outstanding deposits for open and closed
Contracts.
O/S RESERVATION DEPOSITS
- Uncheck this box to exclude Outstanding Reservation deposits on
the report.
Check this box to include Reservation deposits on the report.
O/S ORDER DEPOSITS
- Uncheck this box to exclude Outstanding Sales Order deposits on
the report.
Check this box to include Order deposits on the report.
- ORDER STATUS
- Select one of the following order status options:
- Open to only include deposits for open Orders.
- Shipped to only include unused deposits for shipped
Orders.
- Both to include Outstanding deposits for open and filled
Orders.
O/S WORK ORDER DEPOSITS
- Uncheck this box to exclude Outstanding Work Order deposits on
the report.
Check this box to include all unapplied Work Order deposits on the
report.
ALL DIVISIONS
- Check this box to include all divisions in the report.
Uncheck this box to select a specific division for the
report.
- DIVISION
- Enter the division, or select a division from the window.
FROM DATE OUT / ORDER DATE
- Accept a starting date of 01-01-1901 to include all outstanding
deposits, or enter the preferred starting date for the report.
Note: If a starting date other than 01-01-1901 is entered,
deposits taken prior to the starting date will NOT be included in
the report, however they will be included in the G/L Customer
Deposit Account total.
TO DATE OUT / ORDER DATE
- Accept today's date or enter the preferred ending date for the
report.
UNPOSTED DEPOSITS ONLY
- Uncheck this box to generate a summary or detailed, report or
spreadsheet including all deposits in the selection range.
Check this box to generate a detailed spreadsheet listing only
documents with any unposted deposit records.
Only deposits records in the selection range that have not been
posted to the G/L will be listed.
REPORT TYPE
- Select one of the following report options:
- Summary to generate a listing of the documents with
outstanding deposits, showing the document date, total deposit
amount, status, and division.
Status F indicates the product on the contract is currently Off
Rent.
- Detail to also include a breakdown of each deposit with
amounts, dates, method of payment, any remaining outstanding
deposit, deposit posted flag and the DBR # for the posting.
REPORT OPTIONS
- This value defaults to the operator preference as defined in
Operators.
Select one of the output options to Print a report or export
the data to Excel as outlined in Report Options.
Finished?
- Click ACCEPT to generate the report, or CANCEL to abort.
Topic Keyword: RSCH41