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

Can the invoice date X days beyond sysdate be used in BPM to auto-reject invoices?

Received Response
31
Views
6
Comments
in Payables, Payments & Cash Management 6 comments

Summary:

Oracle allows the Invoice Date field to be FAR future dates, causing issues with aging and payments.  We are looking to use BPM Invoice Approvals to auto-reject the invoice if the date is X days beyond the sysdate. (ex: more than 60 days beyond sysdate)

Content (please ensure you mask any confidential information):

Oracle, in the UI and imports, allows the Invoice Date on invoices to be entered far into the future. This is stemming from user typos, either in the application directly, or in a 3rd party system which is imported into Oracle.

We are not looking for Oracle to stop these incorrect dates, but to utilize Invoice Approvals to check the Invoice Date by comparing to the current system date. ex: If the invoice date is less or equal to sysdate + 60, approve. If the invoice date is great than sysdate + 60, then reject.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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