Wednesday, July 22, 2009

You cannot Invoice on a Purchase Order when the quantity billed exceeds the

Problem Description
-------------------
You cannot Invoice on a Purchase Order when the quantity billed exceeds the
quantity invoiced.


Problem Explanation
-------------------
For an amount based Purchase Order, if the quantity received is lesser than the
quantity ordered and billed, the system creates a hold on the Invoice.
The system hold namely 'Quantity billed exceeds quantity received' cannot be
released.

Example:

Quantity ordered = 5000
Quantity received = 2822.61
Quantity billed = 5000

Invoice is on hold.

Responsibility: AP Manager
Navigation:
Navigator -> Invoices -> Entry -> Invoices


Search Words
------------
Quantity billed ,Invoice on hold, Purchase Order match.

Solution Description
--------------------
The Invoice on hold can be released by changing the Invoice Quantity Ordered
Tolerance and the Invoice Quantity Received Tolerance in Setup in Accounts
Payables. Alternatively, the Invoice can be released manually by disabling the
match option in Invoices.


Solution Explanation
--------------------
Quantity billed exceeds quantity received by tolerance amount. This is a system
defined hold.

This can be done manually by releasing the hold.

Responsibility: AP Manager
Navigation:
Navigator -> Setup -> Invoices -> Tolerances


1. Check the Maximum quantity received. This can be defined in terms of
percentage and amount.

2. The hold can be released by changing the tolerance amount (both quantity
ordered and quantity received).

4. The Purchase Order can then be approved after the hold is released.

Alternatively,

Navigate to Accounts Payables responsibility and disable the Match option.

Navigation:
Navigator -> Invoices -> Entry -> Invoices

The Invoice will be released from the hold and it can be approved.

APPROVAL ON 3WAY MATCH INVOICE THRU APXINWKB DOES NOT PLACE QTY REC HOLD

Problem Description:
=====================
In Oracle Payables, you are using 3 way matching, for which an invoice matched
to a po must have qty received to satisfy the match.
The QTY REC hold is not being set from invoice level or batch level.

Problem Explanation:
====================
You had set 3 way matching on the vendor level.
You tried to create an invoice and match to a po, where there was no quantity
received. This should have indicated a QTY REC hold, but it did not.

You set his tolerance to .0001%, at the vendor level quantity received tolerance.

This didnt make a difference.

Solution Description:
=====================
The tolerance needs to be set at the Tolerance form.
gui \ setup invoice tolerance
char \ nav setup invoice tolerance
Quantity Received set to 0 or above %.

Solution Explanation:
=====================
There are two tolerances on this form:
Quantity Ordered
and Quantity Received.
The quantity ordered would allow at most x% of qty billed greater than the
quantity received.

Quantity Ordered
----------------

Enter the percent difference above purchase order shipment line quantity
ordered that you allow vendors to invoice. When you submit AutoApproval,
Oracle Payables places a Qty Ord hold on an invoice when the quantity billed
exceeds the quantity ordered on the matched purchase order shipment line by
the percent you enter in this field.

Quantity Received
-----------------
Enter the percent difference above purchase order shipment line quantity
received that you allow vendors to invoice. When you submit AutoApproval,
Oracle Payables places a Qty Rec hold on an invoice when the quantity billed
exceeds the quantity received on the matched purchase order shipment line by
the percent you enter in this field.

The quantity received field should have 0 or greater in it.

The problem with max qty received is now fixed for online approval.