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,
Severity=16.
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.
Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet<>Fidonet needs
<>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailer
voice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930
http://www.aquarius.com.au <> mailto:sales@aquarius.com.au