AutoLockbox Validation
Receivables validates the data you receive from the bank to ensure that the entire file was received, there are no duplicate receipts within a batch, and that customers and invoices are valid.
AutoLockbox also validates all of your data for compatibility with Receivables. AutoLockbox validates your data by ensuring that the columns in AR_PAYMENTS_INTERFACE reference the appropriate values and columns in Receivables.
- Transmission Level Validation: AutoLockbox validates your lockbox transmission to ensure that transmission information corresponds to your transmission format. The following attributes are validated:
- Transmission format contains receipt records
- Lockbox number is part of the transmission format or you specify it when you submit AutoLockbox from the Submit Lockbox window
- GL date is in an open accounting period
- Total transmission record count and amount that you supply must match the actual receipt count and amount that is determined by AutoLockbox
- Origination number is valid if it is provided
- Lockbox Level Validation: AutoLockbox validates your lockbox records to ensure that lockbox information corresponds to your transmission format. The following attributes are validated:
- Lockbox number is specified in either the Lockbox Header or the Lockbox Trailer, and is valid
- Lockbox batch count is correct if it is provided
- Lockbox amount is correct if it is provided
- Lockbox record count is correct if it is provided
- Origination number is valid if it is provided
- No duplicate lockbox numbers
- Batch Level Validation: AutoLockbox validates your batch records to ensure that batch information corresponds to your transmission format. The following attributes are validated:
- Batch name exists on batch records
- Batch name is unique within the transmission
- Batch record count is correct
- Lockbox number exists on batch records if this number is part of the transmission format
- Receipt Level Validation: AutoLockbox validates your receipt records to ensure that receipt information corresponds to your transmission format. The following attributes are validated:
- Remittance amount is specified
- Check number is specified
- Item number is specified and is unique within a batch, a lockbox, or the transmission, depending on the transmission format
- Lockbox number is specified (if this number is not part of the Lockbox Header or the Lockbox Trailer of the transmission format) and batches are not imported
- Batch name is specified (if either Batch Headers or Batch Trailers are part of the transmission format)
- Account number is specified (if Transit Routing Number is part of the transmission format)
- Invoice1-8 are either valid or are left blank
Attention: If you are using matching numbers and a receipt record indicates that multiple transactions will be paid by this receipt, Lockbox assumes that all of the transactions are the same type (e.g. invoices, sales orders, purchase orders, etc.). For example, if the first 2 transactions are invoices, Lockbox will successfully match them with this receipt. However, if the next transaction is not an invoice, Lockbox will either import the remaining receipt amount as unidentified or reject the entire receipt (depending your Lockbox definition).
- Installment1-8 are either valid installment numbers or are left blank
- Invoice, debit memo, credit memo, deposit, on-account credit, or chargeback number derived from the matching number does not belong to a guarantee or receipt
- Transaction number is entered where an application amount is specified
- Sum of all of the Amount Applied columns for a receipt does not exceed the remittance amount
- Customer number is valid (refer to Customer Validation below)
- Customer number and MICR number both reference the same customer (if both are provided)
- Receipt date is specified
- Currency is valid (refer to Currency Validation below)
- Overflow Level Validation: AutoLockbox validates your overflow records to ensure that overflow information corresponds to your transmission format. The following attributes are validated:
- Batch name is specified (if either Batch Headers or Batch Trailers are part of the transmission format)
- Lockbox number is specified (if either the Batch Header or the Batch Trailer are not specified and the transmission format includes lockbox number)
- Item number is specified and matches a receipt record
- Overflow indicator is specified (unless it is the last overflow record)
- Overflow sequence is specified
- Invoice1-8 are valid invoice numbers (these numbers are optional, and can be left blank)
Attention: If you are using matching numbers and a receipt record indicates that multiple transactions will be paid by this receipt, Lockbox assumes that all of the transactions are the same type (e.g. invoices, sales orders, purchase orders, etc.). For example, if the first 2 transactions are invoices, Lockbox will successfully match them with this receipt. However, if the next transaction is not an invoice, Lockbox will either import the remaining receipt amount as unidentified or reject the entire receipt (depending your Lockbox definition).
- Installment1-8 are either valid installment numbers or are left blank
- Transaction number derived is entered where an application amount is specified
- Customer Validation: AutoLockbox can either validate your customer data based on the following attributes, or mark the receipt as 'Unidentified' if no match is found:
- Bill-To customer is from an AutoAssociated invoice (if AutoAssociate is enabled)
- Currency Validation: Receivables lets you process receipts in multiple currencies. If you pass the currency code, exchange rate type, and receipt date, AutoLockbox will try to determine the exchange rate. If it is unable to determine the exchange rate, the receipt will fail validation.
Receivables also supports cross currency deposits. This implies that receipts in your lockbox can be either in the same currency as that of the bank account, or in any other currency, provided the bank account is in your functional currency and its Multiple Currency Receipts field is set to Yes (Bank Accounts window, Receivables Options alternative region).
See Also
Transmission Formats
Running AutoLockbox
Lockbox Execution Report
Commonly Asked Questions