Initally we had a training store that was hooked up to HQ. Later we decided that was a bad idea, mostly because we kept sending worksheets to it, but the actual machine had been repurposed and no longer synchronized. So we ended up with alot of ws to the training store, that were never going to be processed. Our solution was a sql script to remove any worksheets associated with that particular store number. That worked great. Except that it made the store status for all of our stores display the exclamation mark that indicates incomplete worksheets. :( Anyone know how to reset that flag?
try removing the worksheetstore entries as well. For a store that you are never going to use, I would recommend to delete from the store list in HQ Manager - Admin - Stores.
actually as part of the script to remove the store2 worksheets, i did remove some entries from worksheetstore. here's the script i used:
DELETE from Worksheet_InventoryTransfer JOIN WorksheetStore on Worksheet_InventoryTransfer.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_ItemCost JOIN WorksheetStore on Worksheet_ItemCost.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_ItemPrice JOIN WorksheetStore on Worksheet_ItemPrice.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_ItemPriceLevel JOIN WorksheetStore on Worksheet_ItemPriceLevel.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_ItemPriceLimit JOIN WorksheetStore on Worksheet_ItemPriceLimit.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_ItemQuantity JOIN WorksheetStore on Worksheet_ItemQuantity.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_ItemRestock JOIN WorksheetStore on Worksheet_ItemRestock.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_ItemTax JOIN WorksheetStore on Worksheet_ItemTax.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_ItemUpdate JOIN WorksheetStore on Worksheet_ItemUpdate.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_PurchaseOrder JOIN WorksheetStore on Worksheet_PurchaseOrder.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_SQL JOIN WorksheetStore on Worksheet_SQL.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_SupplierList JOIN WorksheetStore on Worksheet_SupplierList.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet_SupplierUpdate JOIN WorksheetStore Worksheet_SupplierUpdate.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID ='2' DELETE from WorksheetHeader_PurchaseOrder JOIN WorksheetStore on WorksheetHeader_PurchaseOrder.WorksheetID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID= '2' DELETE from WorksheetHistory JOIN WorksheetStore on WorksheetHisotry.WorksheetID=WorksheetStore.WorkSheetID WHERE WorksheetStore.StoreID = '2' DELETE from Worksheet JOIN WorksheetStore on Worksheet.ID=WorksheetStore.WorksheetID WHERE WorksheetStore.StoreID = '2' DELETE from WorksheetStore where WorksheetStore.StoreID = '2'
I believe that this removed all ws referencing store 2. I do see that there are several entries into worksheetstore where the Date processed is "null" and the status is 0. These appear to be worksheets waiting to process. Most everything else in that table has a date processed and it's status is set to 1. Additionally some entries into worksheetstore have a status of 3. These entries Do have a date processed, and appear to be "acknowledged" worksheets.
While i was looking at worksheetstore, i noticed worksheethistory. It also has a status column however it defies my effort to explain it. Status here is either 1 or 0. Sometimes 1 is completed, sometimes 0 is completed. I'm starting to think that this table is where i should be looking.
"Matt Hurst" wrote in message news:% snipped-for-privacy@TK2MSFTNGP06.phx.gbl...
lol, np. But this isn't helping me with the flag on the store status in HQ manager. i really just want to reset those flags so i can tell when a worksheet is late .
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.