parent/child Part II (similar parents and children)

Another twist to the parent/child issue:

We order brake cables in a box of 100, but sell them individually. HOWEVER, we don't always get the same brand of cable from a given supplier, therefore the reorder numbers are different, as would be the ILCs, I'd imagine. For instance:

Supplier Brand # in Box Reorder #

1 A 100 CABLE-A 1 B 50 CABLE-B

2 B 50 B-CABLE

2 C 50 C-CABLE

3 A 100 BRANDA100

3 C 50 BRANDC50

At the POS, we just consider the cables one brand, not A, B, or C. So, without having to keep track of which brand is being used, how could we have as few ILCs as possible at the register, without being restricted to just stocking one brand?

Thanks!

______________________________________________________

Larry Leveen OlyBikes Bikes, Parts, Repairs & GREAT Customer Service!

124 State Avenue NE Olympia, WA 98501

P: 360-753-7525 F: 360-528-7526 snipped-for-privacy@olybikes.com

formatting link
Featuring free bike advocacy and safety materials!

Reply to
OlyBikes News
Loading thread data ...

Best way is to create a generic ILC. Put it at the register and add all additional suppliers tot he supplier tab. Using the alias tab, put each reorder number there. It accomplishes a two fold task:

  1. not having multiple ILC for same component
  2. You can see which supplier charges you what in one glance.
Reply to
Elizabeth

I appreciate your reply, but it doesn't seem to resolve the issue of different suppliers handling similar objects in different parent quantities that we sell by the each.

So far, we are have just committed to > Best way is to create a generic ILC. Put it at the register and add

Reply to
OlyBikes

I appreciate your reply, but it doesn't seem to resolve the issue of different suppliers handling similar objects in different parent quantities that we sell by the each.

So far, we are have just committed to one supplier's parent/child item, but it's not very convenient, so other solutions are appreciated.

Elizabeth wrote: > Best way is to create a generic ILC. Put it at the register and add > all additional suppliers tot he supplier tab. Using the alias tab, > put each reorder number there. It accomplishes a two fold task: > 1. not having multiple ILC for same component > 2. You can see which supplier charges you what in one glance. >

--

______________________________________________________

Larry Leveen OlyBikes Bikes, Parts, Repairs & GREAT Customer Service!

124 State Avenue NE Olympia, WA 98501

P: 360-753-7525 F: 360-528-7526 snipped-for-privacy@olybikes.com

formatting link
Featuring free bike advocacy and safety materials!

Reply to
CptSoft

I think the problem is that each supplier may supply multiple brand/quantity combinations for the same generic part. I'm about 95% sure that you can't add the same supplier to an item twice...

I think you could get most of what you want by creating multiple SUPPLIER Records (1A, 1B, etc...) so that when you want to buy a particular brand or quantity you would select the appropriate supplier on that PO.

This doesn't solve the problem of trying to order the different quantities in case lots (1 case of 100 vs. 100 single items).

I don't think this is ever going to be clean on both the ordering and selling ends. Maybe you could create individual skus for each brand and set them up as substitutes for each other?

Glenn Adams Tiber Creek C> Larry,

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.