Run AutoLockbox to submit your lockbox transmission processes and transfer payment information from your bank files into Receivables. Submit AutoLockbox from the Submit Lockbox Processing window.
Use AutoLockbox to import your invoice-related receipts. You must process non-invoice related receipts (such as investment income) through the Receipts window using a receipt type of 'Miscellaneous'.
You can import, validate, and run AutoLockbox all in one step, or perform the steps separately using the same window. For example, you can import data into Receivables and review it before validating it within Receivables. Upon examination and approval, you can submit the validation step and Receivables will automatically validate your data and create QuickCash receipt batches.
Caution: When you receive your bank file, be sure to name the file and move it to the appropriate directory. You will need to specify the location of your bank file when you submit AutoLockbox. If you receive daily files from your bank, be careful not to overwrite the files from the previous day.
Receivables uses SQL*Loader to load information from your bank files into AutoLockbox tables. For SQL*Loader to load your bank file properly, each logical record that your bank sends to you must end with a carriage return; otherwise, SQL*Loader displays an error message when you initiate AutoLockbox.
Attention: If you are using the automatic receipts feature, AutoLockbox ignores all transactions in this transmission that are selected for automatic receipt (i.e. transactions assigned to a payment method whose associated receipt class has Creation Method set to 'Automatic').
To run AutoLockbox:
1. Navigate to the Submit Lockbox Processing window.
2. If you are importing a new bank file, check the New Transmission check box, then enter a new Transmission Name. If you are resubmitting an existing lockbox transmission, you can select a name from the list of values.
3. To import a new bank file into Receivables, check the Submit Import check box, then enter your bank file's Data File, Control File, and Transmission Format information. If you are re-importing data, the default is the transmission format you specified in the initial import step. You can either accept this value or override it. When you run the import step, Receivables automatically generates the import section of the Lockbox Execution Report.
4. To validate or revalidate imported data and create QuickCash receipt batches, perform the following:
a. Check the Submit Validation check box.
b. Enter the Lockbox Number to validate. If this is not a new transmission, the default lockbox number is the number used for the original step of this transmission. If you specified Lockbox Number as a value to be imported from the bank file when you defined your transmission format, or if the transmission format shows that a number already exists, Receivables skips this field. You must enter a lockbox number if Submit Validation is Yes and the lockbox number is not specified in your bank file.
c. To apply receipts to transactions belonging to unrelated customers, check the Allow Payment of Unrelated Invoices check box.
d. Enter the date to post the receipt and batch records in this lockbox transmission to your general ledger in the GL Date field. If you defined your GL Date as 'Constant Date' in the Lockboxes window, you must enter a GL Date; if you specified a GL Date of 'Deposit Date' or 'Import Date', Receivables uses this as the GL date. If this is not a new transmission, the default is the GL date of the original transmission.
e. Enter a Report Format. When you submit the validation step, Receivables creates the Lockbox Processing Validation report. This report lets you review all records that pass and fail validation. Enter 'All' to include all records processed in this transmission. Enter 'Rejects Only' to include only records that failed validation. See: Lockbox Execution Report.
Note: Use the Maintain Lockbox Transmission data window to review and edit records that fail validation. See: Maintaining Lockbox Transmission Data.
f. To transfer only the lockbox batches in which all records pass the validation step to the QuickCash tables, check the Complete Batches Only check box. If you do not check this check box, Receivables will transfer any receipts within a batch that pass validation, even if others are rejected.
5. To apply receipts in this transmission and update your customer's receivable balance, check the Submit Post QuickCash check box. Do not check this box if you want to review and edit your receipt batches in the Quick Receipts window before applying them to your customer's open debit items. See: Reviewing Receipts in a Lockbox Transmission.
Note: You can also submit Post QuickCash from the Receipt Batches window. See: Post QuickCash.
6. To import receipts that could not be fully applied into the interface tables, check the Allow Partial Applications of Receipts check box. If this box is checked, Lockbox will import a receipt that is listed to be applied to several invoices, even if one or more of the invoices are invalid and Lockbox could not apply to them. In this case, Lockbox transfers the receipt into the AR_INTERIM_CASH_RECEIPTS table, and you can then manually apply payment to the invalid invoice(s) using the Applications window.
If Allow Partial Applications of Receipts is not checked, receipts that Lockbox cannot fully apply will remain in the AR_PAYMENTS_INTERFACE table. In this case, you need to edit the invalid record(s) in the Lockbox Transmission Data window, then submit the Validation step again for these receipts.
7. Save your work. Receivables displays the Request ID of your concurrent process and generates the Lockbox Execution report. See: Lockbox Execution Report.
The request ID assigned when you first import a new bank file is associated with this lockbox transmission throughout all steps. Use this request ID to check the status of a transmission in the View Transmission History window.
Reviewing Receipts in a Lockbox Transmission
After you successfully import and validate your receipts using Lockbox, you can review them in the Quick Receipts window. Use the Transmission region in the Receipt Batches window to query all receipt batches that included in one transmission and update or delete any receipt information.
You can review Lockbox receipts before or after you run Post QuickCash. If you submitted Post QuickCash for this lockbox transmission, you can only review these receipts in the Receipts or the Adjustments window. See: Running AutoLockbox.
You can review receipts that failed the validation step in the Lockbox Transmission Data window. See: Maintaining Lockbox Transmission Data.
To review validated receipts in a lockbox transmission:
1. Navigate to the Receipt Batches or the Receipt Batches Summary window.
2. Query the batch. You can query by transmission, Lockbox, or Batch Name.
3. Choose Quick Receipts.
Maintaining Lockbox Transmission Data
AutoLockbox Field Reference
Lockbox Execution Report
Commonly Asked Questions