Maintaining Lockbox Transmission Data
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 for 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
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 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:
- 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.
- 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.
- 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.
See Also
Using AutoLockbox
Lockbox Execution Report
Viewing Transmission History
Commonly Asked Questions