1. Home
  2. Point-Of-Sale Software
  3. SQL Command Set Customer Type

SQL Command Set Customer Type

I have imported 1400 customers. I did not have a way to import the customer type. All are Open Accounts, Net Due upon Receipt of Invoice. And this is the only account type I have set up. Is there a SQL command to set all customer accounts as Open Accounts. I would prefer not to have to touch all of these accounts and make the change manually. Thanks, for your time and knowledge.

Kinnard L. Kohler Business Machines Systems

6101 South Shackleford Road Little Rock, AR 72204-8606 (T) 501-375-8380 (F) 501-375-0043 (Cell) 501-412-5686
formatting link
Email: snipped-for-privacy@NOSPAMbmsar.com
Reply to
Kinnard
Loading thread data ...

assuming that the ID of your account type is 1 (should be if this is the only account type you've created) then this SQL statement:

UPDATE Customer SET AccountType = 1

will apply this account type to all of your customers. Make sure to back up your database before you run any queries against it that will change the data, so you have a restore point

hth kev> I have imported 1400 customers. I did not have a way to import the customer

Reply to
kskinne

sorry that should be AccountTypeID and not AccountType:

UPDATE Customer SET AccountTypeID = 1

kevin

"ksk> assuming that the ID of your account type is 1 (should be if this is the only

Reply to
kskinne

Kevin, that was the ticket, thank you very much.

K> sorry that should be AccountTypeID and not AccountType:

Reply to
Kinnard

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.