re synchronize the HQ database

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

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date re synchronize the HQ database Shari 03-02-2009  RE: re synchronize the HQ database convoluted 03-02-2009  RE: re synchronize the HQ database Shari 03-02-2009  RE: re synchronize the HQ database convoluted 03-02-2009  RE: re synchronize the HQ database Shari 03-02-2009  Re: re synchronize the HQ database dc 03-05-2009
Posted by Shari on March 2, 2009, 12:11 pm Please log in for more thread options I need to re synchronize the HQ database with store operations database. There are items in the HQ database that do not exist in the store operations database. How can I go about doing re synchronization? Posted by convoluted on March 2, 2009, 1:40 pm Please log in for more thread options Create and approve worksheet 250 for the items that are not in the store databae. Processing that worksheet will add them to the store operations db - hope this helps "Shari" wrote: > I need to re synchronize the HQ database with store operations database. > There are items in the HQ database that do not exist in the store operations > database. How can I go about doing re synchronization? Posted by Shari on March 2, 2009, 3:29 pm Please log in for more thread options Thanks for the help convluted. the 250 worksheet did not work. In the initial implementation all items did exist in both databases. Subsequently some items were deleted in the store database but still exist in the HQ database. For example the store id is 30 and the item number is 120. In the HQ database you see the item existing for the store, but in the store database you do not see the item. Is there any way to correct this. "convoluted" wrote: > Create and approve worksheet 250 for the items that are not in the store > databae. Processing that worksheet will add them to the store operations db > - hope this helps > > "Shari" wrote: > > > I need to re synchronize the HQ database with store operations database. > > There are items in the HQ database that do not exist in the store operations > > database. How can I go about doing re synchronization? Posted by convoluted on March 2, 2009, 5:01 pm Please log in for more thread options Check that the item is not flagged as inactive at the store. Query the store database as another option: select hqid, itemlookupcode, description from item where itemlookupcode = 'type_the_itemlookupcode_here' the hqid in the store db must match the item id in the hq db hope this helps "Shari" wrote: > Thanks for the help convluted. the 250 worksheet did not work. In the > initial implementation all items did exist in both databases. Subsequently > some items were deleted in the store database but still exist in the HQ > database. For example the store id is 30 and the item number is 120. In the > HQ database you see the item existing for the store, but in the store > database you do not see the item. Is there any way to correct this. > > "convoluted" wrote: > > > Create and approve worksheet 250 for the items that are not in the store > > databae. Processing that worksheet will add them to the store operations db > > - hope this helps > > > > "Shari" wrote: > > > > > I need to re synchronize the HQ database with store operations database. > > > There are items in the HQ database that do not exist in the store operations > > > database. How can I go about doing re synchronization? Posted by Shari on March 2, 2009, 5:40 pm Please log in for more thread options In the item table I see all the items with the HQID, StoreID, and the itemlookupcode. But when I look in the Store operations database the itemlookupcode for that specific item is not in that database. I sent the 250 worksheet but that did not work. The item exist in the HQ database when you run a query for the StoreID and the itemlookupcode. But when I go to the physical store the item is not in the database. Do I need to delete the store and create it back? "convoluted" wrote: > Check that the item is not flagged as inactive at the store. > > Query the store database as another option: > select hqid, itemlookupcode, description from item where itemlookupcode = > 'type_the_itemlookupcode_here' > > the hqid in the store db must match the item id in the hq db > > hope this helps > > "Shari" wrote: > > > Thanks for the help convluted. the 250 worksheet did not work. In the > > initial implementation all items did exist in both databases. Subsequently > > some items were deleted in the store database but still exist in the HQ > > database. For example the store id is 30 and the item number is 120. In the > > HQ database you see the item existing for the store, but in the store > > database you do not see the item. Is there any way to correct this. > > > > "convoluted" wrote: > > > > > Create and approve worksheet 250 for the items that are not in the store > > > databae. Processing that worksheet will add them to the store operations db > > > - hope this helps > > > > > > "Shari" wrote: > > > > > > > I need to re synchronize the HQ database with store operations database. > > > > There are items in the HQ database that do not exist in the store operations > > > > database. How can I go about doing re synchronization? Similar Threads Posted synchronize a store database to another HQ database June 8, 2006, 9:52 am Cannot Synchronize Database-101 Worksheet will not complete at sto October 9, 2008, 9:19 am Worksheet Style 101: Synchronize store database August 27, 2005, 1:35 pm Synchronize POS with Server Database after Service Pack 2 December 26, 2008, 9:25 pm Synchronize HQ data from SO October 15, 2007, 1:20 pm Offline Synchronize problem March 21, 2006, 4:17 pm Synchronize field length in RMS and GP July 17, 2007, 6:06 pm Synchronize new field in table TransactionEntry January 25, 2007, 3:41 pm Worksheet 51 to copy from HQ database to each store database July 8, 2008, 12:07 pm Database offline error when database is local December 22, 2008, 1:42 pm