Share
Reporthi expert,
is there any standard functionality of 365 FO to handle customer consignment ? or any workaround ?
Categories:
You’re offline. This is a read only version of the page.
1,162
hi expert,
is there any standard functionality of 365 FO to handle customer consignment ? or any workaround ?
Thats a really good summary Sagar.
The problem we have with this workaround is master planning. Ideally we do not want master planning to be able to see this consignment warehouse stock as available. But if we make the warehouse non nettable we lose the ability to automatically create planned transfer orders to replenish the warehouse . Would this need to be a manual process?
HI Agus Setiawan ,
As Andre pointed there is not out of box functionality for managing customer consignment stock.
Workaround normally goes like this that you make one warehouse per consignment agent/customer and transfer inventory to consignment agent/customer warehouse using a transfer order when agent wants to order some goods from you.
As the ownership of the inventory physically lying with consignment agent lies with you you would need the ability to track the inventory in your system and using transfer order to transfer will give you the ability for the same.
You can anytime track which consignment agent has how much stock by using warehouse as dimension.
Later when agent will sell goods to final end customer and send back you invoices you will post sales order selecting actual end customer on sales order as recd on invoice and selling from consignment agent warehouse and posting actual invoices as received from agent.
This way you will do actual sales done from your consignment agent warehouse and realize sales against consignment.
Consignment agent will pay me lesser than invoice amount as he will deduct his commission. This difference in ledger between invoice and payment is settled using CN/DN for agent commission.
Hi agus,
I have done the following steps for your reference.
First ,
The owner must be ‘active’ in the tracking dimension group for item.
‘Item model group’ must be set up as “moving average” or “standard cost”.
Create a new item with above settings.
Second ,
Create a new consignment replenishment order and receive it.
Third ,
Create a new inventory ownership change and post it.
At the same time, a related PO is created automatically.
The same PO also can be viewed in
vendor collaboration --- Purchase orders consuming consignment inventory.
Four ,
View the status changed in inventory.
Regards,
QianQW
Hi Agus,
There is only a vendor consignment option. You can try to use a different site/warehouse. The customer should notify you when he sold an item, so you can invoice accordingly. Some companies do create a packing slip, but then you don't have the item as part of your inventory anymore.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (