Share
ReportLooking to sync my store/s re-order points to HQ
*This post is locked for comments
You’re offline. This is a read only version of the page.
215
Looking to sync my store/s re-order points to HQ
*This post is locked for comments
Yes that should work fine. Toad does the same thing, just a more visual program. Can I send you the table outputs/layout I'm looking for... email me and I can reply. Of course I want to pay you for your time as well... I could do paypal or whatever works best... mail@woodenwheels.com
Hi Tom,
I don't know Toad for SQL - I use SQL Management Studio, but could perhaps email you a report that you could run RMS HQ and once generated, right click and either export or copy as table and paste in Excel. Would that work?
OK... Thanks.
Instead of me making a disaster of things would you be interested (for a fee of course) in writing me a query so I can export my data to an excel file... I'm using Toad for SQL. I could email you the layout of what I'm looking for? My email is mail@woodenwheels.com
Hi again,
Not sure if you are aware, but RMS keeps a Restock Level and Reorder Point for each item in addition to the SnapShot Restock Level and SnapShot Reorder Point. Is it possible that you're looking at the Restock and not the SnapShot Restock? If you run the query below, this will show you the difference between what HQ has programmed and what's actually in the store.
-- BEGIN Query --
SELECT Store.Name as Store, ItemLookupcode, Description,
ItemDynamic.RestockLevel, SnapShotRestockLevel, ItemDynamic.ReorderPoint, SnapShotReorderPoint
FROM Item
LEFT JOIN ItemDynamic ON Item.ID = ItemDynamic.ItemID
LEFT JOIN Store ON Store.ID = ItemDynamic.StoreID
WHERE
ItemDynamic.RestockLevel <> SnapShotRestockLevel
OR
ItemDynamic.ReorderPoint <> SnapShotReorderPoint
-- END Query --
Thanks Heidi... unfortunately the 401 doesn't sync my store re-order points to HQ and I've tested it both ways with no success... I can use a 308 to selectively send down HQ re-order points to the store level but that's it?
Hi Tom,
The store's restock levels and reorder points are already in HQ (they update with the 401 worksheet). They exist in the ItemDynamic table - SnapShotReOrderPoint and SnapShotRestockLevel. Both these fields appear on your HQ Manager Report under Items --> SnapShot Store Quantity List.
Cheers, Heidi
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
