NetSuite – Positive Pay – Bank of America CashPro – CSV

Today I had an issue importing the output of NetSuite’s positive pay feature into Bank of America’s CashPro. ┬áThe default output is fixed length format without any decimals in the value and date formatted at MMddyy. I don’t even think the CashPro system will accept an amount without decimals or the date not formatted as MM/dd/yyyy.

The fixed length values were as such:
[ACCOUNT][ISSUE(O)/VOID(V)][CHECK NUMBER][AMOUNT(no decimals)][DATE MMddyy][PAYEE]

Sample output with stock NetSuite functionality:

My old uploads were working fine as comma separated values, so I set out to try and make the advanced printing tool output in the CSV as I had been using.
The CSV format was as such:
[ACCOUNT],[ROUTING],[ISSUE(I)/CANCEL(C)],[CHECK NUMBER],[AMOUNT(decimals)],[DATE MM/dd/yyyy]

There were 5 main issues.
1. Adding the commas to separate the values
Adding a comma between every ${value} was simple enough to fix this issue

2. Inserting the bank routing number (the default export doesn’t have this)
Pretty simple to just hard code the value as Bank of America’s routing number to the output as such

3. Changing the issue/cancel value (the stock was O/V but my imports use I/C)
This was just coded as prety simple check function at the top of the formatting, so I just need to change the alpha values for the function

4. Change the amount formatting to include a decimal
A bit of research and a StackOverflow answer led me to correcting this one by adding ?string(“0.00”) to the end of the getAmount(payment) value

5. Change the date format to long year with slashes to separate
Increased length of the date to 10, changed yy to yyyy, and adding slashes was easy enough,

The resulting advanced template is below:

Sample output of above template below:

Bank of America CashPro import profile setup:
Bank of America CashPro - Positve Pay Profile

Very minor change, but a good one to get started off on. I could not find much documentation about the positive pay formatting, and this was my first experience with the advanced templates.

Leave a Reply

Your email address will not be published. Required fields are marked *