You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!