[Emerald Digest]

emerald-digest-request@iea-software.com
Sat, 1 Aug 1998 00:00:01 -0700

Message 1: RE: Framed Adresses
from Rafael Gomez <rgomez@c-com.net>

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

Message 3: time limited accounts
from "=?iso-8859-1?Q?Andr=E9_Grenier?=" <ag@thenew.net>

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

Message 5: Re: time limited accounts
from "Dale E. Reed Jr." <daler@iea-software.com>

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

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Framed Adresses
From: Rafael Gomez <rgomez@c-com.net>
Date: Fri, 31 Jul 1998 09:06:51 -0400

------ =_NextPart_000_01BDBC62.8F0F3F80
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Dale
The fixed address assignement is working now. The question was that I =
was authenticating with one remote radius server and the accounting I =
did was local. To make this work, I had to have the accountig and =
authentication in the same server. That was all.

Thanks for your help

Rafael Gomez

-----Mensaje original-----
De: Dale E. Reed Jr. [SMTP:daler@iea-software.com]
Enviado el: Thursday, July 30, 1998 10:00 PM
Para: emerald@iea-software.com
Asunto: Re: Framed Adresses

Rafael Gomez wrote:
>=20
> The Cisco is not passing the Framed-Address information to the Emerald =
Software. Do You know what commands I need to make this success?

Probably an IOS upgrade? If its an option, then I don't know.
=20
--=20
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

------ =_NextPart_000_01BDBC62.8F0F3F80
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IjQNAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYA0AEAAAEAAAARAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAEGVtZXJhbGRAaWVhLXNv
ZnR3YXJlLmNvbQBTTVRQAGVtZXJhbGRAaWVhLXNvZnR3YXJlLmNvbQAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABkAAABlbWVyYWxkQGllYS1zb2Z0d2FyZS5jb20AAAAAAwAVDAEAAAADAP4P
BgAAAB4AATABAAAAGwAAACdlbWVyYWxkQGllYS1zb2Z0d2FyZS5jb20nAAACAQswAQAAAB4AAABT
TVRQOkVNRVJBTERASUVBLVNPRlRXQVJFLkNPTQAAAAMAADkAAAAACwBAOgEAAAADAHE6AAAAAB4A
9l8BAAAAGQAAAGVtZXJhbGRAaWVhLXNvZnR3YXJlLmNvbQAAAAACAfdfAQAAAE8AAAAAAAAAgSsf
pL6jEBmdbgDdAQ9UAgAAABBlbWVyYWxkQGllYS1zb2Z0d2FyZS5jb20AU01UUABlbWVyYWxkQGll
YS1zb2Z0d2FyZS5jb20AAAMA/V8BAAAAAwD/XwAAAAACAfYPAQAAAAQAAAAAAAACIGUBBIABABQA
AABSRTogRnJhbWVkIEFkcmVzc2VzAJoGAQWAAwAOAAAAzgcHAB8ACQAGADMABQBCAQEggAMADgAA
AM4HBwAfAAkAAgAEAAUADwEBCYABACEAAAA4ODREQzc1MzU0MjhEMjExOEVBNDAwQTAyNDk4MTNG
NgDvBgEDkAYAtAYAACEAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAALACkAAAAAAAMALgAAAAAA
AwA2AAAAAABAADkAwDJIFYS8vQEeAHAAAQAAABQAAABSRTogRnJhbWVkIEFkcmVzc2VzAAIBcQAB
AAAAFgAAAAG9vIQVSFPHTYsoVBHSjqQAoCSYE/YAAB4AHgwBAAAABQAAAFNNVFAAAAAAHgAfDAEA
AAARAAAAcmdvbWV6QGMtY29tLm5ldAAAAAADAAYQR9LgFgMABxC4AgAAHgAIEAEAAABlAAAAREFM
RVRIRUZJWEVEQUREUkVTU0FTU0lHTkVNRU5USVNXT1JLSU5HTk9XVEhFUVVFU1RJT05XQVNUSEFU
SVdBU0FVVEhFTlRJQ0FUSU5HV0lUSE9ORVJFTU9URVJBRElVU1NFUgAAAAACAQkQAQAAAJ0DAACZ
AwAAxAUAAExaRnUgMtbSdwAKAQMB9yACpAPjAgBjgmgKwHNldDAgBxOPAoMAUALyD1lUYWgDcYUC
gzIO53BycTIP9iZ9CoAIyCA7CW8yNWY1AoAKgXVjAFALA2ODAEELYG5nMzA4EmHpC8QgRAdAZQqi
CoEBkYERoGhlIGZpeAmAsCBhZGQJcAQRYQQQsGlnbmUHgAIwIAQAFCB3BbBrC4BnIG4ob3cuGQNx
ClBzdM5pAiAbEBowIHQPgAVAMkkcs2F1HQAasWlj7x0gG2ID8B0AIAIgGTAJcM0EYHQfERmwaXUE
IA+w7HJ2BJAZoG4ZkB3RGaD6YwWgdR4BG3EdUB/AGZCXHMIJAB4wbBvRbyAAwO5rGTAdABr1LB1B
D4Agof8i0A+AIEAguxuAIIIduhyR8wuAILNzYQeAIAUb0h0hPR1zbCKQGGUYcyghbms3BCACEAXA
eQhhJABlbB5wKPoWdgFAFxIxMDMiMxCDczE3B/BhZpJhKsAgRwNwZXorWhMXGBJiMTYuK2kzNlcB
QBMAH2FjBUAtMYJN+wnwJ1BqGTAFsBpgC4AHQH8xgyj2MRQw4QsTMRQCAGkQLTE0NCwxaTE4HjAB
QAzQNSMY8ERlOqUMg2IYBCBFG9BSCeAFGZBKJ/FbU01UUCQ6ZBgxckAIkGEtXHNvAYAcwAlwLgWg
bUZdGGUY8EVudgcwZF8i0CrANpcZEAhwcziQecEj0Ep1bHkgF1Aj0JAxOTk4POAwOjWwqCBQTToH
UArAYTaXMxqRH6BsZDjvOgdBc40hQW82lzegOiBGH6D7B4AZkEEZ0weQMy80OjCk/yxYC8UYcy1q
GxAxEjaQGHPuPgrjSFIZEkMEAAWgGuJ/G6AFQAqwGkEbcSDCQmQt/0LQGdQLgCohAMAccyRRIMK+
RT80BgA5RhgQItBZCGB8IGsboRsQHRI5wQOBZP8EIB1QGoAZgSRRIvhBQCEQ1RnxPyj6UANgYgGg
PIHJA5FJTwXwdXAJwBmwqGU/IB1AZhrgdBoR/QOgbwUwHIEj0B3SIaICIP4nBUBOkijlSIUxgEiF
Ny+sICg4nzmjKRhkX1qPH1ufXK9di1YlXvRJRUGzTXcj0W5jWHFe8nxTwPMtYB/CTlQj0E0FI9Ag
gvNhcEJQQVFDRWAxH3AEoP8PwE1xCkAccioEIsA8EWDDHwMwFtI8cCQAAkBwOi/0L3dmcC4/rywS
PHBGdQsYZBPBAGkwAAAAAwAQEAAAAAADABEQAAAAAAMAgBD/////QAAHMMAyYmqDvL0BQAAIMMAy
YmqDvL0BCwABgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAOACCAGAAAAAADAAAAAAAAA
RgAAAAAQhQAAAAAAAAMABoAIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAC3DQAAHgAmgAggBgAAAAAA
wAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC4wAAMAJ4AIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAA
AAAACwAwgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADGACCAGAAAAAADAAAAAAAAARgAA
AAARhQAAAAAAAAMAM4AIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgBCgAggBgAAAAAAwAAA
AAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AQ4AIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAA
AQAAAAAAAAAeAESACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAHgA9AAEAAAAF
AAAAUkU6IAAAAAADAA00/TcAANqS

------ =_NextPart_000_01BDBC62.8F0F3F80--

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: voiding a payment
From: "Josh Hillman" <admin-maillist@talstar.com>
Date: Fri, 31 Jul 1998 12:56:28 -0400

> From: Bill Bongiorno <bill@systec.com>
> Occassionally we apply a payment to the wrong invoice. Dale said voiding
the
> invoice will effectively void the payment. But it still appears on
reports,
> for example the Daily Payment Register. How do others handle this
problem?

/* 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 int
SELECT @PaymentID = /* Enter PaymentID to be deleted */

UPDATE InvoiceItems
SET PaymentID = NULL
WHERE PaymentID = @PaymentID

DELETE FROM Payments
WHERE PaymentID = @PaymentID

Josh Hillman
hillman@talstar.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: time limited accounts
From: "=?iso-8859-1?Q?Andr=E9_Grenier?=" <ag@thenew.net>
Date: Fri, 31 Jul 1998 14:34:20 -0700

This is a multi-part message in MIME format.

------=_NextPart_000_012A_01BDBC90.4E406F00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I need assistance in setting up block hour packages.

For example, we have:

a trial account offering 60 hours or 30 days whichever comes first

100 hours for 19.95 then .95 for each additional hours

Could someone help me to set up these types of accounts?

Thank you for your assistance!

Andre.

------=_NextPart_000_012A_01BDBC90.4E406F00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

I need assistance in setting up block hour packages.


For =example, we have:

a trial account offering 60 hours or 30 days =whichever=20comes first

100 hours for 19.95 then .95 for each additional=20hours

Could someone help me to set up these types of=20accounts?

Thank you for your=20assistance!

Andre.

------=_NextPart_000_012A_01BDBC90.4E406F00--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: voiding a paymentFrom: "Bill Bongiorno" Date: Fri, 31 Jul 1998 17:15:53 -0400Thanks, Josh. The problem I found with Dale's solution of checking for avoided invoice is, to relate a payment to an invoice requires linkingpayment id via the invoice items table. If there are multiple items for aninvoice, the payment is listed more than once. It's probably possible toavoid this, but I can't figure out how.Bill BongiornoSysTec Computer Associates, Inc.> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman> Sent: Friday, July 31, 1998 12:56 PM> To: emerald@iea-software.com> Subject: Re: voiding a payment>>> > From: Bill Bongiorno > > Occassionally we apply a payment to the wrong invoice. Dale said voiding> the> > invoice will effectively void the payment. But it still appears on> reports,> > for example the Daily Payment Register. How do others handle this> problem?>> /* 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 int> SELECT @PaymentID = /* Enter PaymentID to be deleted */>> UPDATE InvoiceItems> SET PaymentID = NULL> WHERE PaymentID = @PaymentID>> DELETE FROM Payments> WHERE PaymentID = @PaymentID>>> Josh Hillman> hillman@talstar.com>..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: time limited accountsFrom: "Dale E. Reed Jr." Date: Fri, 31 Jul 1998 23:05:39 -0700> André Grenier wrote:> > I need assistance in setting up block hour packages.> > For example, we have:> > a trial account offering 60 hours or 30 days whichever comes firstSetup an account type with a 0 cost. Set it to Monthly billing andset the pay method to other. Set the service time left to 3600 andthe expiration to 30 days from today. > 100 hours for 19.95 then .95 for each additional hoursCreate a rate with a standard cost of 0, standard hours of 100,and overcharge of $0.95. Then create an account type with a costof 19.95 that has that rate picked. -- 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 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: voiding a paymentFrom: "Dale E. Reed Jr." Date: Fri, 31 Jul 1998 23:08:24 -0700Bill Bongiorno wrote:> > Thanks, Josh. The problem I found with Dale's solution of checking for a> voided invoice is, to relate a payment to an invoice requires linking> payment id via the invoice items table. If there are multiple items for an> invoice, the payment is listed more than once. It's probably possible to> avoid this, but I can't figure out how.What you need to do is supress the DETAILS section, and only showthe inner most section's footer. That will be the payment informationitself, and not each line item as well.-- 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