Home Page link  

Worksheet Style 101: Synchronize store database

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Worksheet Style 101: Synchronize store database Raymond Cheok 08-27-2005
Posted by Raymond Cheok on August 27, 2005, 1:35 pm
Please log in for more thread options
 Anybody knows exactly what style 101 does? I accidentally deleted an item in
HQ, but the item still exists in Store, can I run 101 to restore the item in
HQ?

TIA

Raymond



Posted by Antonio Mazzeo on August 29, 2005, 11:39 am
Please log in for more thread options
 no, you can't!...

if you work with latest release of HQ the item isn't removed.. but only
marked how DELETED ITEM..

your db and hq version?
antonio




Posted by Raymond Cheok on August 29, 2005, 7:13 pm
Please log in for more thread options
On 8/29/05 5:39 PM, in article ehjzLyHrFHA.3016@TK2MSFTNGP12.phx.gbl,

> no, you can't!...
>
> if you work with latest release of HQ the item isn't removed.. but only
> marked how DELETED ITEM..
>
> your db and hq version?
> antonio
>
>
HQ and Store is version 1.2.0186
Item in HQ is missing, so I guess its removed, its not marked deleted. Could
it be data corruption?



Posted by Antonio Mazzeo on August 29, 2005, 3:34 pm
Please log in for more thread options

> HQ and Store is version 1.2.0186
> Item in HQ is missing, so I guess its removed, its not marked deleted.
> Could
> it be data corruption?

or a wrong reference from so/hq..

from hq administrator|database|query

SELECT * FROM HQRecordDeletedLog WHERE TableName = 'Item'

they are all items deleted from item table.

or SELECT * FROM Item WHERE Inactive = 1

antonio




Similar ThreadsPosted
Cannot Synchronize Database-101 Worksheet will not complete at sto October 9, 2008, 9:19 am
synchronize a store database to another HQ database June 8, 2006, 9:52 am
Worksheet 51 to copy from HQ database to each store database July 8, 2008, 12:07 pm
Transaction Deadlock with worksheet Style 250 February 12, 2007, 10:17 am
Worksheet Style 307: Adjust Item Quantities October 2, 2007, 5:14 pm
New Style Worksheet to upload static item attributes December 27, 2007, 1:54 am
Style 304 (Change item price) worksheet issue from 1.3 refresh July 7, 2006, 2:52 am
HQ 401 worksheet - existing store September 20, 2005, 3:10 pm
Sending Stock take worksheet to Store from HQ August 26, 2008, 4:24 pm
WorkSheet 250 Will not remove Substitute Items at store level October 24, 2008, 1:52 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap