How to process Lockbox file with more than 99 invoices under one receipts?
Summary:
Unable to load lockbox receipts with more than 99 Invoices references
Content (please ensure you mask any confidential information):
We are using ORA_BAI2_Extended lockbox standard format file, their customers paying multiple hundred invoices on each payment. When that remittance information is being added under record type 4, OVERFLOW_SEQUENCE has going beyond 99. When OVERFLOW_SEQUENCE of 100 is populated, since overflow sequence is mapped from 9th byte to 10th byte with only 2 digits, it is not considering 1 and defaulting the OVERFLOW_SEQUENCE to 0 under AR_PAYMENTS_INTERFACE_ALL.OVERFLOW_SEQUENCE. Since for the same batch there are more than 1 records with OVERFLOW_SEQUENCE, lockbox is failing with
0