Solved

Supplier Positive Pay Function detail

  • 10 September 2021
  • 3 replies
  • 99 views

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?

 

 

icon

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

Hi,

 

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

 

 

Shehan Almeida. 

Userlevel 7
Badge +11

Hi, 

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, 

Thomas

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.