Purchasing Material

This chapter covers the following topics:

Overview of Purchasing Consigned Material

The consigned from supplier business practice can be used for purchasing some or all of the materials in a warehouse. Material purchased on consignment is defined in the Approved Supplier List (ASL).

After the decision to procure items on consignment has been made, and the consigned relationship has been defined, buyers use existing processes for requisitioning and purchasing consigned material. The requisitioning process is the same for both consigned inventory and regular procurement.

Whenever you purchase goods on consignment, the goods must be delivered into inventory where they can be tracked, reported to the supplier, and consumed.

Note: Expense destination material is not purchased using consigned inventory, because these goods are consumed immediately.

When a buyer determines that supply is required for items purchased on consignment, the relevant purchase order shipment lines are automatically flagged as consigned. Similarly, receipts are designated as consigned receipts, and therefore no accounting is performed. When consigned goods are delivered into inventory, they are stored as consignment material and the supplier and supplier site are listed as the owning party.

You can report to the supplier all of the on hand balances of material held on consignment, including real-time information about consigned stock, consumption transactions, and invoices. This function is performed either through the Oracle iSupplier Portal or Oracle Inventory inquiries.

If you and the supplier agree to change purchase prices after consumption transactions are executed, you can retroactively reflect these price changes on consumption advices

Defining Approved Supplier Lists

You can create consignment relationships with your supplier using the Approved Supplier List (ASL) window. Your purchasing suppliers are created in the Suppliers window, and they are associated with the items you buy using the Approved Supplier List window.

Approved Supplier List Window

the picture is described in the document text

A consignment relationship can be established for a combination of Item, Supplier, and Supplier Site.

Local and Global Approved Supplier Lists

Your approved supplier can be either a local or global supplier. A local ASL is used only in the organization in which it was defined. A global ASL may be used in all organizations you specify.

Supplier – Item Attributes Window

You can enable the Consigned Inventory from Supplier feature on the Supplier–Item Attributes window.

Inventory Tab

the picture is described in the document text

On the Inventory tab, you can enable consigned inventory, indicate Billing Cycle Days, and define the Aging parameters. The Consigned from Supplier feature can only be enabled under the following conditions:

The validation for local ASL is done for the organization in which the ASL is being created. For Global ASL, this validation is done for all organizations under the same set of books.

Source Documents Tab

the picture is described in the document text

On the Source Documents tab, you can associate specific quotations and blanket purchase orders agreements with the supplier and item combinations. This enables Purchasing to default source documents automatically. All consigned enabled suppliers must have a referenced blanket purchase agreement. However, only blanket purchase agreements may be used as source documents for consigned inventory. The blanket purchase agreement may be either local or global.

When the consigned material is consumed, the system refers to the source document to retrieve the price applicable for the consumption. You can assign a specific blanket purchase agreement here, or set the profile option PO: Automatic Document Sourcing to Yes. Setting this profile option to Yes automatically makes the pricing information default from the most recently created blanket agreement. If the profile is set to No, the approved supplier list (ASL) is used to determine the blanket agreement.

Related Topics

Overview of Consuming Material

Requisitioning Consigned Materials

At the requisitioning level there is no difference between regular and consigned material. You can create a purchase order from a requisition for consigned material, only if the corresponding requisition is a Purchase requisition and not an internal requisition. The requisition must have a destination type of Inventory. After the system generates your requisitions, you can use the AutoCreate or Workflow processes to create purchase orders.

You can use Vendor Managed Inventory (VMI) in conjunction with consigned inventory, requiring your supplier to replenish your warehouse with consigned goods up to agreed upon levels.

For VMI, the supplier creates the requisitions to ensure the replenishment of consigned goods according to agreed levels.

Related Topics

Assigning Sourcing Rules, Oracle Purchasing User's Guide

Assigning Sourcing Rules and Bills of Distribution, Oracle Purchasing User's Guide

Using AutoCreate

You can use AutoCreate to create standard purchase orders for consigned material from requisitions. With AutoCreate you can choose between manually or automatically creating a new purchase order, or adding to an existing purchase order. When creating purchase orders from requisitions for consigned material, AutoCreate performs the following actions:

Document References

When using either Manual Creation or Automatic Creation mode, you cannot use a document reference. Whether a document reference is associated with the requisition, or you attempt to add a document reference using the New Document window, the document reference is not copied on the purchase order.

All document references must be removed before creating the purchase order because consigned shipments are not releases against global or contract agreements, and should not be calculated in the amount released against those agreements. These references are automatically removed by the system. If you attempt to create a purchase order using the manual autocreate process, the system generates the following message:

Note: The document reference is not valid for consigned shipments and will not be copied to the purchase order.

Using Automatic Document Creation Workflow

Oracle Purchasing is integrated with Oracle Workflow to create standard purchase orders automatically from approved requisition lines. This feature is also available for consigned purchase orders.

Document references (contracts, price lists, and so on) are not permitted on orders for consigned material. If you use the AutoCreate or the Automatic Document Creation Workflow processes, all document references are removed before the purchase order is created.

Note: Automatic creation of purchase orders for approved requisitions is enabled by setting the Release Method field on Item-Supplier attributes window of the approved supplier list to Release Using Autocreate. Also, ensure that the PO Create Documents workflow item attribute of Is Automatic Creation Allowed? is set to Yes.

Related Topics

Overview of Procurement Workflows, Oracle Purchasing User's Guide

Workflow for Creating Purchase Orders or Releases, Oracle Purchasing User's Guide

Choosing Workflow Options, Oracle Purchasing User's Guide

Setting Up Automatic Sourcing, Oracle Purchasing User's Guide

Entering Purchase Orders for Consigned Materials

Purchase orders for consigned material can be entered using the Purchase Orders window. The relevant purchase order shipment lines are automatically marked as consigned. When entering purchase orders for consigned goods, consider the following information:

Shipments Window

the picture is described in the document text

You can view the shipment line details in the Shipments window. Shipment lines for consigned material have the following attributes:

Distributions Window

The Destination Type for all consigned shipment distributions is always set to Inventory.

Related Topics

Entering Purchase Order Shipments, Oracle Purchasing User's Guide

Entering Purchase Order Headers, Oracle Purchasing User's Guide

Creating Approved Suppliers

Entering Purchase Order Distributions, Oracle Purchasing User's Guide

Receiving Consigned Inventory

You receive consigned material in same way in which you receive regular material, except that there is no accounting event that might increase financial liability. When receiving consigned material, you never match a payables invoice to a consigned receipt. When receiving consigned inventory the following access information applies:

Returning Consigned Inventory to Suppliers

You can return consigned materials to the supplier at any time using the same process that is used for regular material. No accounting entries are generated for consigned transactions returned to the supplier; however, any consumed material must be transferred back to consigned stock. Typically, the following steps are required to reverse the consumption transaction:

  1. Perform the component return transaction.

  2. Identify the consumption transaction against which the material is issued.

  3. Perform a transfer to consigned transaction to change the ownership.

Note: For serial controlled items that are already transferred to regular stock, ensure that they are first returned to consigned status before making a return to supplier transaction.


Related Topics

Using Automatic Consigned Returns for WIP Issue Transactions (Autoconsign Returns)

Setting Up Automatic Consigned Returns for WIP Issue Transactions

Oracle Work in Process User's Guide, Component Issues and Returns

Accounting and Costing Transactions for Consigned Inventory

Consigned Return Transactions Report (XML)

Run the Consigned Return Transactions Report (XML) report to identify the consumed material that is returned across billing periods. You can run this report at the owning organization level for a desired date range, and, optionally, define additional criteria such as item, subinventory, and other parameters.

Enter the following report parameters:

Request Parameters

Using Autoconsign Returns for WIP Issue Transactions

Consigned inventory from supplier refers to the arrangement where one party possesses the inventory but it remains the property of another party by mutual agreement. Consigned stock can be consumed by transactions such as sales order issues, work in process (WIP) issues, or any other transactions defined in the consumption setup. When inventory is consumed, the ownership of goods is transferred which creates a consumption advice that can be subsequently used to invoice the supplier.

Sometimes the consumption transaction may need to be reversed; for example, you may need to return a defective consigned item that was issued to a job as a component. When you reverse the transaction, the material is returned back to inventory as regular stock. If an ownership transfer is needed to move the material to consigned stock, Oracle provides an optional one-step autoconsign process for WIP component returns to automatically change the ownership of the consigned inventory to the actual supplier.

The autoconsign feature provides a one step process for returning material to consigned stock that has been consumed against a work in process (WIP) component issue. Automating this process increases efficiency because an operator does not have to perform a manual transfer to consigned transaction to complete the ownership transfer.

Important: The consumption advice created during the WIP issue will be net zero, so that an invoice will not be created for the original issue transaction. If the consumption advice has been processed, then the material will be returned as regular stock and an invoice for the original issue will be created.

Scenarios for Automatic Consigned Returns (Ownership Status)

When a WIP return transaction is performed, the issued material is returned to stock. The ownership of the transferred material depends on its ownership at the time of the WIP issue as outlined in the following scenarios:

Origin of Material at WIP Issue After Complete WIP Return: After Partial WIP Return:
All Material from Consigned Stock The material returns as consigned stock, and the consumption advice created during issue will be net zero. The material returns as consigned stock, the quantity of the consumption advice created during issue will be reduced depending on the quantity returned.
Material Partially Issued from Consigned Stock and Partially from Regular Stock at the time of WIP issue.1 The regular stock will be returned as regular and consigned stock will be returned as consigned. The consumption advice created during issue will be net zero The material will be returned as regular stock first, after all regular stock is returned, material will be processed for return to consigned. The consumption advice quantity will be reduced depending on quantity returned

1If the organization allows negative balances, and a negative quantity exists, when the consigned stock returned, then the positive consigned quantity will be inserted (as MOQD records), with the negative quantity untouched.

Other Scenarios

In all cases, if the invoice has been generated, the material can only be returned as regular stock, not consigned. An invoice will be created followed by consumption advices.


To perform returns for WIP issue transactions

You can issue and return issued components from jobs and schedules to inventory using the WIP Material Transactions window. There are two issue and return options available from this window: All Material and Specific Component. For more information about completing returns in the WIP Material Transactions window, see Oracle Work in Process User's Guide.

Querying Consigned On Hand Quantities

You can query and review Consigned and VMI on hand quantities using the Material Workbench. Consigned and VMI stocks are identified by the owning party and planning party attributes on the on hand quantities. Select the Consigned/VMI Tab on the Material Workbench to search for inventory that is designated for Consigned or VMI. The Owning Party region is used to enter the search criteria, and can be limited to All Owning Parties, All Consigned Stock, or you can Select Owning Party. Use the Planning Party region to enter the search criteria and select either All Planning Parties, All VMI Stock, or Select Planning Party.

Query Material Window

the picture is described in the document text

The search results display in the Material Workbench window.

Material Workbench Window

the picture is described in the document text

Note: Note that the concatenation of Supplier and Supplier site is shown as the owning party for the consigned on hand quantities.

Purchasing Intelligence and Consigned Inventory

Purchasing Intelligence supports consigned inventory. As previously mentioned, consigned purchase orders cannot be invoiced or paid. The goods ordered are received into consigned inventory at the receiving organization, and then transferred to regular inventory when they are ready to be consumed. When the Consumption Advice is generated against a blanket agreement, the release can be invoiced and paid.

Purchasing Intelligence addresses both standard and consigned purchase orders; it reflects these purchase order amounts in the appropriate reports and in the Key Performance Indicators (KPIs).

Purchasing Intelligence support for consigned inventory includes price based measurements. All price based measurements such as PO Purchases, Contract Leakage, and Non-Contract Purchases will only reflect the purchase order amounts for the consumption advice purchase orders (bill-only purchase orders). Consigned purchase orders (receive-only purchase orders), will be ignored, because they do not represent a purchasing commitment to the supplier.

Using Retroactive Price Update

The process of applying retroactive price updates to purchasing documents for consigned material is same as that for regular material. Consumption advices are retroactively update only when the profile PO: Allow Retroactive Pricing of Pos is set to ALL RELEASES.

You can execute retroactive price updates either from the PO Approval screen or by submitting the Retroactive Price Update concurrent program. When using the PO Approval screen to make retroactive price updates, enable the Apply Retroactive Price Update to Existing PO/Releases check box.

Note: Retroactive price update only applies to the consumption advice. Consumption transactions, for which consumption advices have not been created, will not be affected by retroactive price updates. Also note that Agreed Amount limit defined in the blanket purchase agreement (BPA) is not imposed when the price of the consumption advice is updated retroactively. The retroactive priced releases for consigned item are approved automatically, and are not submitted for approval checks even if it exceeds the agreed amount in the BPA.