supplier info confusion HELP!!!! :o)

Can somebody explain this ....

I have an item on my DB which is supplied by 3 different suppleirs, but one ILC. If I run a sales report and group it by supplier, will it know how many i have sold from each supplier? And if so how does it know?!

Thanks!

Reply to
Philip Gass
Loading thread data ...

Reply to
convoluted

Hmm, thats annoying!

So, If i sell $500,000 of an item from supplier B, and $445,000 of the same item from supplier A. I would set the primary supplier for that item to be supplier B. At the end of the year when i ask it for sales by supplier, its going to tell me that i have sold none of these items from supplier A?

I dont really want duplicate items for sake of supplier, but might be only option, or i can i suppose look at the costs from each supplier on the PO side? Hmmmm.

Reply to
Philip Gass

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.