UPDATE MasterAccounts
SET CreditCardExpire = replace(CreditCardExpire, '/', '')
WHERE CreditCardExpire LIKE '%/%'
AND datalength(CreditCardExpire) BETWEEN 3 AND 6
UPDATE MasterAccounts
SET CreditCardExpire = replace(CreditCardExpire, '-', '')
WHERE CreditCardExpire LIKE '%-%'
AND datalength(CreditCardExpire) BETWEEN 3 AND 6
UPDATE MasterAccounts
SET CreditCardExpire = '0' + CreditCardExpire
WHERE datalength(CreditCardExpire) = 3
----- Original Message -----
From: "Kenneth Gustav Eitenmiller Jr" <keitenmiller@hughestech.net>
To: <emerald@iea-software.com>
Sent: Thursday, September 07, 2000 11:14 AM
Subject: RE: [Emerald] batch error/problems
> After doing these manually... I have found that the mba's that the batch
> process was locking up on Had Not EVER Been Invoiced Before... and they
all
> had some sort of pro-rate charge that needed to be added...
> All of my credit card expirtation dates are entered mm/yy, as are those
that
> were locking up...
>
> Josh, how do I get a copy of the script?
>
> Thanks,
> Ken
> keitenmiller@hughestech.net
>
> -----Original Message-----
> From: Josh Hillman [mailto:admin-maillist@talstar.com]
> Sent: Thursday, September 07, 2000 09:45
> To: emerald@iea-software.com
> Subject: Re: [Emerald] batch error/problems
>
>
> We ran into a problem similar to this also. If I remember correctly, the
> problem was a mal-formatted credit card number in the MasterAccounts
table.
> I think the credit card number contained a carriage return, then two
digits
> after it (someone messed up when entering in the number). In another
case,
> there may have been something weird with the formatting of the expiration
> date.
>
> After fixing these anomolies, everything was fine.
> I try to "enforce" credit card number be entered in with nothing but the
> numbers and the expiration date in the form MMYY with nothing else. I
even
> wrote a script that runs nightly that fixes credit card expiration date
> formatting to force it to MMYY if it was entered in like MM/YY, MYY, M/YY.
>
> Josh
>
> ----- Original Message -----
> From: "Stephen Woodfin" <swoodfin@gogisco.net>
> To: <emerald@iea-software.com>
> Sent: Thursday, September 07, 2000 10:24 AM
> Subject: RE: [Emerald] batch error/problems
>
>
> > We are having the same problem. It seems to happen only on accounts
that
> > have a charge or credit created for them. It would be nice to find out
> what
> > is causing this. Other then every one it stops on having a credit or
> > charge created in the account I cannot find another similarity as to why
> it
> > is stopping.
> >
> > To fix it so that you can bill, go to the master account that it stops
on
> > after exiting Emerald and invoice next term manually and it seems to
work
> > fine.
> >
> > This has become a real problem for us too, as billing is now taking
> several
> > hours to complete.
> >
> > -----Original Message-----
> > From: keitenmiller@hughestech.net [mailto:keitenmiller@hughestech.net]
> > Sent: Thursday, September 07, 2000 10:10 AM
> > To: 'emerald@iea-software.com'
> > Subject: [Emerald] batch error/problems
> >
> >
> > I have a new problem...
> >
> > Running Emerald 2.5.337
> >
> > Batch
> > Credit Card
> > 08/29/2000
> > -Create
> > Invoice 8 services - OK
> > Writing 2 of 8 (1454)
> >
> > IT freezes there... How do I hunt this down? can i do some sort of query
> to
> > (1454) to find the master account?
> > I really need to bill...
> >
> > Thanks,
> > Ken
> > keitenmiller@hughestech.net
> >
> >
> > Stephen Woodfin
> > Director of Software Development
> > GiSCO
> > swoodfin@gogisco.net
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
> >
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart