R12: AP: Invoice Gets Prorated Against Shipment Distributions Resulting in Discrepancy WIth Receiving Quantities (Doc ID 2070477.1)

Last updated on APRIL 04, 2025

Applies to:

Goal

When a supplier delivers goods, some invoices can arrive just a few days after. When they do, Accounts Payables (AP) enters them into the system within a couple of days and matches them to the Purchase Order (PO) line. At this step, if it's a partial delivery, it's not clear how to distribute the quantities across the distribution lines, so users would just let the system pro-rate the quantities by the number of distribution lines.

As the goods require physical inspection, it can take time before the inspection and delivery transactions are entered in the system due to several factors. If it's a partial delivery, the warehouse person will finally enter the Deliver transactions based on what is suggested in the Receiving Transaction form. The way it's currently behaving, the quantities are suggested by fulfilling the quantities of the first distribution line before moving on to the next until the total quantities to be delivered are met.

Because of the difference in how the quantities are split between the invoices and the deliver transactions, this results in discrepancies between what gets costed to the project (PA) and what gets cleared from the accrual account. This becomes a problem if the quantities are delivered partially and the rest are returned/cancelled.

Is there any way that this problem can be avoided?
 

Solution

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