We are running HQ and SO 1.3r. We have an "outside" application that has loaded some items into the HQ database. However, the programmer failed to load the corresponding ItemDynamic entries. Can someone provide me with a SQL program that will search through the ITEM table and add the appropriate ITEMDYNAMIC entries for each of our stores? So, far - no inventory has been received for these items but they soon will be and then this problem will only be compounded. Your SQL expert assistance is requested.
Thank you ... in advance.