55
I created items on HQ then exported database to store, but when I check for some items in the store, I can't find them and not appear in the snapshot quantity report. so I made worksheet 250 and 260 but still can not find in the store database. so what can I do to see them in the store and in the report?
*This post is locked for comments
Please do close this thread and mark as 'verified' to help others. Thank u.
Many thanks my friend. I tried it and the query really fixed my problem. thanks a lot again Ahmed
Hi Ahmed,
Most probably you have missing record in the ItemDynamic table, run the following queries in HQ: -
select count(*) from item
select count(*) from store
select count(*) from itemdynamic
the last result should equal 1st result * 2nd result
if they are not matching, then u need to run the following fix
******************
insert into itemdynamic(itemid,StoreID,quantitycommitted,quantity,ReorderPoint,RestockLevel,SnapShotQuantity,SnapShotQuantityCommitted)
select item.id as ItemID, store.id as StoreID,0 as quantitycommitted,0 as quantity,0 as ReorderPoint,0 as RestockLevel,0 as SnapShotQuantity,0 as SnapShotQuantityCommitted
from item cross join store
left join itemdynamic on item.id=itemid and store.id=storeid
where storeid is null
********************
Ahmed Nashat
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (