Downloading SupplierList table from HQ to Store

Aug 09, 2006 1 Replies
B

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



Vote
Twitter Facebook LinkedIn
G

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 ...

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required