on 07-22-2014 4:39 PM
The scenario is as follows:
We buy one product 'ABC' from our supplier and store this in a location in our warehouse.
We sell this product to our customers as part number 'ABC'.
The issue arises because we also sell this product as a different product 'XYZ', which is basically product 'ABC' but it is tested before it leaves the warehouse and supplied with a certificate and is charged out at a higher price.
Is it possible to set up an inventory listing for product 'XYZ' that will send the picker to product 'ABC' and reduce this items stock level?
Any help on this would be great as it has been a problem for us for some time.
You might try using a Sales Kit for product XYZ.
This should work for you:
Inventory Item: ABC
Sales Order Item 1: ABC
Sales Order Item 2: Sales Kit XYZ
Sales Kit XYZ consist of:
>>Inventory Item ABC
>>Certificate (optional but may be worth calling out to note the fact that it exists)
When you sell Sales Kit XYZ your ABC inventory will be decremented by 1. The sales order will show the Sales Kit and the detail of the items in the Sales Kit.
As always, try this in your test instance first. Mileage may vary.
Jim
--
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jim,
Thanks for your reply.
We have tried going down the sales kit route and it can work for our main company as a workaround but unfortunately the sales kit cannot work for a Third Party scenario.
We have a second company that is set up as a Third Party where the sales kit feature does not work.
Any other ideas would be welcome.
Cheers
Phil
Hi Philip,
I have an idea to do it.
Create an extension field( Customer Part No) in product master level and fill this field with the customer part no apart from the original material ID. Extend the same to the screens you may work and also to output forms as well.
Extend this field to all the screens and output forms, so that this will reflect in the output forms. Here you can see 2 fields one is of original material ID and another one is of customer material ID.
Hence the person who is going to pick the material will have 2 ids in hand and the inventory will be maintained in the Original Material ID(ABC) itself.
Just check this work around, it may help you.
If you dont need the Original Material ID(ABC) to reflect in the output forms, then create 2 forms one is with the Original Material ID(ABC) and another one is without Original Material ID(ABC). So that before releasing any transactions we can choose anyone of the document be clicking the Edit Output Settings.
Regards,
Samraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.