HQ item code store qty info missing

I attempted producing a transfer worksheet from HQ and couldn't transfer a number of items as I received a message "Unable to transfer this item". I checked the item properties and saw there was no information displaying in the store quantity tab. I did an item movement report and it showed activity at 3 stores but again the store tab page is blank. I reindexed the files which didn't help. Can someone give me an idea as to what caused this and how is it fixed? Thanks

Reply to
John G
Loading thread data ...

u have missing records in ItemDynamic table, run the attached script but don't forget to BACKUP FIRST

begin 666 Correct ItemDynamic.sql M9&5C;&%R92! 4W1O

Reply to
Nashat

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.