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