1. Home
  2. Point-Of-Sale Software
  3. HQ not showing items at all stores

HQ not showing items at all stores

I have noticed that some of my items don't show up on the Store Quantity tab of the HQ item properties form.

For example, I have HQ Item ID 8699. Shows store quantities correctly for three of four stores. Fourth store is not even on the list.

In the store database (the store that's not shown in HQ for this item) the HQID is correct.

I tried issuing a WS501 Request Full Item Count but when I go to reconcile using Inventory task 190, the ILC in question is not even on the list.

I tried issuing a WS250 but that didn't help either.

There are other items like this (not too many), but the missing store is not always the same one.

Ideas?

Tom

Reply to
Terrible Tom
Loading thread data ...

you have missing records in ItemDynamic table, run the attached script and it will fix it for you. BACKUP FIRST you will need to issue WS 501 to get the correct values for the records inserted by the script

begin 666 Correct ItemDynamic New.sql M:6YS97)T(&EN=&\@:71E;61Y;F%M:6,H:71E;6ED+%-T;W)E240L

Reply to
Nashat

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.