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.
-------------------------------------------------------------------------------------------------------