PO from HQ

We're generating PO's from HQ and sending them to our stores, however, I'm running into the following problem:

Our stores are in different states and often use different suppliers. An item record at HQ will list multiple suppliers, however, only one supplier is primary. So, when I order for Store A, it will use the primary supplier listed in the item table. However, Store B may use a different supplier for the same item. So, if I run a PO for Store B, it will grab the item but not use the correct supplier.

I'm thinking of creating a custom table that lists storeid,itemid,supplierid. I'll then update the supplierid in the item table each time I need to order for a specific region/store. (i.e. UPDATE item SET supplierid = NewTable.supplierid FROM NewTable WHERE item.id = NewTable.itemid and storeid = x)

My question is, do I need to go through all this trouble, or is there an add-on available that will allow me to specify (from HQ) a primary supplier per store? Ordering from HQ is not possible (or easily accomplished) if you cannot specify different primary suppliers for different geographical regions.

Reply to
cesmi1
Loading thread data ...

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.