Skip to main content

How Do The Match Approval Level Option And Invoice Match Option Work?

1.Select one of the following options for Match Approval Level:
  • Two-Way: Purchase order and invoice quantities must match within tolerance before the corresponding invoice can be paid.
  • Three-Way: Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid.
  • Four-Way: Purchase order, receipt, accepted, and invoice quantities must match within tolerance before the corresponding invoice can be paid.
If you enter an item, the default value for this field comes from the item information at the organization level. If not defined there, the default comes from the item information at the master level. 
If you do not enter an item, the default is from your Purchasing Options.
See:Receiving Controls, Options, and Profiles.
   
   
2. Select an Invoice Match Option:
  • Purchase Order: Payables must match the invoice to the purchase order.
  • Receipt: Payables must match the invoice to the receipt.
Choose Receipt if you want to update exchange rate information on the receipt or if you want your accounting to use exchange rate information based on the receipt date. (If you use Periodic
Costing, you must match to the receipt to ensure accurate cost accounting.)
The Invoice Match Option defaults from the Supplier Sites window. You can change the Invoice Match
Option on the shipment until you receive against the shipment.
The Invoice Match Option and the Match Approval Level are independent options. You can
perform whichever Invoice Match Option you want regardless of the Match Approval Level.
 For example, you can set a PO to any one of the following examples:
   
#1 - PO#5049 - 2-way/Purchase Order
#2 - PO#5050 - 2-way/Receipt
#3 - PO#5051 - 3 way/Purchase Order
#4 - PO#5052 - 3 way/Receipt
   
The Invoice Match Option determines what document you can match the invoice to.  
In #2 & #4 If I do not create a Receipt for these POs and try to match the invoice to the PO, the system will error with:
   
APP-SQLAP-10655: You cannot match to this document.  You can match only to the document (purchase order or receipt) specified by the Invoice Match option on the purchase order shipment. Either match to the specified document, or update the Invoice Match option for the shipment and then complete this match.
    

The Match Approval Level determines what if any type of hold will be placed based on the Invoice Tolerance setup.
   
So let's say we create a PO like #3 PO#5051 - 3 way/Purchase Order, however, we do not receive the
PO.  In this case we will receive a qty hold because we have the PO set to 3 way matching.
'Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid.'

Comments

Popular posts from this blog

General Ledger FAQ

1.  What responsibility should I use when doing the set up for General Ledger? Use a seeded responsibility like 'Oracle General Ledger Super User'. You may also need to use the System Administrator responsibility. 2.  What are the pre-requisites required to define a new calendar? According to your business needs you need to decide the calendar type required i.e. monthly, weekly or biweekly, the number of periods, adjusting periods and the maximum number of periods within a fiscal year. 3. What are the pre-requisites required to define a new Ledger? Define a Calendar, Chart of Accounts and enable the functional Currency  and convention of subledger accounting method. 4. Why must I check the calendar definition before assigning to a Ledger? The calendar definition cannot be changed once it is assigned to a set of books so it is very important to check that the calendar definition is suitable to the specific business needs, has ...

Difference Between MTS, ATO, MTO ,PTO ,CTO and ETO.

 Make-to-stock (MTS) In MTS environments, products are created before receipt of a customer order. Customer orders are then filled from existing stock, and then those stocks are replenished through production orders. MTS environments have the advantage of decoupling manufacturing processes from customer orders. Theoretically, this enables customer orders to be filled immediately from readily available stock. It also allows the manufacturer to organize production in ways that minimize costly changeovers and other disruptions. However, there are risks associated with placing finished goods into inventory without having a firm customer order or an established need. These risks tend to limit MTS environments to simple, low-variety, or commodity products whose demand can be forecasted readily.  Assemble-to-order (ATO) In ATO environments, products are assembled from components after the receipt of a customer order. The key components in the assembly or f...

Accounting entries in Oracle Purchasing and Payables

This document gives in detail different accounts used and the accounting impact of various transactions that take place in Oracle Purchasing and Oracle Payables. Both Standard costing and Average costing methods are considered. The accounts are Oracle Applications specific and might differ from the conventional accounting names. Examples are given wherever required for better understanding of the concept. The sources of these accounts are given. PURCHASING:  Receiving – For Accrual Process for perpetual Accruals Receipts for inventory purchases are always accrued upon receipt. And also use perpetual accruals for expense purchases you want to record uninvoiced purchase liabilities immediately upon the receipt of the expense goods. Receiving Account (Receiving Account) To record the current balance of the material in receiving and inspection. Where to define in Apps: Define Organization           ...