Home Page link  

Update HQ from SO

  
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
Update HQ from SO dwtalso 05-11-2007
Posted by dwtalso on May 11, 2007, 3:43 pm
Please log in for more thread options
 I know this question has been asked before, however, I just wanted to float
it one more time before I ramp up my development efforts.

Currently, the HQ/SO model does not support adding new items at the SO level
such that those new items propogate to HQ and then on to other stores. The
model requires all new items to be added to HQ first and then pushed to the
stores.

At the moment my client heavily uses MC50 handhelds and a software package
that connects only to an SO database. They receive all of their product in
their stores and add new items immediately through the handhelds. It is an
incredibly efficient process for them.

I need to integrate them into the HQ environment and, at the moment, that
will require me to break their process. Now items will have to be set aside
or noted and it will be someone's job to collect that information and enter
it into the HQ DB. Probably, I will have to put extra hardware, that's not
handheld-based, in their environment and require them to input new items only
at those locations.

This is not satisfactory to my current client. It's not satisfactory to me
either.

So, one last time (for me at least :) ), is there any existing product that
fixes this hole in RMS? Retail Realm does have a product that's close, but it
is not handheld based so that one is out. Are there any others?

If there's nothing, then I've got to get started writing the code :).

Posted by cod on May 12, 2007, 5:13 am
Please log in for more thread options
 dwtalso wrote:
> If there's nothing, then I've got to get started writing the code :).
If you want help :) I'm available .. but it's possible to put items into
HQ from SO through trigger, table sync and TSQL queries .. it's not
impossible but not easy (because you need to create the item on HQ
before item movements in database store ...)

cod

Posted by dwtalso on May 12, 2007, 5:39 pm
Please log in for more thread options

Thanks, I'll let you know if I need help. I might :).

I thought of using triggers. I'm more inclined right now to create a service
or a scheduled task to keep the overhead on the server at a minimum and also
to keep my fingers out of the database in case future updates modify it.

The setup I'm working with has the SO and HQ db's on dedicated back office
servers, separate from the registers, so I've got plenty of power to run a
background operation occasionally. And the inter-store network is VPN-based
so I'm not worried about a robust client-server scheme that HQ Client/Server
uses.

Anyway, we'll see how it goes :).

"cod" wrote:

> dwtalso wrote:
> > If there's nothing, then I've got to get started writing the code :).
> If you want help :) I'm available .. but it's possible to put items into
> HQ from SO through trigger, table sync and TSQL queries .. it's not
> impossible but not easy (because you need to create the item on HQ
> before item movements in database store ...)
>
> cod
>

Posted by Afshin Alikhani on May 12, 2007, 2:25 pm
Please log in for more thread options
We have an application (not using triggers that slows the system) that
allows you to create items. It connects from store direct to HQ and 1st
creates the Items at HQ brings their HQID to Store and creates them atthat
store. Also it allows you to create a Worksheet 250 automatically to send
that item to other stores. This is Item Creation which is part of the
Fashion Bundle (though not necessarily just fashion items). If you have
more questions contact me.

Afshin Alikhani - [ afshin@retailrealm.co.uk ]
CEO - Retail Realm
= = = = = = = = = =

>I know this question has been asked before, however, I just wanted to float
> it one more time before I ramp up my development efforts.
>
> Currently, the HQ/SO model does not support adding new items at the SO
> level
> such that those new items propogate to HQ and then on to other stores. The
> model requires all new items to be added to HQ first and then pushed to
> the
> stores.
>
> At the moment my client heavily uses MC50 handhelds and a software package
> that connects only to an SO database. They receive all of their product in
> their stores and add new items immediately through the handhelds. It is an
> incredibly efficient process for them.
>
> I need to integrate them into the HQ environment and, at the moment, that
> will require me to break their process. Now items will have to be set
> aside
> or noted and it will be someone's job to collect that information and
> enter
> it into the HQ DB. Probably, I will have to put extra hardware, that's not
> handheld-based, in their environment and require them to input new items
> only
> at those locations.
>
> This is not satisfactory to my current client. It's not satisfactory to me
> either.
>
> So, one last time (for me at least :) ), is there any existing product
> that
> fixes this hole in RMS? Retail Realm does have a product that's close, but
> it
> is not handheld based so that one is out. Are there any others?
>
> If there's nothing, then I've got to get started writing the code :).


Posted by dwtalso on May 12, 2007, 5:26 pm
Please log in for more thread options
Afshin,

I'm aware of that application. However, I spoke with someone from Retail
Realm yesterday and it will not support using handheld hardware. Right now I
would rather give my client a solution that continues to support the use of
those devices.

Thanks for the reply, though :)

Dan

"Afshin Alikhani" wrote:

> We have an application (not using triggers that slows the system) that
> allows you to create items. It connects from store direct to HQ and 1st
> creates the Items at HQ brings their HQID to Store and creates them atthat
> store. Also it allows you to create a Worksheet 250 automatically to send
> that item to other stores. This is Item Creation which is part of the
> Fashion Bundle (though not necessarily just fashion items). If you have
> more questions contact me.
>
> Afshin Alikhani - [ afshin@retailrealm.co.uk ]
> CEO - Retail Realm
> = = = = = = = = = =
>
> >I know this question has been asked before, however, I just wanted to float
> > it one more time before I ramp up my development efforts.
> >
> > Currently, the HQ/SO model does not support adding new items at the SO
> > level
> > such that those new items propogate to HQ and then on to other stores. The
> > model requires all new items to be added to HQ first and then pushed to
> > the
> > stores.
> >
> > At the moment my client heavily uses MC50 handhelds and a software package
> > that connects only to an SO database. They receive all of their product in
> > their stores and add new items immediately through the handhelds. It is an
> > incredibly efficient process for them.
> >
> > I need to integrate them into the HQ environment and, at the moment, that
> > will require me to break their process. Now items will have to be set
> > aside
> > or noted and it will be someone's job to collect that information and
> > enter
> > it into the HQ DB. Probably, I will have to put extra hardware, that's not
> > handheld-based, in their environment and require them to input new items
> > only
> > at those locations.
> >
> > This is not satisfactory to my current client. It's not satisfactory to me
> > either.
> >
> > So, one last time (for me at least :) ), is there any existing product
> > that
> > fixes this hole in RMS? Retail Realm does have a product that's close, but
> > it
> > is not handheld based so that one is out. Are there any others?
> >
> > If there's nothing, then I've got to get started writing the code :).
>

Similar ThreadsPosted
Update September 21, 2005, 5:54 pm
update from 1.2 to 1.3 August 11, 2006, 12:51 am
Need update January 13, 2007, 7:47 pm
what is the last RMS update? and where can I get it? April 17, 2007, 1:46 pm
Worksheet 303 MPQ Update @ HQ June 27, 2005, 10:18 am
Inventory Update March 8, 2006, 1:31 am
Update Quantity to ZERO April 8, 2006, 6:59 am
Inventory Update May 30, 2006, 3:36 pm
Problems after update August 16, 2006, 9:11 am
automatic update for add-ins November 20, 2006, 9:50 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