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, work orders and Portal 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.

O/S PORTAL DEPOSITS

Uncheck this box to exclude Outstanding Portal deposits on the report.
Check this box to include all Portal deposits where the request has not yet been converted to a worksheet.

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.