[Emerald] Strange things with consolidation.

Billy Huddleston ( (no email) )
Mon, 1 Feb 1999 18:32:37 -0500

Dale, Just ran consolidation and got some STRANGE things going on.
First, I had It bombed on me the first two times because my log database as
too small.. Encreased it to 25 megs. (Then restored my database from a
backup) Then ran consolidation again without problems.
I followed the steps, Updated the Calls Table, Ran the summry, then the
consolidation, then ran invoices.

Now, Invoices are showing some strange things..
1) When running invoices I would get this error.
DBLibrary: 10011 Column number out of Range.
I would get 2 per invoice. (Does the during Auto-Batch/Manual Batch too)
2) When I look at a invoice.. It has 2 line items, both are identical and
the total
amount ends up being DOUBLE what it should be.
3) The dates on the invoices doesn't makes sense, I ran the colsidation for
the first month,
but the invoice gives me a date of 2/24/99. Is that right??
4) Doesn't apear to be calculating tax in the line items for over charges.
5) I'm not sure that it's picking up everyone. I've came across serval
people who don't have
anything in the history tab whom I know have been online.
6) Once again, Auto-Batch doesn't seam to work correctly, seams to skip over
people who have ANY history in there records.

I'm running Emerald 2.25.336

Thanks, Billy

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html