You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Round Invoice Header.Invoice Amount to nearest 5000 dollars

Received Response
12
Views
2
Comments
edited Nov 18, 2020 5:06AM in Financials – General 2 comments

Summary

Round Invoice Header.Invoice Amount to nearest 5000 dollars

Content

Our FinApInvoiceApproval rules are currently based on the Invoice Header.Invoice Amount but we have a requirement to round Invoice Header.Invoice Amount to nearest 5000.

In SQL it would be say select round(Invoice Header.Invoice Amount/5000,0)*5000 from dual but when we use round(Invoice Header.Invoice Amount/5000,0)*5000 in FinApInvoiceApproval the error "RUL-05716: The function "round" is not valid here." appears.

Any ideas how we can route the approval based on Invoice Header.Invoice Amount rounded to the nearest 5000?

Many thanks

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!