After seeing your post, I went back and looked at debug, the SQL query was TRUE,
and it now worked.
Don't know why it didn't work earlier though...
Jeff Cummings
Fox Communications
On Monday, February 16, 1998 5:53 PM, John Lange [SMTP:radadmin@palacenet.net] wrote:
> HI
>
> Emerald 2.2.38
>
> This problem just reared it's ugly little head.
>
> We have about 10 out of 1000 customers that we cannot do an "Invoice Next
> Term". Emerald also did "NOT" create an invoice for these customers at the
> begining of the month.
>
> Now "OF COURSE" these customers are calling & complaining that they didn't
> get a bill - "Why are we cut off".
>
> We run a nightly checkdb in SQL Tasks. And I ran Dale's checkdb script
> Saturday.
>
> We can still NOT do an invoice next term, it says "NO Invoices To Create".
> Paid thru, Expire, etc are all set to 2/15/98. We should be able to do this.
>
> In the past when we got one of these, we had to delete the account &
> re-create them.
>
> HELP
> JOhn :}
>
>
> John C. Lange, Sr. PALACE dot NET, INC.
> microjl@palacenet.net MICRO-TECH Computers, Inc.
> 608.742.1601 & 6980 2800 New Pinery Road
> http://www.palacenet.net/ Portage, WI 53901
> Visit our online store @ http://www.microt.com/
> Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
>
> --- __o
> --- _-\<,_ Fastest Service in Town
> --- (_)/ (_)
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>