Remittance Strings in AutoMatch Rule set (Considering first 10 characters from Remittance String)
Summary:
We are receiving remittance strings in multiple formats for a customer (Record number 4 in lockbox BAI2 format file) and first 10 characters are transaction number, need to consider only the first 10 characters of the remittance string for auto‑matching transactions against receipts from lockbox files. Could you please advise on how to extract and use only the first 10 characters of the remittance string and share the required setup to achieve this?
We are expecting results like below
For A Customer |
|
|---|---|
Remittance String in Lockbox file | Consider Only First 10 Characters |
1000321121P | 1000321121 |
1000321121ASD | 1000321121 |
1000321121ASDF | 1000321121 |
1000321121_SASDF | 1000321121 |
1000321121_SASDF | 1000321121 |
1000321121AA | 1000321121 |
1000321121_8 | 1000321121 |
Content (please ensure you mask any confidential information):