Emerald Admin: Billing Cycles

Glen Harvy ( glen@aquarius.com.au )
Mon, 17 Aug 1998 11:43:18 +1000

Hi Dale,

By way of background, I charge my customers on the 15th Monthly and have
done so for years. If someone joins up in between dates then I make an
appropriate adjustment to their hours and/or charge.

I thought I had everything properly configured however when I ran call
consolidation, all the call details prior to August 1st was deleted from
the CALLS table.

I presume that I didn't setup Emerald properly in that the billing cycle
should have been "anniversary" rather than "monthly" (I got that
information from the Database Schema). On trying to check this, when I try
to click on the tab I get:

SQL Server Error: 208 Invalid object name 'BillingCycles' State=1,

As the documentation for 2.1 doesn't even show this tab/option, I presume
it's yet to be implemented.

The problem I now have is that the call data from 15th July to 1st August
has "disappeared"! Is there anyway I can get extract this data?

Compounding the problem I have is that I allow my callers to access the
CALLS table so they can monitor their time usage. I realise this table is
cleared when ever a Call Consolidation takes place - it was for that reason
I only intended on running Call Consolidation on the 15th of the month.

The documentation infers that a users call data is saved in the users own
database. Is this correct? If it is, I could run Call Consolidation daily
and allow my users access to their own database.

I presume that by changing the "Billing Cycle" (when I can change it) as
above then I will be able to continue with my practice of 15th monthly.

AQUARIUS Communications for all your Internet<>Fidonet needs
<>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailer
http://www.aquarius.com.au <> mailto:sales@aquarius.com.au