change local customer to global customer

Had the same issue ... this worked for me - need to set globalcustomer = 1; need to set lastupdated = getdate(*); need to set storeid = 'xxxx' (whatever is appropriate for you). Go into SO Manager and configure ENABLE GLOBAL CUSTOMERS and NEW CUSTOMERS DEFAULT AS GLOBAL. Need to run 401 TWICE (once to upload customer records from stores to HQ and again (minutes later) to download customer records from HQ to each of the other stores.

H> I am trying to change the local customers that i have in my store database to

Thanks for your reply, I am not a sql guy I did run the sql UPDATE Customer SET GlobalCustomer = 1 can you give me the exact sql staement that i have to run i want to update all of my customers in my database i started using rms in 05-2005

thank you Victor

"Lum> Had the same issue ... this worked for me - need to set globalcustomer = 1;