+14I 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
Hi,
You can use the replace function to replace decimal with null value as follows.
Shehan Almeida.
+19Hi,
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
+14Building 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 E-mail address. We'll send you an e-mail with instructions to reset your password.
