Is there a way to globally increase customer credit limits by a set $ amount for all customers.
- posted
18 years ago
Is there a way to globally increase customer credit limits by a set $ amount for all customers.
Yes, Go to Administrator, connect to the database, backup the database (always do it first !), go to the Query window and type in there:
UPDATE Customer SET CreditLimit=CreditLimit+300
and then press the big green arrow and wait for result
'300' here is just an example. This command will increase each customer's credit limit by $300. Change the number in the command as you wish. If you wish give all customers, say, flat $500 credit limit, change the command as the following:
UPDATE Customer SET CreditLimitP0
I hope it helps
"RyanMatk> Is there a way to globally increase customer credit limits by a set $ amount
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.