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.