Right now you help delete all the invoices. That is where we are. Now
when we create an invoice, a balance still exist. Any help in zeroing the
balance would be helpful. I tried the script and it did not work in
adjusting balance.
Kelly Wright (kwright@buz.net)
BuzNet Communications (www.buz.net)
972-644-0440
----------
> From: Dale E. Reed Jr. <daler@comtch.iea.com>
> To: emerald@emerald.iea.com
> Subject: Re: Need Help
> Date: Friday, March 14, 1997 12:14 PM
>
> On Fri, 14 Mar 1997, Kelly Wright wrote:
>
> > Need help adjusting balances so we can clean up our accounting. Any
ideas
> > would help. I am in the process of re-creating our invoices and need
> > someway to adjust the balances in SQL db.
> >
> > Is there a script that someone knows about that could help us out.
Thanks.
>
> Its a field called Balance in the Master Accounts table.
> I guess I don't know what you want to do? It you just want
> to clear them, you could use:
>
> Update MasterAccounts Set Balance=0
>
>
> Dale
>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com