Update Restock level in HQ

That should be available in the Snapshot reports, but it will not show in the item properties at HQ.

Glenn Adams Tiber Creek C> Is there any way to update reorder point and restock level in HQ from SO. >

There's a worksheet - one of the 30x series, I forget whch one - that updates restock information. Run that to set the new values and it will update ItemDynamic AND the store.

Glenn Adams Tiber Creek C> How to update it in ItemDynamic table?

Thanks Glenn Adams, This sheet help us only update Reorder and Restock from HQ to SO.

Acctually i am using a procedure which automatically updating reorder and restock level of all selling items in SO but it is not reflecting in HQ .

Any other idea ?

Thanks

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Below is from the knowledgebase, but i didn't try yet.

By design, HQ Manager does not automatically populate the Reorder Point and Restock Level for each item from each store, giving HQ the ability to define its own values for these fields. However, if users would like to have the same values in HQ as each store has, the following SQL Statement can be run as often as necessary at HQ in order to populate these fields correctly.

1. Open HQ Administrator and connect to the HQ database (File | Connect).

1. Make a backup of the database (Database | Backup).

2. Open a new query (Query | New).

1. Enter the following statement:

UPDATE ItemDynamic SET ReorderPoint = SnapShotReorderPoint, RestockLevel SnapShotRestockLevel

1. Run the statement (F5 or Query | Run).

1. View your items in Manager, and verify the Store Quantity tab now has values for these two fields.

2. To save time the next time this query needs to be executed (after a store changes the values of the Reorder Points or Restock Levels), save the Query to your hard drive for use in the future (File | Save).

"NAVEED" wrote: