We have just started to support a customer who has over the past few years been creating items both at store and HQ level. This is now starting to cause problems as item IDs and HQ IDs are not matching. Has anybody any ideas of how we could resolve this issue and correct the mismatch.
Our customer has now been shown the correct procedure.
We had this problem too at one point. Basically you need to sync it up manually. Ensure that the storeoperations.item.hqid = hq.item.id and then run updates on the transactionentry table for those item id's. Also look for other tables that use item id's and make sure you update those. Tedious but doable.
-- Dan
snipped-for-privacy@hotmail.co.uk wrote:
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.