HQ store qty & taxes missing

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

Reply to
DCR
Loading thread data ...

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

Reply to
Akber Alwani

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

Reply to
Julien Bonnier

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

Reply to
CptSoft

Reply to
Nashat
Reply to
Julien Bonnier
Reply to
Julien Bonnier

Reply to
Anthony Laidler

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... >

Reply to
barryl
Reply to
CptSoft
Reply to
Barry L

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.