The MBR's Expire Date.
> Does it only consolidate calls for accounts that have a FULL month
> of calls?
Yes. 2.1 had a bug where it would consolidate some billing cycles
even if they were not complete. 2.2 correctly only consolidates
COMPLETED billing cycles.
> i.e.
> User A has a monthly date that lies on the 10th of the month. I do
> consolidation on the 9th of the month. Does A not get consolidated because
> the date is not > the 10th or does it consolidate what it knows now and
> then tack on the rest during a later consolidation, say on the 16th?
It will not consolidate it until after the 10th.
> What happens to usernames that don't exist as services? I have a few
> users who are not in emerald yet. (for reasons I don't want to get into
> here...) Does the consolidation routine delete them because they're not
> found or does it just skip over them? I would like it to skip over them
> so that when I consolidate AFTER I've added them into emerald and a
> consolidation will then tally up their totals.
It skips over them. I have a report that you can run to see them.
The new DB manager will allow you to clear out old entries, also.
> Is it ok to delete AcctStatusType=1 or will that mess up the consolidation
> routine? I would eventually like to add a trigger to blow those
> records away automatically.
Deleting those are fine. The consolidation will delete all records for
the
user (whether start or stop) for the completed billing cycles.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com