Downloading SupplierList table from HQ to Store

Hi all ...

We have a custom developed add-on that uses the SupplierList table at HQ level. We also want to run this add-on at store level, but have problems since the SupplierList id's are different between HQ and store.

I have copied the SupplierList table from HQ to the store (on my test system), without any obvious problems yet revealing themselves.

Does anybody know if I will "break" anything at the store level if I sync the HQ SupplierList table to the Store SupplierList table?

Thanks, peter

Reply to
bange
Loading thread data ...

SupplierList.ID is just an identity. I can't think of any reason that you would care that this is the same from HQ to SO.

If you are talking about SupplierList.SupplierID or SupplierList.ItemId, then yes you will break something if you sync from HQ. The values in HQ's supplier list will be SO's Item.HQID and Supplier.HQID. Everything in SO is going to want the supplier list values to map to Item.ID and Supplier.ID. In your sample database, you will probably find that most of your data shows that ID = HQID. This happens a lot when you export a new store database from HQ, but it is coincidence - you can't rely on having it staty thatway.

Hope that helps...

Glenn Adams Tiber Creek C> Hi all ...

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.