HQ item code store qty info missing

Nov 21, 2006 1 Replies

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


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

Join the Discussion

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

Didn't find your answer?

Ask the community — no account required