User not known
Your message reads (in part):
Received: from walnut.iea-software.com (unverified [207.53.165.8]) by webserver.netsis.it
(EMWAC SMTPRS 0.83) with SMTP id <B0000169867@webserver.netsis.it>
Tue, 15 Sep 1998 04:37:25 +0200
Received: from walnut.iea-software.com (walnut.iea-software.com [207.53.165.8]) by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id za000593 for <emerald@iea-software.com> Mon, 14 Sep 1998 19:16:29 +0100
Received: from [203.58.25.6] by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id rigaaaaa for <emerald@iea-software.com> Mon, 14 Sep 1998 19:16:24 +0100
Received: from calypso (aquarius.com.au [203.58.25.5])
by triton.aquarius.com.au (2.5 Build 2639 (Berkeley 8.8.6)/8.8.4) with SMTP
id MAA00322 for <emerald@iea-software.com> Tue, 15 Sep 1998 12:21:43 +1000
Message-Id: <3.0.5.32.19980915122142.00a03b00@mail.aquarius.com.au>
X-Sender: root@mail.aquarius.com.au
X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.5 (32)
Date: Tue, 15 Sep 1998 12:21:42 +1000
To: "emerald@iea-software.com" <emerald@iea-software.com>
From: Glen Harvy <glen@aquarius.com.au>
Subject: Accounting periods
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-ListMember: filippo@netsis.it [emerald@iea-software.com]
Hi Dale,
I charge my customers as at the 15th monthly. That is, for the period
starting at 0000 on the 15th and until 2359 on the 14th of the month.
I have my accounts set to expire on 09/15/98 on the Billing cycle in the MBR.
I ran Call Consolidation on the 15th expecting the call data from 08/15/98
to 09/14/98 to be consolidated and placed in the History table. The
previous time I ran Call Consolidation was on 15th August.
To explain my problem and as an example, on 09/14/98, one of our customers
record showed TIME ON from 08/15/98 to 09/15/98 as 53 hours. After Call
Consolidation on 09/15/98, TIME ON was calculated by Emerald for the same
period as 27 hours.
What APPEARS to have happened is the data from the period prior to 08/31/98
has been consolidated. The data from 09/01/98 remains in the Time On section.
When I ran call consolidation I entered 09/15/98 as the Invoice Date.
Examining the Call History for the above example customer, the Start Date
shows 08/15/98 and the time is 45 hours.
Can you explain or elaborate on these two issues:
A. Can the Calls Table be consolidated on the basis that it will always
include the data from the beginning of the current billing cycle to
whenever Call Consolidation is actually ran. Alternately, can the Calls
Table always contain the current billing period's data. This is of some
importance to me as I use SQL queries to enable my users to access details
of all calls for the current period.
I realise that some ISP's call data may be substantial and consolidation
may need to be ran more frequently. I would therefor like to see what I
propose as at least an option.
B. What was the actual time used by my client from 08/15/98 to 09/14/98 in
the example I have used above?
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