Warning: iconv_mime_decode() [function.iconv-mime-decode]: Malformed string in /home/rockryno/public_html/lib/standard.lib.php on line 2258
Same Database two different locations.
Home Page link  

Same Database two different locations.

  
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
Same Database two different locations. Steven @ S&S Ti 06-30-2008
Posted by Steven @ S&S Ti on June 30, 2008, 7:34 pm
Please log in for more thread options
 Anyone know of a way to say have a brick and mortar store with one database
and two POS stations on RMS 2.0 and a third mobile laptop with internet
access using the same database as the store with the same inventory and
customers.
Example: Some calls for a service call and you load up two items for the
call. Go fix the problem with the two items, then while out in the field you
use the laptop to write up and process the order with either an in house
account or you take a credit card, check or cash in the field with internet
and using the same database as the store's without using HQ. The service
truck doesn't keep it's own inventory so I don't need a database on its own.
And can we use an Ingenico i6550 on the road over the internet to accept
credit cards?
Thanks for you time and thoughts.
Steve
--
Steve

Posted by JerryData on July 1, 2008, 5:15 pm
Please log in for more thread options
 Jeff, Steven can accomplist both by setting up his laptop with RMS and
setting his server as his outside IP (Fixed one is recommended!), and opening
port 1433 in his router and pointing it to the server.
And don't forget to password the datase!!!
--
-Jerry
JR Data Inc.


"Jeff @ Check Point Software" wrote:

> Steve,
>
> Go for it, but your issue will be the wireless connection. Look into using a
cellular connection. The 6550 will work too.
>
> --
>
> Jeff
> Check Point Software
>
> Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)
> =====================================================
>
> You must be using Outlook Express/Windows Mail or some other type of newsgroup
reader to
> see and download the file attachment(s). If you are not using a reader, follow
> the link below to setup Outlook Express. Click on "Open with newsreader"
> under the MS Retail Management System on the right.
>
> http://tinyurl.com/75bgz
> =====================================================
>
>
> Anyone know of a way to say have a brick and mortar store with one database
> and two POS stations on RMS 2.0 and a third mobile laptop with internet
> access using the same database as the store with the same inventory and
> customers.
> Example: Some calls for a service call and you load up two items for the
> call. Go fix the problem with the two items, then while out in the field you
> use the laptop to write up and process the order with either an in house
> account or you take a credit card, check or cash in the field with internet
> and using the same database as the store's without using HQ. The service
> truck doesn't keep it's own inventory so I don't need a database on its own.
> And can we use an Ingenico i6550 on the road over the internet to accept
> credit cards?
> Thanks for you time and thoughts.
> Steve
> --
> Steve

Posted by Michael on July 2, 2008, 4:38 am
Please log in for more thread options
Don't open up your SQL Server to the outside world.

Setup a VPN and then connect to your SQL Server.


--
Disclaimer:

Always test any queries that modify data on a test database prior to running
on your live data to ensure the desired results.

Always back-up prior to running any SQL delete queries on your live data.

--

Regards
Michael
(Brisbane, Australia)

> Jeff, Steven can accomplist both by setting up his laptop with RMS and
> setting his server as his outside IP (Fixed one is recommended!), and
> opening
> port 1433 in his router and pointing it to the server.
> And don't forget to password the datase!!!
> --
> -Jerry
> JR Data Inc.
>
>
> "Jeff @ Check Point Software" wrote:
>
>> Steve,
>>
>> Go for it, but your issue will be the wireless connection. Look into
>> using a cellular connection. The 6550 will work too.
>>
>> --
>>
>> Jeff
>> Check Point Software
>>
>> Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)
>> =====================================================
>>
>> You must be using Outlook Express/Windows Mail or some other type of
>> newsgroup reader to
>> see and download the file attachment(s). If you are not using a reader,
>> follow
>> the link below to setup Outlook Express. Click on "Open with newsreader"
>> under the MS Retail Management System on the right.
>>
>> http://tinyurl.com/75bgz
>> =====================================================
>>
>>
>> "Steven @ S&S Tire Service"
>> Anyone know of a way to say have a brick and mortar store with one
>> database
>> and two POS stations on RMS 2.0 and a third mobile laptop with
>> internet
>> access using the same database as the store with the same inventory and
>> customers.
>> Example: Some calls for a service call and you load up two items for
>> the
>> call. Go fix the problem with the two items, then while out in the
>> field you
>> use the laptop to write up and process the order with either an in
>> house
>> account or you take a credit card, check or cash in the field with
>> internet
>> and using the same database as the store's without using HQ. The
>> service
>> truck doesn't keep it's own inventory so I don't need a database on its
>> own.
>> And can we use an Ingenico i6550 on the road over the internet to
>> accept
>> credit cards?
>> Thanks for you time and thoughts.
>> Steve
>> --
>> Steve



Posted by Gaz on July 3, 2008, 4:45 am
Please log in for more thread options
I would agree with Michael in using a VPN

If you wanted something even simpler, just use logmein on the laptop and
take control of one of the POS in store for a the few mins it takes to
process the sale

"Michael" wrote:

> Don't open up your SQL Server to the outside world.
>
> Setup a VPN and then connect to your SQL Server.
>
>
> --
> Disclaimer:
>
> Always test any queries that modify data on a test database prior to running
> on your live data to ensure the desired results.
>
> Always back-up prior to running any SQL delete queries on your live data.
>
> --
>
> Regards
> Michael
> (Brisbane, Australia)
>
> > Jeff, Steven can accomplist both by setting up his laptop with RMS and
> > setting his server as his outside IP (Fixed one is recommended!), and
> > opening
> > port 1433 in his router and pointing it to the server.
> > And don't forget to password the datase!!!
> > --
> > -Jerry
> > JR Data Inc.
> >
> >
> > "Jeff @ Check Point Software" wrote:
> >
> >> Steve,
> >>
> >> Go for it, but your issue will be the wireless connection. Look into
> >> using a cellular connection. The 6550 will work too.
> >>
> >> --
> >>
> >> Jeff
> >> Check Point Software
> >>
> >> Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)
> >> =====================================================
> >>
> >> You must be using Outlook Express/Windows Mail or some other type of
> >> newsgroup reader to
> >> see and download the file attachment(s). If you are not using a reader,
> >> follow
> >> the link below to setup Outlook Express. Click on "Open with newsreader"
> >> under the MS Retail Management System on the right.
> >>
> >> http://tinyurl.com/75bgz
> >> =====================================================
> >>
> >>
> >> "Steven @ S&S Tire Service"
> >> Anyone know of a way to say have a brick and mortar store with one
> >> database
> >> and two POS stations on RMS 2.0 and a third mobile laptop with
> >> internet
> >> access using the same database as the store with the same inventory and
> >> customers.
> >> Example: Some calls for a service call and you load up two items for
> >> the
> >> call. Go fix the problem with the two items, then while out in the
> >> field you
> >> use the laptop to write up and process the order with either an in
> >> house
> >> account or you take a credit card, check or cash in the field with
> >> internet
> >> and using the same database as the store's without using HQ. The
> >> service
> >> truck doesn't keep it's own inventory so I don't need a database on its
> >> own.
> >> And can we use an Ingenico i6550 on the road over the internet to
> >> accept
> >> credit cards?
> >> Thanks for you time and thoughts.
> >> Steve
> >> --
> >> Steve
>
>
>

Similar ThreadsPosted
bin locations December 27, 2005, 2:44 pm
300 Locations+ using RMS? November 22, 2006, 1:41 pm
Updating Bin Locations October 10, 2005, 1:26 pm
multiple RMS locations June 19, 2006, 3:05 pm
Multiple Bin Locations August 22, 2006, 10:13 am
allow multiple bin locations for items December 16, 2006, 8:14 pm
The Bin locations should NOT be overwritten by a 250 worksheet!!! September 26, 2007, 1:38 pm
Bin Locations and notes being overwritten by HQ February 13, 2008, 4:50 am
2 warehouse locations with store ops 1.3 April 10, 2008, 3:00 pm
Best way to connect two locations with Microsoft POS August 12, 2008, 9:55 am

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