Process Receipts Through Lockbox Execution Report
Use the Process Receipts Through Lockbox Execution Report to review the results of a lockbox transmission.
Use this report in conjunction with your lockbox receipt processing.
Selected Process Parameters
Business Unit
The business unit for this lockbox submission. All receipts in the lockbox must belong to this business unit.
Import Process ID
The identifier of a previous lockbox submission.
New Transmission
-
Yes: To import a new bank file.
-
No: To resubmit an existing lockbox transmission.
Transmission Name
-
If you set the New Transmission parameter to Yes, enter a new transmission name.
-
If you set the New Transmission parameter to No, enter the name of the lockbox transmission that you’re resubmitting.
Submit Import
-
Yes: To import a new bank file. You must also enter the data file, control file, and transmission format information for the new bank file.
-
No: To resubmit an existing lockbox transmission.
Data File
The bank file to import. You must include the file extension. For example: /home/ar/lockbox/bofa9101.dat.
Submit Validation
-
Yes: To validate a new bank file or to revalidate a previously imported bank file.
-
No: To skip the validation process.
Lockbox
The number of the lockbox to validate. If you set the Submit Validation parameter to Yes and the lockbox number isn’t specified in your bank file, then you must enter a lockbox number.
Accounting Date
Enter the accounting date to use to post the receipt and batch records in this lockbox transmission to the general ledger. If you set the Submit Validation parameter to Yes, then you must enter an accounting date.
-
If you defined the accounting date in the lockbox as Constant Date, enter an accounting date.
-
If you defined the accounting date in the lockbox as Deposit Date or Import Date, then the process uses either of these dates as the accounting date.
Report Format
-
All: Include all records processed in the Validation section of the report.
-
Rejects Only: Include only the records that failed validation.
Complete Batches Only
-
Yes: Only transfer the receipts in a lockbox batch if all records pass the validation step.
-
No: Transfer any receipts within a batch that pass validation, even if others are rejected.
Allow Payment of Unrelated Invoices
-
Yes: Apply receipts to the debit items of unrelated customers.
-
No: Apply receipts only to the debit items of customer accounts with whom you have an account relationship.
Post Receipt with Invalid Transaction Reference as Unapplied
-
Yes: Allow the import of a receipt applied to more than one transaction, even if one or more of the transactions are invalid. The unapplied portion of the receipt is transferred as an unapplied amount.
You can later manually apply any unapplied amounts to transactions.
-
No: Only allow the import of a receipt applied to more than one transaction when all of the transactions are valid.
-
Yes with Claim: To create a Channel Revenue Management claim investigation from an invalid remittance amount.
Allow the import of a receipt applied to more than one transaction, even if one or more of the transactions are invalid. The invalid applied remittance amount is created as a non-invoice-related claim investigation.
Submit Post Receipts
-
Yes: Apply receipts in the lockbox transmission and update the customer balance.
-
No: Process receipts without applying them to transactions. Select this option if you want to review and edit receipts before applying them to customer open debit items.
Number of Instances to Process AutoApply
Enter the number of AutoMatch workers submitted from lockbox, if there are any unresolved references from the lockbox validation.
Report Output
The report is divided into two sections:
-
Import: Displays the total number of records that were imported into the interface tables successfully.
-
Validation: Provides details for each record and the total amount and number of receipts in each lockbox transmission.
The Import section of the report is generated when you submit the lockbox import step. The report prints a line at the end of the Import section informing you of any rejected records.
The Validation section of the report is generated if you set the Submit Validation parameter to Yes. Use this section of the report to see the number of records that pass or fail validation. You can also see the total amount and number of receipts in each lockbox transmission.
The number of records for this transmission and their corresponding statuses.
The deposit date, bank origination number, deposit time, destination account, and 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
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.
The receipt batch information for each batch in the 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 the batch, the total receipt amount, currency, and the deposit date and accounting date for the receipt batch.
The details of each record and the status of that record.