+13
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
View original
+15
Hi,
You can use the replace function to replace decimal with null value as follows.
Shehan Almeida.
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
+13
Building new template in APPS10, I will try both suggestions to see which one works best for us.
Thank you for the quick response.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
