Is there a way to upload, from our store DB file, our restock and reorder levels into HQ? Last year we had an incident with our HQ database and had to rebulid the file, many of the items do not have any restock or reorder numbers at the HQ level. Any help would be appreciated Thank-you
Restock/ Reorder levels
Feb 16, 2009
1 Replies
A couple ideas come to mind
- Export your reorder/restock levels from the store operations database to an excel file, save it as a csv file, then import that into worksheet 308 in headquarters (I'm thinking that processing that worksheet will update the HQ database)
- Use Access to create a linked table to the itemdynamic table in HQ where you would update those values - this is a little bit more "convoluted" as you'll need to get item id values, too....
If this can get you started, great - otherwise, holler. - h> Is there a way to upload, from our store DB file, our restock and reorder
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required