Credit Limits

Is there a way to globally increase customer credit limits by a set $ amount for all customers.

Reply to
RyanMatkin
Loading thread data ...

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

Reply to
RetailHero(tm)

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.