Consigned Inventory in Oracle Applications Setup & Process

Consigned Inventory in Oracle Applications Setup & Process

Consigned Inventory Overview

Consigned Inventory from Supplier exists when inventory is in the possession of one party(A Dealer,Agent,Distributor) ,but remains the property of another party (such as the manufacturer or primary contractor) by mutual agreement . Consigned  inventory from Supplier refers to one type of consigned inventory practice where you receive and maintain goods belonging to one or more of your suppliers Both Suppliers and Customers benefit through consigned inventory strategy.

1 .Suppliers are able to compete on the basis of availability and delivery when
finished goods are at the customer site, particularly when lead times are
lengthy.
 2. Holding material on consignment reduces the lead time for items to fill sales
orders.
3. Customers experience increased inventory turns—reducing funds invested in
inventory. Financial resources are free until customer commitments are ensured
or items used in production. 

Setup Steps : -

Create an Item "10490277-0001". Apply Purchasing template. Also tick "Use Approved Supplier" in purchasing tab and also enable Consigned Check box in General Planning Tab.

save it and assign the item to organization.

we need two subinventories, one for Asset sub inventory which is in possession of Customer and one for Expense in which supplier puts item. Expense subinventory will be placed in Customer Premises but possession of that subinventory will be to Supplier.

For creating subinventory go to Inventory > Setup > Organizations > Subinventories

And then create new subinventory (FG as Asset subinventory).

Now define Expense subinventory.

Set  Profile Option or Validate the Profile Option

INV: Allow Expense to Asset Transfer = Yes at Site Level 

Define Self Billing option at Supplier Level 

Supply Base > Suppliers > Search by Supplier name & Click on Purchasing  > Self Billing

Set Pay On = ‘Use’ and Invoice Summary Level = ‘Pay Site’

Create Blanket Purchase Order between Supplier and Customer.

Navigation: Purchasing > Purchase Order > Purchase Orders

 Make sure pay on "Use" is ticked in Supplier setups

Create an ASL for this Item and Supplier combination. On Item-attributes form assign above blanket Agreement in the Source Documents tab and  in Inventory tab click  the check box Consigned from Supplier.

Define Consigned\VMI Consumption rules in inventory.

 Nav : Inventory > Setup>Transactions>Consigned\VMI Consumption. 

Note : The weight value allows you to set the processing order. For example, if two transactions satisfy the transaction criteria, the system processes the transaction with the highest weight.

   Define Transaction Type

NAV: Inventory > Setup > Transactions > Types

Add Create Consumption Advice

Navigation: SYSADMIN > Security > Responsibility > Request  

Add the Concurrent Program ‘’ Create Consumption Advice ’’

Run the ‘’ Create Consumption Advice ’’ concurrent program. By default, this concurrent program will not be available in Inventory responsibility. You need to add it manually. In order to do so, check the Request group name in the responsibility & then Navigate Create consumption advice request has been processed.

Test Case 

Create Standard PO for same item and Supplier 

Go to shipment & check under More Consigned Check box is checked 

Approve the Purchase Order

Create Receipt and deliver the goods under Consigned non Asset Subinventory 

Check On hand 

Now transfer material from Consigned store to regular through Sub inventory transfer

NAV Inventory  > Transactions > Consigned Transactions

Now check the status of item on hand at the material workbench  Owning party information  

now transfer qty through

subinventory transfer from Consigned to FG 

Now, Run the concurrent “Create Consumption Advice”  under Inventory

And then 

Run the concurrent Pay on Receipt Auto Invoice with a transaction source of “ERS_AND_USE” for our inventory receipt number.

Thanks ,

------------------------------------------------------------------------------------------------------------------------------------------------------------------
Please share this knowledge with your friends and subscribe at our blog for more updates. If you have any queries, please participate in our Forum or by leaving your comments below.
-------------------------------------------------------------------------------------------------------