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
HQ item code store qty info missing
Nov 21, 2006
1 Replies
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