Receipt FBDI template for Auto Lock Box by using Customer Bank account

In the Auto Lockbox FBDI template, the Record 6 – Payments sheet includes the Customer Bank Account field (Column F). Our incoming bank file contains only the customer’s bank account number and does not include any additional customer identifiers such as Customer Name, Customer Account Number, or Site Number.

The business requirement is to use the Customer Bank Account value from the FBDI file to automatically derive the Customer Account and Customer Site during Lockbox processing. If the invoice number is not provided in the bank file, the receipt should be created as an Unapplied Receipt under the correct customer account.