In some cases, the bank file may not contain the customer information. In such cases, you can use this feature to match the customer with a transaction using the MICR number from the bank file. In addition to adding a customer, the connector also updates the MICR number for the customer of matching invoice in NetSuite if the MICR number is not present for any customer.
The Celigo Cash App MICR number > MICR Number field, in the following screen, is a custom record in NetSuite created by the connector to store the MICR number associated with each customer:
Use the following steps to configure MICR File Parsing parameter in the connector. This lets Cash Application Manager know where to read the MICR number in the bank file.
1. Click on the Settings icon against the Bank File to NetSuite flow. The Settings window is displayed.
2. Click on the File Parsing tab.
3. Expand Type 6 - Detail Record and click + Add New Row.
4. Enter the Field Description, Start Position, End Position, and Length values from the Bank file.
5. Click Save.
The following screen demonstrates a transaction record without the matching customer as bank file did not contain the customer information:
The following screen demonstrates the matching customer record for the MICR Number matching the bank file:
The following screen demonstrates the Customer field in the transaction record being updated with customer name associated with its MICR number: