Set Customer Balance equal zero monthly

Let me know since they are not going to apy their A/R what you realy want to do is run an adjustment at the end of each month with right reason code to wrie off that months charge this automatically resetting the account balances to the credit limit of 500. This is a small program rather than sql statement. Drop me an email to discuss this please.

Afshin, Thank you for the offer of a custom program, but my client isn't interested right now.

I need more ideas > Let me know since they are not going to apy their A/R what you realy want to

I think you need to explain what you want to do with the amount that is being zeroed out.

Do you want this to show up on the statement or to just disappear and not balance to anything?

Yes. We want the current balance to disappear. We can always run reports to find out what has been purchased, which is then deducted from the inmates "bank account". They have to have paid the monies in advance in order to buy anything in the store and that money is tracked outside of Store Operations.

The need to give them a credit limit in RMS is that the amount they can purchase is limited each month. If you behave badly, they lower the credit limit. It's an interesting situation.

Thank you for any assistance.

"Michael" wrote:

From Administrator, you can run the following query:

UPDATE Customer SET AccountBalance = 0

This will zero all customer account balances *on the Customer table only*. This won't update A/R, and if you try to run statements (Close Billing Cycle) you WILL get errors. Since you're not dealing with real money, you're probably a lot more tolerant of accounting errors than most RMS users.

I would urge you to always back up your database before executing ANY query.

Tom