Home Page link  

new items in SO inventory but not HQ

  
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
new items in SO inventory but not HQ Cribstoteens 07-29-2008
Posted by Cribstoteens on July 29, 2008, 5:06 pm
Please log in for more thread options
 Our store has been using an evaluation of HQ, which I have set up and
experimented with. Now we are thinking about purchasing it, but we have
reached a problem. Our current employee who adds items to the RMS database
was not trained to use HQ, as I was just experimenting with it. Because of
this, the employee added the new items to the SO database instead of using HQ
and worksheets. Is there any way to have the new items from the store
database uploaded to the HQ database?

Posted by convoluted on July 30, 2008, 10:42 am
Please log in for more thread options
 Cribs - go ahead and purchase the HQ software.

If you were not polling between the HQ evaluation software and the store
operations software, just create your new headquarters database from your
store operations database that contains all your items. If all your items
were created in store ops then the HQID values will be zero in the item table.

If you had been exchanging (polling) between your HQ evaluation software and
the store operations software, here's how I'd handle: Export your item list
from your existing store ops database (you can run a report or a sql query
that includes the key information needed by QSCIMP); use QSCIMP to import
these items into a new store ops db - use this new store ops db to create
your HQ db.

QSCIMP is a free tool you can download if you have access to customersource.
If you don't have access to customersource, engage an RMS certified partner
that can perform this service for you.

Hope this helps

"Cribstoteens" wrote:

> Our store has been using an evaluation of HQ, which I have set up and
> experimented with. Now we are thinking about purchasing it, but we have
> reached a problem. Our current employee who adds items to the RMS database
> was not trained to use HQ, as I was just experimenting with it. Because of
> this, the employee added the new items to the SO database instead of using HQ
> and worksheets. Is there any way to have the new items from the store
> database uploaded to the HQ database?

Posted by ISSAM on August 3, 2008, 5:16 am
Please log in for more thread options
If you interested, I will send you SQL script that will insert all the from
the SO to the HQ
I faced this problem with one of my customers, and they are running the
system now with 6 branches and HQ with no problems @ all…
Just email me,
issamfe@hotmail.com


"Cribstoteens" wrote:

> Our store has been using an evaluation of HQ, which I have set up and
> experimented with. Now we are thinking about purchasing it, but we have
> reached a problem. Our current employee who adds items to the RMS database
> was not trained to use HQ, as I was just experimenting with it. Because of
> this, the employee added the new items to the SO database instead of using HQ
> and worksheets. Is there any way to have the new items from the store
> database uploaded to the HQ database?

Posted by genepacii on September 13, 2008, 7:01 am
Please log in for more thread options


ISSAM

I have been running RMS for one store and am now adding another store and
HQ. I am looking for a solution to use items from my current store to
populate my items in the 2nd store. It sounds like your SQL script may do
this. I am also new to HQ. Is it possible to connect the 1st store to HQ
and then populate the items in the 2nd store through HQ?

Genepacii

"ISSAM" wrote:

> If you interested, I will send you SQL script that will insert all the from
> the SO to the HQ
> I faced this problem with one of my customers, and they are running the
> system now with 6 branches and HQ with no problems @ all…
> Just email me,
> issamfe@hotmail.com
>
>
> "Cribstoteens" wrote:
>
> > Our store has been using an evaluation of HQ, which I have set up and
> > experimented with. Now we are thinking about purchasing it, but we have
> > reached a problem. Our current employee who adds items to the RMS database
> > was not trained to use HQ, as I was just experimenting with it. Because of
> > this, the employee added the new items to the SO database instead of using
HQ
> > and worksheets. Is there any way to have the new items from the store
> > database uploaded to the HQ database?

Posted by ISSAM on September 13, 2008, 3:16 pm
Please log in for more thread options


Hi genepacii
i dont think you will need my scripts.
simply.
in case you had already Import the SO Data to the HQ you can use the
worksheet 260 to donwload the Data to ur store,
else,
using the HQ administrator , Database menu, Import Store Opration Data,
then you can donwload the Data to you stores using the worksheet 260
good luck


"genepacii" wrote:

> ISSAM
>
> I have been running RMS for one store and am now adding another store and
> HQ. I am looking for a solution to use items from my current store to
> populate my items in the 2nd store. It sounds like your SQL script may do
> this. I am also new to HQ. Is it possible to connect the 1st store to HQ
> and then populate the items in the 2nd store through HQ?
>
> Genepacii
>
> "ISSAM" wrote:
>
> > If you interested, I will send you SQL script that will insert all the from
> > the SO to the HQ
> > I faced this problem with one of my customers, and they are running the
> > system now with 6 branches and HQ with no problems @ all…
> > Just email me,
> > issamfe@hotmail.com
> >
> >
> > "Cribstoteens" wrote:
> >
> > > Our store has been using an evaluation of HQ, which I have set up and
> > > experimented with. Now we are thinking about purchasing it, but we have
> > > reached a problem. Our current employee who adds items to the RMS database
> > > was not trained to use HQ, as I was just experimenting with it. Because of
> > > this, the employee added the new items to the SO database instead of using
HQ
> > > and worksheets. Is there any way to have the new items from the store
> > > database uploaded to the HQ database?

Similar ThreadsPosted
scanned items from register adds items to inventory transfer scree December 19, 2007, 2:19 pm
V1.3 converting inventory Items from Non-Inventory to Standard January 24, 2006, 2:17 pm
Non-inventory Items / Weight Items April 22, 2008, 10:40 am
Non-Inventory Items August 28, 2006, 8:33 pm
non-inventory items November 18, 2008, 3:52 pm
Link Inventory Items January 6, 2008, 4:32 pm
Pysical Inventory of Serialized items September 4, 2006, 11:30 pm
BUG? Physical Inventory & Serialized Items January 10, 2007, 5:28 pm
Inventory Values Copied from Old into New Items October 13, 2008, 4:46 am
Items / Inventory By Sypplier Report Problems June 19, 2007, 1:11 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