Supplier Positive Pay Function detail

  • 10 September 2021
  • 3 replies

Userlevel 5
Badge +10

I need help with function detail on Check Amount field. I need to remove the decimal point but keep the numbers (ie.. 4005.63 convert to  400563) ? Bank file import assumes first 2 numbers from the right are cents and they don’t need the decimal point.

Any suggestions?




Best answer by Shehan Almeida 10 September 2021, 20:13

View original

This topic has been closed for comments

3 replies

Userlevel 7
Badge +14



You can use the replace function to replace decimal with null value as follows.



Shehan Almeida. 

Userlevel 7
Badge +11


I did so many tests for a client (different use cases).  We have a number of ways to do this.  This below is pretty easy.  use multiply. 

 The file then looks like this…


Best regards, 


Userlevel 5
Badge +10

Building new template in APPS10, I will try both suggestions to see which one works best for us.


Thank you for the quick response.