Lockbox Execution Report (Oracle Receivables Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Lockbox Execution Report

Receivables automatically generates the Lockbox Execution report each time you run AutoLockbox. This report is divided into two sections:

Import: This section displays the total number of records that were imported into the interface tables successfully.

Validation: This section provides the details for each record and the total amount and number of receipts in each lockbox transmission.

Import Section

Receivables generates the Import section when you submit the import step of AutoLockbox. If you use SQL*Loader as your import program, it always creates a .log file which can be found in the $AR_TOP/out directory. The .log file contains general information about the activity of your SQL* Loader run, including the reason that the record was not imported.

SQL*Loader also creates a .dis and .bad file in the same directory, if it has records to write to these files. The .bad file contains information about any records that were rejected due to formatting or Oracle errors, such as an invalid date. The .dis file contains discarded records that did not satisfy any of the WHEN clauses in your control file.

Receivables prints a line at the end of the Import section informing you of any rejected or discarded files.

Validation Section

Receivables generates the Validation section when you submit the validation step of AutoLockbox. Use this section of the Lockbox Processing Report to see the number of records that pass or fail rtvalidation. You can also see the total amount and number of receipts in each lockbox transmission.

For records that pass validation, Receivables automatically creates QuickCash receipt batches. You can review QuickCash receipt batches in the Receipt Batches window. If you checked the Submit Post QuickCash check box in the Submit Lockbox Processing window, Receivables posts these QuickCash receipt batches to your receivables accounts.

Use the Maintain Lockbox Transmission Data window to review and edit records that failed validation. See: Maintaining Lockbox Transmission Data.

Column Detail

Record Count Summary

Receivables displays the number of records for this transmission and their corresponding statuses.

Transmission

Receivables displays the Deposit date, Bank origination number, Deposit time, and the destination account as well as the following transmission information:

Transmission Record Count

Records Transferred to Date

Records Transferred this Run

Transmission Amount

Amount Transferred To Date

Amount Transferred This Run

Lockbox Records

Receivables displays the lockbox record information for each record processed. The lockbox information includes the number of receipts in the lockbox that met the criteria for each category.

Batch Records

Receivables displays receipt batch information for each batch in this bank file if you include batches as part of your transmission format. Lockboxes may contain several receipt batches. Receipt batch information includes the receipt batch name, the total number of receipts in this receipt batch, the total receipt amount, currency, and the Deposit and GL date for this receipt batch.

Record Details

Receivables displays the details of each record and the status of that record. If you chose to run the validation report for Rejects Only, Receivables will display the records in error only along with one of the error statuses listed below. If you run the validation report for 'All' records, then records with success statuses will also be displayed.

Lockbox automatically transfers all of the receipt records that have a Success status to the QuickCash tables. If you set the Allow Partial Applications check box to Yes in the Submit Lockbox Processing window, Lockbox will also transfer records that do not have a Success status, but will not be able to apply them. You can apply these receipts manually in the Applications window. If you set the Allow Partial Applications check box to No, records in a batch must have a Success status before they can be transferred into the QuickCash tables.

Error Detail

Receivables lists all errors and their definitions by error number to help you identify the reason a record failed validation.