Need Matching BANK_TRX_NUMBER to a sub-set of Batch Number in AR (or AP)

Hi All,

I'm having the following issue as the bank is truncating information in their BAI2 file and reconciliation is not possible.  I'd very much appreciate if anybody could share if you have experienced an issue like this one.

The batch number is being captured in AR (or AP) as a complete number, in this case (091000012907016); however, the bank is truncating the 3 first characters (O91) and adding “IA” to the rest of the numbers (IA000012907016).

 

Bank Statement Line.

16,169,118374748,,,00123456789,/ 

88,OTHER REFERENCE:IA000012907016/ 

88,CUSTOMER 1 PYMT 063800 TRN*1*457358\/ 

 

The mapping template is

TRX_TEXT 16 -1 

INVOICE_TEXT 16 -2 

BANK_TRX_NUMBER 16 -1 REFERENCE:IA(~)