Round Invoice Header.Invoice Amount to nearest 5000 dollars
Summary
Round Invoice Header.Invoice Amount to nearest 5000 dollarsContent
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
Tagged:
0