cancel
Showing results for 
Search instead for 
Did you mean: 

Can you sell two products from one inventory listing?

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

--

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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