Centrally manage Cashiers and Sales Reps

Anyone know the best way to centrally manage cashiers and sales reps from HQ? We have a bunch of stores and HQ and need a way to handle all cashier setup
and sales reps setup.
Thanks,
Bradley
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
How are your stores connected?
I have four stores and we use a VPN to connect the stores to HQ. Iam lucky in that all of my locations are served by the same cable company, so my traffic never really hits 'the internet' - it stays on the cable providers' network at all times. My response time for a ping is rarely over 70ms from the furthest store.
I am able to connect to any store database from the HQ location and rarely do I have any issues when I do.
This is what the folks at MS would call an 'unsupported configuration'. It would be useless for any sort of extended use and it is slower by far than connecting to a database on your LAN.
I only use it for occassions just like you've described, but it does work.
Tom
--
Stop fishing for e-mail


"Bradley" wrote:
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Hi Tom,
We have Point-to-Point private circuits to each store. The issue is we have employee turnover and employees move between stores often. We need a way to easily create and remove cashiers and sales reps at all stores.
Thank you,
Bradley
"Terrible Tom" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
With a dedicated WAN like that, you should be able to reconfigure Store Operations to connect to the server at whichever store you need to connect. I have a batch file (found the idea on the Google archive of this group) that asks me which database I want to connect to then launches SO Manager for that store.
I had to manually configure my system for each store, export the SO Admin Config registry key, then use the batch file to select the registry key for you.
You'll probably want to use IP addresses instead of names for the server name.
Tom
--
Stop fishing for e-mail


"Bradley" wrote:
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Try Retail Realm's Global Cashiers and Global Sales Reps add-ins. These programs are included in their Miscellaneous Utilities for HQ. http://www.retailrealm.co.uk/RRSite/Default.aspx?tabids
Greg Digital Retail Solutions www.digitalretailer.com

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
I don't know if this is the best way...but..I do normally manage my cashiers thru a query... and pass it to a worksheet Style 51...
here's how to add a cashier to all stores you desire.... ------------------------------------------------------------------------------------------ INSERT INTO [Cashier]([HQID], [LastUpdated], [Number], [StoreID], [Name], [Password], [FloorLimit], [ReturnLimit],[CashDrawerNumber], [SecurityLevel], [Privileges]) Select 0, '11-12-2006', 'ME', StoreID,'MYSELF','IRENE',0, 0, 0, 3, 5140382 from Configuration ------------------------------------------------------------------------------------------ Note: this query is with security activated options. There are some fields /options in Store that I have hide / prevent cashiers from modifying or viewing it.
------ Now, if you want to remove the cashier...You don't have to delete those codes because past transactions are using those cashier codes . What I suggest is to run another query to change the passowrd and update the security level, in a way that even the old cashier even if they know the password would not be able to gain access to the system.
1) update cashier set privileges=0 where number='7' and password='taty123'
2)update cashier set password='invalid' where number='7' and password='taty123'
Just try to ponder on it and see if it helps.
"Bradley" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.