You might be better off using a UD table to tracking the packages you have
available for a given part. That way your actual inventory wouldn't need to
have 3 different parts just because you have the same thing in multiple
packages. This would also prevent you from having to have 2-3 different
parts on an order just because they need to be picked differently.
It's a bit more involved to setup, but it would prevent your users from
having to take too many extra steps when picking and processing orders.
I've seen a number of other companies using this kind of setup for similar
situations and it works pretty well.
You basically just need to enter the package sizes when you receive the
parts and when you ship them. It's not a big trick to adjust your pick
slips (or whatever your warehouse guys are using) so they automatically
look at the available packages and display appropriately. Something like:
UK P20 x 122, pick as follows:
2x UK P20
2x UK P20 BAG OF 10
1x UK P20 BOX OF 100
*John Driggers*
**
*Chief Data Wrangler*
**
**
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
**
**:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
*
*
**
available for a given part. That way your actual inventory wouldn't need to
have 3 different parts just because you have the same thing in multiple
packages. This would also prevent you from having to have 2-3 different
parts on an order just because they need to be picked differently.
It's a bit more involved to setup, but it would prevent your users from
having to take too many extra steps when picking and processing orders.
I've seen a number of other companies using this kind of setup for similar
situations and it works pretty well.
You basically just need to enter the package sizes when you receive the
parts and when you ship them. It's not a big trick to adjust your pick
slips (or whatever your warehouse guys are using) so they automatically
look at the available packages and display appropriately. Something like:
UK P20 x 122, pick as follows:
2x UK P20
2x UK P20 BAG OF 10
1x UK P20 BOX OF 100
*John Driggers*
**
*Chief Data Wrangler*
**
**
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
**
**:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
*
*
**
On Mon, Oct 15, 2012 at 6:30 PM, Vantage <vantage@...> wrote:
> **
>
>
> Chris,
>
> After you pull your kit bill into the order you would change the quantity
> per on the kit line items. For your example of 122 part see below
>
> part number UK P20 KIT Bill would consist of with some description like
> �UK part a�;
>
> (1) UK P20
> (1) UK P20 BAG OF 10
> (1) UK P20 BOX OF 100
>
> If your customer wanted 122 pc�s enter UK P20 KIT line item on your sales
> order. Then you could change the description on UK P20 KIT to �122 PC�s UK
> part a� Then modify the kit part qty�s as such;
>
> (2) UK P20
> (2) UK P20 BAG OF 10
> (1) UK P20 BOX OF 100
>
> The system should then update the UK P20 KIT cost to 2x UK P20 + 2x UK P20
> BAG OF 10 + 1x UK P20 BOX OF 100.
>
> Steve
>
> From: <mailto:vantage@yahoogroups.com> vantage@yahoogroups.com [ <mailto:
> vantage@yahoogroups.com> mailto:vantage@yahoogroups.com] On Behalf Of
> Chris Thompson
> Sent: Monday, October 15, 2012 10:07 AM
> To: <mailto:vantage@yahoogroups.com> vantage@yahoogroups.com
> Subject: Re: [Vantage] Vantage - Dealing with multiple packs of the same
> part
>
>
> Hi Steve,
>
> Thanks for your email.
>
> From what we can see you would have to change your standard BOM which
> would mean your costing was wrong, and to get it do BAGS OF 10, you would
> have to enter a decimal place for the multiple pack to get it to equate to
> PACK OF 100.
>
>
> Does this make sense to you? I am only passing on the message (I don�t
> know the ins and outs).
>
> Thanks,
>
> ________________________________
> From: Vantage <vantage@... <mailto:vantage%40rmgfelm.com> >
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>
> Sent: Monday, 15 October 2012, 12:00
> Subject: RE: [Vantage] Vantage - Dealing with multiple packs of the same
> part
>
> Chris,
>
> You could create a manufactured part that is setup as a sales kit setup
> and make sure that sales can modify the kit. This part could use your part
> number UK P20 and would have a bill structure of 1 of each of the part
> number stocked. When the customer order the 112 part you could simple put
> the UK P20 on the sales order and change the description to show the
> quantity that they ordered. The order then be modified to change the sales
> kit part to the correct qty�s to reflect the ordered qty. The sales kit can
> be setup to show only the line item like your UK P20 line and not the kit
> parts on your paper work but your sales pick list will show the kit
> quantities to pick.
>
> I hope this helps.
>
> Steve
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:
> vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of
> Chris Thompson
>
> Sent: Monday, October 15, 2012 2:52 AM
>
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>
> Subject: Re: [Vantage] Vantage - Dealing with multiple packs of the same
> part
>
> Hi Steve
>
> I am not entirely sure what you mean - please could you expand on your
> suggestion?
>
> Thanks,
>
> ________________________________
>
> From: Steve_E <vantage@... <mailto:vantage%40rmgfelm.com> <mailto:
> vantage%40rmgfelm.com> >
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com>
>
> Sent: Friday, 12 October 2012, 13:49
> Subject: RE: [Vantage] Vantage - Dealing with multiple packs of the same
> part
>
> Would you be able to create sales kit that has all package sizes on it
> that is setup to modify. When you attach it to the order you can change qty
> and delete off any package sizes you do not need?
>
> Steve
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:
> vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On Behalf
> Of Chris Thompson
> Sent: Friday, October 12, 2012 7:35 AM
>
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com>
>
> Subject: [Vantage] Vantage - Dealing with multiple packs of the same part
>
> We have an in-house problem which we would like to try and solve. Please
> see below:
>
> We have a scenario where we currently have single items on the
> shelf and items in multiples of 5, 10 etc.
>
> Example part numbers:
>
> UK P20
> UK P20 BAG OF 10
> UK P20 BOX OF 100
>
> The BAG OF 10 and BOX OF 100 are physical units which are on the
> shelf.
>
> When a customer orders eg 112, we will put on the order 1 x UK
> P20 BOX OF 100, 1 x UK P20 BAG OF 10 and 2 x UK P20. All paperwork will
> have
> them split like this all the way through to the invoicing stage, even
> though
> the customer ordered 112 x UK P20.
>
> We would prefer not to have them like this.
>
> We would prefer to have one sellable part on the system of UK
> P20.
>
> When the customer order 112, we want the system to do one of the
> following:
>
> Option 1:
>
> The system sees that we have 1000s in stock of UK P20 which is
> the only sellable version of this part (even though they may be in
> denominations of 1, 10 and 100). We want to be able to manually tell the
> system
> to make up the order of 112 I want you to use 1 x BOX OF 100, 1 x BAG OF
> 10 and
> 2 x Singles. All customer-facing paperwork will appear that they have
> ordered
> and paid for 112 x UK P20, but when the order goes to stores for picking,
> they
> will see to complete that line on the order that they need to pick 1 x UK
> P20
> BOX OF 100, 1 x UK P20 BAG OF 10 and 2 x UK P20. They will pick them and
> pack
> them as per our specific Picking and Packing routines. The packing list
> may say
> eg
>
> Line
> 1
> Part: UK
> P20
>
> Qty: 112
>
> Made up of:
>
> UK P20 BAG OF 10
>
> UK P20 BOX
> OF 100
>
> UK P20
>
> Option 2:
>
> In an ideal world, the system would look at 112 and say right
> you have x BOXES OF 100 in stock, x BAGS OF 10 and x SINGLES. To make up
> this
> order I would suggest using 1 x BOX OF 100, 1 x BAG OF 10 and 2 x SINGLES.
> The
> paperwork would all say 112 x UK P20, but the store men will see if broken
> down
> into it�s denominations and display the �internal� (non-sellable finished
> goods
> part numbers).
>
> We have a similar scenario which is more of a manual thing where
> we have:
>
> Part
> Qty parent
> part per multiple part
> P50-50
>
> 1 (single
> item � catalogue part)
> P50-50 TWIN
> PACK
> 2
> P50-50
> BUBBLEWRAP
> 1
> P50-50
> PALLET
> Unknown (can
> vary)
>
> If a customer orders eg 3 x P50-50 our sales team currently sell
> them 1 x P50-50 and 1 x P50-50 TWIN PACK providing both are in stock.
>
> Again, the customer is only ordering P50-50 so all of the
> paperwork they see should relate to this and nothing else.
>
> Likewise if they order a larger qty, we will see them eg 50 x
> P50-50 PALLET.
>
> When we sell this part, a Works Order is raised to take 50 x
> P50-50 BASE (sub-assembly bases) and 50 x P50-50 LID (sub-assembly lids)
> and
> put them on a pallet. The operator�s time is captured to put them on the
> pallet.
>
> When the works order is completed, the P50-50 PALLET is classed
> as being in stock and can then be picked.
>
> Somehow, with this PALLET example the SO Entry screen would have
> to interrogate the sub-assembly stocks for the BASE and LID to see if we
> have
> enough.
>
> In all cases we only want the customer facing paperwork to
> display the part numbers that they are actually ordering.
>
> If this is not possible, how do you deal with similar parts?
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
[Non-text portions of this message have been removed]