The store quantity tab in hq is blank with no stores names showing. Also it is not showing taxes either. Is something wrong with the items dynamic table, because it does show quantites on some items, but not all items. Is there a sql script to update qty & taxes to show up in thoes tabs.
Thank you for your support Dave
Dear DCR, It seems you have created the HQ blank database, and stores are not created in HQ. could you confirm how you setup this. Kindly confirm that in Admin
setup the stores > The store quantity tab in hq is blank with no stores names showing. Also it
Hi Nashat
I had the same problem on my HQ and I tested the SQL script you provided. The store quantity tab in hq is no longer blank, but some items that were showing negative values in the Inventory tab are now reset to 0. Is there anything else that needs to be done in the system (HQ and stores) once this script is run? Were our negatives values part of the bug?
Regards
- J.B.
"Nashat" a écrit dans le message de news: uw$ snipped-for-privacy@TK2MSFTNGP04.phx.gbl... Dave,
Find attached the script to fix the ItemDynamic table, please BACKUP FIRST
Hi Nashat
I had the same problem on my HQ and I tested the SQL script you provided. The store quantity tab in hq is no longer blank, but some items that were showing negative values in the Inventory tab are now reset to 0. Is there anything else that needs to be done in the system (HQ and stores) once this script is run? Were our negatives values part of the bug?
Regards
- J.B.
"Nashat" a écrit dans le message de news: uw$ snipped-for-privacy@TK2MSFTNGP04.phx.gbl... Dave,
Find attached the script to fix the ItemDynamic table, please BACKUP FIRST
I also have this problem. Could you please email the script please
Barry Le> I have had this problem before...could you email the script please... >
Have something to add? Share your thoughts — no account required.
Ask the community — no account required