duplicate items with different item look up codes ---

Posted by zoostation on August 5, 2006, 11:06 am

Please log in for more thread options

I have several items that are the same, but since I get them from different
suppliers, they have different item look up codes. For example, I have 4
different vendors for cherry tomatoes.

The problem is when reporting it can show as no item xxxxx tomatoes were
sold where in fact I sold $200.00 worth of cherry tomatoes under a different
look up code.

Is there a way to link the multiple item look up codes?

Thank you.

Posted by tschloeder@gmail.com on August 5, 2006, 2:02 pm

Please log in for more thread options

Could you used aliases? Just use one lookup code, say "CT", then use
each of your old lookuup codes as aliases for "CT", then put all four
cherry tomato vendors as suplliers.

zoostation wrote:

> I have several items that are the same, but since I get them from different

> suppliers, they have different item look up codes. For example, I have 4

> different vendors for cherry tomatoes.

> The problem is when reporting it can show as no item xxxxx tomatoes were

> sold where in fact I sold $200.00 worth of cherry tomatoes under a different

> look up code.

> Is there a way to link the multiple item look up codes?

> Thank you.