Use the Lockbox Transmission Data window to delete and edit transmission data imported into Receivables from your bank using Lockbox. You can correct your lockbox data in this window for receipts that fail validation, then resubmit the validation step to import these receipts.

Use the Lockbox Execution report to help you determine which transmission records you need to correct to ensure that your validation processes succeed.

If you are updating information, be sure to update only those fields that have data corresponding to the transmission format used to submit the import process.

Prerequisites

• Run AutoLockbox

• Use the Lockbox Execution report to identify invalid records.

To maintain lockbox transmission data:

1. Navigate to the Lockbox Transmission Data window.

2. Enter or query the lockbox transmission. Within each transmission, Receivables displays the lockbox and batch records first, followed by the receipts and overflow records. The lockbox import program assigns a date to transmission records that you import into Receivables and displays transmissions by date when you query them in this window.

   The Lockbox Transmission Data window displays the following record types if they are contained in your data file: Service Header, Transmission Header; Lockbox Header; Batch Header; Receipt; Overflow Receipt; Batch Trailer; Lockbox Trailer; Transmission Trailer. You can modify any of the values in these records.

3. To review error messages, place the cursor in the Status field, then choose Edit Field from the Edit menu. This field is set by the validation process.

4. Enter Comments about this transmission (optional). Receivables transfers comments for batch header records to the Receipt Batch after you run Post QuickCash. Receivables transfers batch header comments if the batch header does not include comments. You can review and update comments about a batch in the Receipt Batches window.

5. If the error is contained in the control, receipt, or application information, you can make changes to the invalid records by selecting the record, then choosing one of the following:

   • Receipt: Choose this button to review and edit specific receipt information. You can change the values of fields that are included in your transmission format.

     Attention: In the Lockbox Receipt window, you can update the transaction codes that Receivables automatically assigned to receipt records during the import phase. To view the Transaction Code field in the Lockbox Receipt window, enable the Enable Transaction Code profile option. See: Profile Options in Oracle General Ledger.

     This feature is available only in public sector installations.

   • Receipt Attributes: Choose this button to review and maintain receipt descriptive flexfield information imported with your lockbox transmission. You can change the values of fields that are included in your transmission format.

   • Applications: Choose this button to review and maintain application information for each receipt within this transmission. You can apply a receipt to debit or credit items. When applying to credit items, Receivables increases the amount of the receipt that can be applied to debit items by the amount of the credit. You can apply up to eight transactions to each receipt record. To apply more than eight transactions, use overflow records for your receipt. Each overflow record can be used to apply an additional eight transactions to the receipt. Use the Status field to review errors for specific receipt applications.

     Attention: In the Lockbox Applications window, you can update the transaction codes that Receivables automatically assigned to application records during the import phase. To view the Transaction Code field in the Lockbox Applications window, enable the Enable Transaction Code profile option. See: Define profile options.

     This feature is available only in public sector installations.

     Select the Cross Currency Data region to review information about cross currency receipts. See: Using AutoLockbox to Import and Apply Cross Currency Receipts.

   • Control: Choose this button to review the lockbox transmission control information that corresponds to this transmission record. You can change the values for fields that are included in your transmission format.

     Attention: Lockbox formats receipt amounts during the validation step. Therefore, values in the Lockbox Control window do not contain decimals.

6. Save your work.

7. Resubmit the transmission for validation. See: Running AutoLockbox.