Automatic Procedure To Compare Original PO Qty/Value X To Invoices Qty/Value (Doc ID 2914731.1)

Last updated on DECEMBER 12, 2022

Applies to:

Goal

Is there an automatic way in the system to avoid Multiple Invoices that refer to a same PO, to exceed the total PO $ value or total PO quantity?

For example, PO #1 with 500 units of item A and a total value of 5,000 $.

In REIM, via EDI (for example, but not necessarily) receive invoice I001 with 400 units and a value of 4,000 $.

If the user tries to create invoice I002 with 200 units and a value of 2,000 $, for the same PO.

Would there be a way to alert the user that is creating invoice I002 that it will exceed the quantity and value for PO #1? Or is there a way to "reject" this invoice?

The concern is to overpay for one Order. If that is not possible, is there any suggestion on how to handle that?

And aware that there are tolerances for matching invoices and receipts, but this question is focused on the creation of invoices against POs.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.