|
Posted by Tech1117 on October 4, 2009, 9:49 am
Please log in for more thread options
Thanks Jeff!
I will definitely back up first! So if I do this at each store and then run
my 401, this should sync all my stores with all of my customers? (I'm sure
there will be multiples of the same customer somewhere)
The reason I'm curious is that I think I found a way around the
layaway-commission issue that has been the bane of my rms installation for a
while. Does purchase information follow the customer to each store? example...
+ Joe Customer buys a watch with the credit on his house account...
+ Put's down 25% of it in cash...agrees that he won't get the item until the
whole cost is received.
+ comes back the next day and has his account brought up to pay on his
credit again
+ Can Joe customer go to any store to pay on his account? Will all of his
transactions follow him as he is a global customer?
I know it might seem a little convoluted but layaways don't follow the
customer, but I think customer information does I just want to know how much
of it follows him... and I don't really want to do too much on their live
system. I hope this makes sense! Thanks.
"Jeff @ Check Point Software" wrote:
> Tech,
>
> Backup First!!!
>
> Change to Global customer - these commands will change all customers to a
> global customer
>
> SO Admin | File | Connect | enter the SQL password | Query | New | type
> "UPDATE Customer SET GlobalCustomer = 1" without the quotes and press
> <Enter> | close the query and do not save | exit SO Admin
>
>
>
> Set House Account - these commands will change all customers to the same
> account type
>
> SO Admin | File | Connect | enter the SQL password | Query | New | type
> "AccountType" without the quotes and press <Enter> | note the ID of the
> account type you want to use | close the query and do not save
>
> Query | New | type "UPDATE Customer SET AccountTypeID = x" without the
> quotes and press <Enter> where x is the ID from the earlier Account Type
> query | close the query and do not save | exit SO Admin
>
>
> Backup First!!!
>
>
> --
>
> 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
> =====================================================
>
>
> I have a multistore client that I need to turn all their customers (in
> each
> store) into global customers. I also have to attached the new "House
> Account"
> account type to each of them in order to start doing store credits for
> them.
> Is there a way that I can accomplish this? Or will I need to change each
> one
> individually thru SQL as the account type field is greyed out when I go
> to
> customer info. Thanks!
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap