How do you get changes in the HQ Db picked up by Worksheets

If you can represent the change in a sql statement, then worksheet 51 is the easy answer, otherwise, use the item worksheets 250, 301-306 etc to apply those changes to the stores. Once you have your list in access of what to change in HQ, then use that same list to append the ItemIDs to the appropriate worksheet table before you approve it.

Style 51: Execute SQL Command dbo_Worksheet_SQL Style 206: Update Inventory - Suppliers dbo_Worksheet_SupplierUpdate Style 250: Update Inventory - Items dbo_Worksheet_ItemUpdate Style 301: Set Item Sale Prices dbo_Worksheet_SalePrices Style 302: Change Item Costs dbo_Worksheet_ItemCost Style 303: Change Item Ordering Info. dbo_Worksheet_SupplierList Style 304: Change Item Prices (Regular) dbo_Worksheet_ItemPrice Style 305: Change Item Prices (Level) dbo_Worksheet_ItemPriceLevel Style 306: Change Item Price Limits dbo_Worksheet_ItemPriceLimit Style 307: Adjust Item Quantities dbo_Worksheet_ItemQuantity Style 308: Change Item Restocking Info. dbo_Worksheet_ItemRestock Style 320: Adjust Items Sales Tax dbo_Worksheet_ItemTax Style 330: Inventory Transfer dbo_Worksheet_InventoryTransfer Style 340: PO Planner dbo_Worksheet_PurchaseOrder Style 350: Download Global Acct Adj dbo_Worksheet_GlobalAccountAdjustment Style 601: Delete Global Customers dbo_Worksheet_DelGlobalCustomers

Keep in mind that this kind of activity will greatly increase the HQ Client traffic to the stores, as it transmits the info to the store in the item worksheet, and then back to HQ in the next Wks401 upload.