Positive Pay Files
Positive Pay File cannot have commas in the Payee
|
paula Administrator Posts: 208
7/25/2014
|
paulaAdministrator Posts: 208
The following substitute function will remove the comma and retain the decimal when formatting the check amount:
"{FormatNum: ÷{DocAmnt}÷, 8, 2, ' ', '0',}"
The 8 represents the number of characters to the left of the decimal . The 2 represents the number of characters to the right of the decimal. The ' ' will pad the dollar value with spaces. Remove the space to eliminate the pad. The '0' will pad the cents with zeros.
This function must be nested inside the CSV function. For example: {CSV: «{FormatNum: ÷{DocAmnt}÷, 8, 2, ' ', '0',}»}
Commas can be removed from the Payee data with at String Translation (StrTran) function, though this is often handled before the Positive Pay file. An example of the StrTran follows:
«{StrTran:÷{DocRecip}÷, ',', ''}»
The ',' identifies the value to change, in this case the comma, and the '' replaces the comma with a blank. Similar to the FormatNum function, the StrTran function must to nested in a CSV function.
For more information, see the Substitute Functions section of the PrintBoss Manual available on our web site, http://www.wellspringsoftware.com/, under the Support menu.
|
|
|
0
link
|
|
mreichenbacher Posts: 1
7/25/2014
|
We setup up Positive Pay file in CSV format. The amounts and some of the Payees have commas within the data. The bank cannot accept the data in this way. I found a command that will remove the commas and decimals from the amount, but I need the decimals. Can anyone tell me what to do to eliminate the commas within the amount and payee data?
Thanks!
|
|
|
0
link
|