[Emerald Digest]

emerald-digest-request@iea-software.com
Fri, 5 Jun 1998 00:00:16 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: Emerald would not issue a Renewal-Invoice"
Next message: Dale E. Reed Jr.: "Re: DNS Management for Emerald?"

Message 1: Re: Emerald would not issue a Renewal-Invoice
from "Mohammed Ersan" <ersan@first.net.jo>

Message 2: Some more minor problems with 2.5.74 (III)
from Robert Boyle <robert@garden.net>

Message 3: Re: list commands
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 4: Re: Automated on-line subscription of new customers
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 5: Re: NAS Cisco , Unix etc..
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 6: Re: client preferences problem - 2.2.38
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 7: RE: Automated on-line subscription of new customers
from "J Dyer" <JDyer@Athene.co.uk>

Message 8: Re: Automated on-line subscription of new customers
from "Ed Miller" <emiller@del.net>

Message 9: Re: NAS Cisco , Unix etc..
from James <daj4@mcmedia.com.au>

Message 10: Re: Emerald would not issue a Renewal-Invoice
from Michael Whisenant <mwhisen@airnet.net>

Message 11: IMail from IPSwitch
from "Chris A. Christopher" <management@labyrinth.net>

Message 12: voiding payment
from "Bill Bongiorno" <bill@systec.com>

Message 13: Re: voiding payment
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 14: RE: voiding payment
from "Bill Bongiorno" <bill@systec.com>

Message 15: Re: IMail from IPSwitch
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 16: Re: voiding payment
from "Josh Hillman" <admin-maillist@talstar.com>

Message 17: Re: NAS Cisco , Unix etc..
from "David Moore" <MOORED@ROMTECH.COM.AU>

Message 18: Re: Emerald won't run today, Take III
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 19: Re: Automated on-line subscription of new customers
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 20: Re: Emerald would not issue a Renewal-Invoice
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 21: Re: Emerald would not issue a Renewal-Invoice
from "Josh Hillman" <admin-maillist@talstar.com>

Message 22: SELECT DISCTINCT ability in Crystal Reports 5?
from "Josh Hillman" <admin-maillist@talstar.com>

Message 23: RE: voiding payment
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 24: DNS Management for Emerald?
from "Peter A. Sang" <pesa@sang.de>

Message 25: Re: SELECT DISCTINCT ability in Crystal Reports 5?
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 26: Re: Emerald would not issue a Renewal-Invoice
from "Dale E. Reed Jr." <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Emerald would not issue a Renewal-Invoice
From: "Mohammed Ersan" <ersan@first.net.jo>
Date: Thu, 04 Jun 1998 09:02:19 +0300

>The typical reason for this is because you moved the expiration

>date of the MBR back, and not have an overlapping billing cycle.

>You must either void the overlapping invoice, or move the expiration

>date to the enddate of the last invoice for it to bill the customer.

>Use the history tab on the MBR, find the last invoice, and check the

>end date. Then compare that to the expire date. The exipre date

>MUST be latter (or equal to) that end date.

the expiration date equals the last invoice end-date and even I've tried to put it one year later but it still wont

issue a renewal for that customer

<center>M. Ersan

ersan@first.net.jo

firstnet

</center>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Some more minor problems with 2.5.74 (III)
From: Robert Boyle <robert@garden.net>
Date: Thu, 04 Jun 1998 03:34:44 -0400

Here's another:

In on-line, The VERY first time you open the window, sorting on minutes
really sorts on port... strange. Click on anything else other than minutes
and then click back to minutes and it works fine. Strange bug, Dale. :)

-Robert

Robert Boyle Server Co-location,
Garden Networks Internet Access,
50 Diller Ave Development & Consulting
Newton, NJ 07860 (973)300-9211 Ext.103
8AM-8PM Mon-Fri EST http://www.garden.net
Lucent RABU & Software.Com Post.Office VAR

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: list commands
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Thu, 04 Jun 1998 01:34:39 -0700

Franco Nogarin wrote:
>
> someone please tell me the email address and the command to get off the
> lists, and dale, they should be clearly marked at the website, most people
> want off a list in a hurry. They are not listed at all there.

If you go to the support section on either the RadiusNT or Emerald
list, the instructions are there (you may need to reload them, if they
were previously cached). unsubscribe just like the subsribed instructions,
expect use unsubscribe (or leave) instead of subscribe (or join).

I did remove you from the lists, also. I typically remove anyone
manually that I see trying to get off the lists.

-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Automated on-line subscription of new customersFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 04 Jun 1998 01:47:10 -0700

Olivier Astier (Echoweb) wrote:> > I am excited by the Emerald features but I am also very interested in an> automated on-line subscription of new customers (as Rodopi does). Does> someone know how to do it with Emerald? Will it be integrated in the version> 2.5 of Emerald?

We have some Cold Fusion sample scripts available, and I helped onecustomer convert them to ASP.

Emerald 3.0 will be a majority web-based and include a user area and a signup server.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: NAS Cisco , Unix etc..From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 04 Jun 1998 01:51:44 -0700

James wrote:> > I have been reading about your product and it looks great but before I get> too enthusiastic can you help me on these few points> > 1. Can I use cisco products as the NAS?

Yes.

> 2. Can I use UNIX radius instead of NT?

Yes, but you loose a lot of functionality and features. RadiusNT is atight integration and core component of Emerald.

> 3. Can another dactuve atabase be merged into the Microsoft sql database> which is used for Emerald?

I'd really need more details of what you are asking here. We offer aconsulting service for database conversion and migration. Many customersconverting from other ISP billing products request us to convert theirdatabase.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: client preferences problem - 2.2.38From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 04 Jun 1998 01:52:22 -0700

Bill Bongiorno wrote:> > When I check and save "Incremental Batch," the selection is not retained.> However, if I select "no time charges" and recall the preferences,> "Incremental Batch" is checked and "no time charges" is not.> > Can I assume that checking "no time charges" is actually activating> "Incremental Batch?" Also, the manual does not explain the purpose of "no> time charges" and "don't verify reports." Please explain these options.

Could be. Go into regedt32 and see what the IncrementalBatch registryoption under the Emerald key is set to. Should be 1 for on, and 0 foroff.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Automated on-line subscription of new customersFrom: "J Dyer" <JDyer@Athene.co.uk>Date: Thu, 4 Jun 1998 10:00:37 +0100

Hi,I am trying to do online signup with asp at the moment, can supply the aspsample version of your scripts ?ThanksJulian DyerAthene Internet

> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.> Sent: Thursday, June 04, 1998 9:47 AM> To: emerald@iea-software.com> Cc: ak> Subject: Re: Automated on-line subscription of new customers>>> Olivier Astier (Echoweb) wrote:> >> > I am excited by the Emerald features but I am also very interested in an> > automated on-line subscription of new customers (as Rodopi does). Does> > someone know how to do it with Emerald? Will it be integrated> in the version> > 2.5 of Emerald?>> We have some Cold Fusion sample scripts available, and I helped one> customer convert them to ASP.>> Emerald 3.0 will be a majority web-based and include a user area> and a signup server.>> --> Dale E. Reed Jr. (daler@iea-software.com)> _________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Automated on-line subscription of new customersFrom: "Ed Miller" <emiller@del.net>Date: Thu, 4 Jun 1998 09:00:56 -0400

Could you reply to the list if you do have some ASP pages. We are tryingthe same thing.

>Hi,>I am trying to do online signup with asp at the moment, can supply the asp>sample version of your scripts ?>Thanks>Julian Dyer>Athene Internet>>>> -----Original Message----->> From: emerald-request@iea-software.com>> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.>> Sent: Thursday, June 04, 1998 9:47 AM>> To: emerald@iea-software.com>> Cc: ak>> Subject: Re: Automated on-line subscription of new customers>>>>>> Olivier Astier (Echoweb) wrote:>> >>> > I am excited by the Emerald features but I am also very interested inan>> > automated on-line subscription of new customers (as Rodopi does). Does>> > someone know how to do it with Emerald? Will it be integrated>> in the version>> > 2.5 of Emerald?>>>> We have some Cold Fusion sample scripts available, and I helped one>> customer convert them to ASP.>>>> Emerald 3.0 will be a majority web-based and include a user area>> and a signup server.>>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: NAS Cisco , Unix etc..From: James <daj4@mcmedia.com.au>Date: Fri, 5 Jun 1998 01:15:26 +1000 (EST)

What support do you offer for Australin customers.Do you have some ISP's here using your product.ThanksDaryl

> I'd really need more details of what you are asking here. We offer a> consulting service for database conversion and migration. Many customers> converting from other ISP billing products request us to convert their> database.> > -- > Dale E. Reed Jr. (daler@iea-software.com)> _________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald would not issue a Renewal-InvoiceFrom: Michael Whisenant <mwhisen@airnet.net>Date: Wed, 03 Jun 1998 17:55:42 -0500

--=====================_457723115==_.ALTContent-Type: text/plain; charset="us-ascii"

As I understand it even if the invoice is paid, and the dates in the masterbilling record are adjusted backwards then until that invoice is voided itWILLnot create another invoice. For example

A invoice is created and paid covering period from 5/1/98 to 6/1/98 You adjust manually the expiration period from 6/1/98 to 5/20/98

It will never create another invoice until the expiration date ismovedahead of 6/1/98 OR the invoice covering that time period is deleted!

At 07:03 PM 6/3/98 +0300, you wrote: >>>>> Does the customer's MBR have the "Active" box checked? >>>> Are there ANY services with the "Active" box checked, associated with the>> MBR? >>>> <<<< > yes > >>>> >>>> ------------ >>>> If the above both answer yes.... >>>> Does this customer have ANY other invoices outstanding? Go to the INVOICES>> tab, put the user's name or login there, and UNCHECK "Unpaid only>> invoices". Click SEARCH. All past invoices for the customer should show>> up. (If they don't, you typed int he login or name incorrectly -- try>> again until the old invoices show up -- I'm assuming there are prior>> invoices, not a new customer). >>>> Once the invoice list is up, THEN put a check on "Show unpaid invoices>> only". Do NOT hit CLEAR before doing this. >>>> Click search again. >>>> If any invoices remain in the list, they must be PAID prior to Emerald>> creating a NEW invoice for that customer. >> <<<< > No there aren't any Unpaid invoices for this customer > >>>> >>> M. Ersan > ersan@first.net.jo > firstnet >>

Michael J. WhisenantVice-President, OperationsAIRnet Internet Services, Inc.ph: (256) 704-4692 fax: (256) 704-2329 --=====================_457723115==_.ALTContent-Type: text/html; charset="us-ascii"

As I understand it even if the invoice is paid, and the dates in themaster billing record are adjusted backwards then until that invoice isvoided it WILL not create another invoice. For example

        A invoiceis created and paid covering period from 5/1/98 to 6/1/98
        You adjustmanually the expiration period from 6/1/98 to 5/20/98

        It willnever create another invoice until the expiration date is moved ahead of6/1/98 OR the invoice covering that time period is deleted!

At 07:03 PM 6/3/98 +0300, you wrote:

Does the customer'sMBR have the "Active" box checked?

Are there ANY services with the "Active" box checked,associated with the MBR?

<<<<
yes
>>>>
------------

If the above both answer yes....

Does this customer have ANY other invoices outstanding? Go to theINVOICES tab, put the user's name or login there, and UNCHECK"Unpaid only invoices". Click SEARCH. Allpast invoices for the customer should show up. (If theydon't, you typed int he login or name incorrectly -- try again until theold invoices show up -- I'm assuming there are prior invoices, not a newcustomer).

Once the invoice list is up, THEN put a check on "Show unpaidinvoices only". Do NOT hit CLEAR before doing this.

Click search again.

If any invoices remain in the list, they must be PAID prior to Emeraldcreating a NEW invoice for that customer.
<<<<
No there aren't any Unpaid invoices for this customer
>>>>

M. Ersan
ersan@first.net.jo
firstnet

Michael J. Whisenant

Vice-President, Operations

AIRnet Internet Services, Inc.

ph: (256) 704-4692 fax: (256) 704-2329

--=====================_457723115==_.ALT--

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: IMail from IPSwitchFrom: "Chris A. Christopher" <management@labyrinth.net>Date: Thu, 04 Jun 1998 14:28:35 -0400

When will Emerald interface with IMail?-------------------------------------------------------------------Chris A. Christopher mailto:management@labyrinth.netCEO Voice (304)292.7700 Labyrinth Solutions Inc. Fax (304)292.6549 235 High Street, Suite 416Morgantown, WV 26507-0434 http://www.labyrinth.net====================================================================

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: voiding paymentFrom: "Bill Bongiorno" <bill@systec.com>Date: Thu, 4 Jun 1998 15:36:33 -0400

Is there any way to void/cancel a payment?

Bill BongiornoSysTec Computer Associates, Inc.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: voiding paymentFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 04 Jun 1998 12:55:33 -0700

Bill Bongiorno wrote:> > Is there any way to void/cancel a payment?

You have to void the invoice the payment was applied to and thenre-create the invoice.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: voiding paymentFrom: "Bill Bongiorno" <bill@systec.com>Date: Thu, 4 Jun 1998 16:21:51 -0400

Both the invoice and the payment were for the wrong customer. So I can'trecreate an invoice for this customer. I followed your advice to void theinvoice assuming it would also void the payment. Now I have an incorrectunapplied payment on this customer's account. I can go into the paymenttable and delete the record but wanted to make sure this is the onlysolution.

Bill BongiornoSysTec Computer Associates, Inc.

> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.> Sent: Thursday, June 04, 1998 3:56 PM> To: emerald@iea-software.com> Subject: Re: voiding payment>>> Bill Bongiorno wrote:> >> > Is there any way to void/cancel a payment?>> You have to void the invoice the payment was applied to and then> re-create the invoice.>> --> Dale E. Reed Jr. (daler@iea-software.com)> _________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: IMail from IPSwitchFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 04 Jun 1998 13:35:47 -0700

Chris A. Christopher wrote:> > When will Emerald interface with IMail?

Rather than chase down every possible vendor that could work withEmerald and do all the grunt work, we are going to be using a newapproash with Emerald 2.5. Emerald 2.5 will include a fullyextensive DLL that currently has the proprietary extensions forNTMail, Serv-U and DNews. Also includes is our open API setthat allows any program to validate and manipulate Emerlad users,without having to understand the database. It will come withfull documentation so that other vendors can easily make hooksfor Emerald w/out us having to re-invent the wheel each time.

The advantage to this is great. You the customer, can sendthe vendor the information (our point them at it) and they should have a very small development cycle to support it,since there will be no interaction requirements from ourside.

If you are a vendor or 2rd party integrator and would like tosee the DLL information before Emerald 2.5 is released, pleasesend me E-Mail, and I will forward it to you.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: voiding paymentFrom: "Josh Hillman" <admin-maillist@talstar.com>Date: Thu, 4 Jun 1998 16:51:26 -0400

/* Delete a payment from the database *//* This does NOT subtract the payment from MasterAccounts.Balance *//* Or modify the expiration, paidthru, last-received dates */

DECLARE @PaymentID intSELECT @PaymentID = /* Enter PaymentID to be deleted */

UPDATE InvoiceItemsSET PaymentID = NULLWHERE PaymentID = @PaymentID

DELETE FROM PaymentsWHERE PaymentID = @PaymentID

Josh Hillmanhillman@talstar.com

> Bill Bongiorno wrote:> > Is there any way to void/cancel a payment?> > From: Dale E. Reed Jr. <daler@iea-software.com>> You have to void the invoice the payment was applied to and then> re-create the invoice.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: NAS Cisco , Unix etc..From: "David Moore" <MOORED@ROMTECH.COM.AU>Date: Fri, 5 Jun 1998 07:05:28 +1000

James we are using Emerald / Radius on NT we have been using it sinceJanuary we can recommend this product to you. As for support this productwould have to have the best email support I have ever seen, Dale who runsthe email support seems never to sleep, as I see support emails answered allthrough our day and I have even logged support calls on a Saturday / Sundayand received replies. The negatives of this product is its billing structureand I have to say that due to the relaxed way we do our business we can'tuse the billing and don't, however if you can stick to the regime laid outit could work for you. The other problem in emerald 2.2 and prior is US dateformat this is fixed in Emerald 2.5 the new beta test product. If you wantfurther information you can call me on 02 9948 1199.

Regards David Mooremoored@romtech.com.au

-----Original Message-----From: James <daj4@mcmedia.com.au>To: emerald@iea-software.com <emerald@iea-software.com>Date: Friday, June 05, 1998 11:11 AMSubject: Re: NAS Cisco , Unix etc..

>What support do you offer for Australin customers.>Do you have some ISP's here using your product.>Thanks>Daryl>>> I'd really need more details of what you are asking here. We offer a>> consulting service for database conversion and migration. Many customers>> converting from other ISP billing products request us to convert their>> database.>>>> -->> Dale E. Reed Jr. (daler@iea-software.com)>> _________________________________________________________________>> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs>> Internet Solutions for Today | http://www.iea-software.com>>>>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 18 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald won't run today, Take IIIFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 04 Jun 1998 14:12:37 -0700

Jeff Woods wrote:> > Didn't see a followup, so perhaps the list bounced me yet again. Last> attempt at this via this forum.....> > Emerald was open last night, functioning properly.> > I tried to run a batch invoice run this morning. It CREATED the batches> fine, so it said (and an SQL query shows this to be true). However, when I> tried to print the batch, I was told that I did not have logon permissions> to do so! (I was logged on as SA at the time!) "Self," I said to myself,> "it looks like you need to reboot your workstation.> > After rebooting, I got "Error loading from file" when trying to load> Emerald. I can't get into Emerald at all now. (I also rebooted the SQL> server at the same time, just in case).

The typical cause of this problem is that the SQL Client tools are notinstalled. I would try re-installing both the SQL Client Utilitiesand Emerald. The program you instaled most likely overwrote a fileneeded by the client with an older version. > RadiusNT is still running fine, authenticating and accounting. I can run> SQL Enterprise Manager, and view the databases and make queries from this> workstation. Emerald is not installed on any other workstations, but I> imagine that it WOULD work from there.

Maybe just re-installing Emerald itself then? > I believe that a program I installed yesterday overwrote a critical library> needed by Emerald. Which one, I don't know.>> Dale, can you tell me which library being replaced could cause this error,> and where I can find the one YOU require, before Friday morning when I have> to finish this billing cycle?

Emerald doesn't use jet or any of the DB support of VB5. So I don't knowif any of those are the issue. You can look at the Emerlad distributionto see if any of these files are in that. You might also take this timeto install Emerald 2.2, which may work with those program better, sinceit is VB5 based, whereas Emerald 2.1 is VB4 based.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 19 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Automated on-line subscription of new customersFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 04 Jun 1998 14:16:38 -0700

J Dyer wrote:> > Hi,> I am trying to do online signup with asp at the moment, can supply the asp> sample version of your scripts ?

I don't have the actual scripts. I just helped hom get over some programmingissues with them. To be honest, I don't remember who the person makingthe conversion is. :( My memory isn't what it used to be.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 20 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald would not issue a Renewal-InvoiceFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 04 Jun 1998 14:20:32 -0700

Mohammed Ersan wrote:> > >The typical reason for this is because you moved the expiration> >date of the MBR back, and not have an overlapping billing cycle.> >You must either void the overlapping invoice, or move the expiration> >date to the enddate of the last invoice for it to bill the customer.> >Use the history tab on the MBR, find the last invoice, and check the> >end date. Then compare that to the expire date. The exipre date> >MUST be latter (or equal to) that end date.> >> the expiration date equals the last invoice end-date and even I've tried to put it one year later but it still wont> issue a renewal for that customer

What about the active flags and the pay method the MBR is configuredfor? I've seen cases where the pay method somehow got set to "other"which will prevent the MBR from be billed as well.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 21 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald would not issue a Renewal-InvoiceFrom: "Josh Hillman" <admin-maillist@talstar.com>Date: Thu, 4 Jun 1998 17:29:48 -0400

> From: Dale E. Reed Jr. <daler@iea-software.com>> The typical reason for this is because you moved the expiration> date of the MBR back, and not have an overlapping billing cycle.> You must either void the overlapping invoice, or move the expiration> date to the enddate of the last invoice for it to bill the customer.> Use the history tab on the MBR, find the last invoice, and check the> end date. Then compare that to the expire date. The exipre date> MUST be latter (or equal to) that end date.

As far as invoices go, isn't this only relevant if the invoice is of type"Renewal" and not "Invoice"? I just found out today that one of ourcustomers was never billed for quarterly service from 6/1 - 9/1 and I stillcan't get the next invoice to be created ("no new invoices to create!"). In the past, I've run into this and it was always something simple likewhat you already described (MasterAccounts.ExpireDate < Invoice.EndDateAND/OR a previous "Renewal" invoice was not paid or voided) and fixing itwas a piece of cake. This one has got me somewhat stumped. I have a textfile that I placed in one of my web-directories displaying the billinghistory for this customer: http://hillman.talstar.com/temp/ait.txt

If you could take a peek at this and possibly shed some light on thematter, I'd sure appreciate it.

Creating "Renewal" invoices for other customers is not a problem. Itappears to be specific to this one billing record.

NT4 SP3, MSSQL 6.5 SP3, Emerald 2.1.11

Thanks,

Josh Hillmanhillman@talstar.com

> Richard Sensale wrote:> > Mine is doing the same thing now. I tried setting the batch for like4/1/98> > and still nothing even though we have multiple unpaid invoices. Imrunning> > 2.11.1> > > >emerald just won't issue a renewal for customer that expired on May17, it> > did not issue in the batch process nor on the manual Renewal issuanceI've> > tried 2.2.23 or 2.2.42 and same thing "No new invoices to create!"

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 22 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: SELECT DISCTINCT ability in Crystal Reports 5?From: "Josh Hillman" <admin-maillist@talstar.com>Date: Thu, 4 Jun 1998 17:55:52 -0400

Does anyone know if there's a way to implement the "DISTINCT" feature of aSQL SELECT statement in Crystal Reports 5.0 reports? I created a CR5report that displays the following payment information for any requesteddate: InvoiceID, Name, Company, Amount Due, Amount Paid Grouped by MasterAccounts/Groups.GroupName Totals for each Group Grand totals for the date specified.

For our needs, it's perfect EXCEPT for the fact that it duplicates many ofthe rows because of multiple InvoiceItems associated with some of theInvoiceIDs. At the following address are two of these reports--one thatworks just fine (if I leave out the Invoice.Amount (Amount Due) and leaveout the Invoices/InvoiceItems.InvoiceID); the other displays the multiplerows for any invoice that contained more than one InvoiceItems.ItemID.

http://hillman.talstar.com/temp3/ Daily-Payments.rpt (works correctly, but lacks InvoiceID and Invoice.Amount Daily-Payments2.rpt (doesn't work correctly)

Does anyone know how to fix this? It seems like something so simple, yet Ican't figure it out. I have a plain SQL script that performs all of thisstuff correctly using SELECT DISTINCT, but I can't seem to add "DISTINCT"to the report SQL query.

Thanks for any help...

Josh Hillmanhillman@talstar.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 23 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: voiding paymentFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 4 Jun 1998 19:58:02 -0700 ()

On Thu, 4 Jun 1998, Bill Bongiorno wrote:

> Both the invoice and the payment were for the wrong customer. So I can't> recreate an invoice for this customer. I followed your advice to void the> invoice assuming it would also void the payment. Now I have an incorrect> unapplied payment on this customer's account. I can go into the payment> table and delete the record but wanted to make sure this is the only> solution.

Yes. But the payment is applied to a voided invoice, whichvoids the payment. I believe all of the reports we supply look forthis and ignore it. You can delete it manually as well. > Bill Bongiorno> SysTec Computer Associates, Inc.> > > -----Original Message-----> > From: emerald-request@iea-software.com> > [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.> > Sent: Thursday, June 04, 1998 3:56 PM> > To: emerald@iea-software.com> > Subject: Re: voiding payment> >> >> > Bill Bongiorno wrote:> > >> > > Is there any way to void/cancel a payment?> >> > You have to void the invoice the payment was applied to and then> > re-create the invoice.> >> > --> > Dale E. Reed Jr. (daler@iea-software.com)> > _________________________________________________________________> > IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> > Internet Solutions for Today | http://www.iea-software.com> >> >

Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 24 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: DNS Management for Emerald?From: "Peter A. Sang" <pesa@sang.de>Date: Fri, 5 Jun 1998 07:21:13 +0200

Good Morning!

I'm thinking about some extensions to the Emerald DB scheme, holding DNSentries for some customers with webservers.Anyone else tried this and wants to share his experience? I don't likeinventing the wheel twice ;)

cu,Peter

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 25 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SELECT DISCTINCT ability in Crystal Reports 5?From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 04 Jun 1998 22:48:37 -0700

Josh Hillman wrote:> > Does anyone know if there's a way to implement the "DISTINCT" feature of a> SQL SELECT statement in Crystal Reports 5.0 reports? I created a CR5> report that displays the following payment information for any requested> date:

You need to create a second group to show the distinct, and hide thedetails section. I modified your report to output what I believe iswhat you are looking for. Its a CR 6.0, but it should work find onCD 5.0 as well. Its in /emerald/contrib/reports.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 26 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald would not issue a Renewal-InvoiceFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 04 Jun 1998 22:53:59 -0700

Josh Hillman wrote:> > As far as invoices go, isn't this only relevant if the invoice is of type> "Renewal" and not "Invoice"? I just found out today that one of our

No. The issue with this account is that the start/end dates are notthe same. Emerald will ignore invoices that have the same start/end date,but and invoice or renewal that does not have the same start/end date is considered overlapping.

MasterAccounts: maExpireDate = 6/1/98 Active = 1 PayPeriod = Quarterly PayMethod = InvoiceSubAccounts: Active = 1

Date InvoiceID StartDate EndDate Amount Login Description --------- --------- ----------- --------- --------- -------------------------------------- -------------------------------------------------- Invoice.Type=Invoice05/29/98 Item 7543 -360.00 Negotiated by 05/29/98 Item 7543 30.00 Virtual DomainHosting 05/29/98 Item 7543 250.00 WebsiteDevelopment 05/29/98 Item 7543 300.00 BannerAd 05/29/98 Total Due 7543 06/05/98 09/05/98 750.00

This is the one that is causing the problem, since the enddate is higherthan the expire date.

Previous message: Dale E. Reed Jr.: "Re: Emerald would not issue a Renewal-Invoice"
Next message: Dale E. Reed Jr.: "Re: DNS Management for Emerald?"