We are getting the same thing. They look like the overages charges but =
are added again every time you run charges. Run charges 3 time you get =
3 entries in the invoice and no way to edit or remove the charges.
Dale any ideas?
-----Original Message-----
From: Will LaSala [SMTP:will@greennet.net]
Sent: Tuesday, March 11, 1997 9:35 AM
To: Emerald Mail Group
Subject: Billing Question
Hi all,
I got kinda a strange problem here.
It's more then likely because I have no clue
what I'm doing.
Here's what happens:
When I go to the Batch tab in Emerald Client
put in a date (like 2/1/97) then select type renewal
I get some charge made (like 25 or so) and the bill
looks like the correct amount (like 100 hours is 19.95)
However when I do the same thing and select invoice
I get alot of charges made (like 1135) and when I check in the=20
Invoices section for the charges I get crazy numbers on the bills
(like "username monthly usage of 3 hours" "$59.85" this=20
should be 19.95 but it looks like it getting charged 3 times for=20
19.95) =20
This is what I have setup in the Emerald admin:
Service Types:
PPP 100 Hour
cost =3D 0.00
tax =3D 0.0
Rate =3D 100 hours
Billing Group =3D Dialup Users
Rates:
100 hours
Allow Overtime =3D "checked"
Standard
Hours =3D 100
Regular Charge =3D 19.95
Over Charge =3D 0.50
This looks good but still doesn't work.
I also had it setup so that
The service type PPP 100 Hour
had a cost of 19.95 and the rates 100 hours
had a Regular Charge of 0.00
that didn't help either.
P.S. Where I'm just testing the billing functions
I was wondering if there was away for me to get the=20
invoice numbering to start over at 0, and to remove all the bad invoices
with out having to delete each one individually and the history=20
tables for all the MBR's to empty out.
Does anyone have the SQL command to do this?
Thanks Alot!
Will
Webmaster
* =
GreenNet=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D*
* "Link Locally ~ Surf Globally" http://www.greennet.net *
* Come Play On Our Game Server *
* Serving northeastern Massachusetts, southern New Hampshire *
* TEL: 508-363-8898 FAX: 508-363-1225 email:will@greennet.net*
*=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D*
----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com
------ =_NextPart_000_01BC2E00.762DEC10
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IjkOAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAwAEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAGVtZXJhbGRAZW1lcmFs
ZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABgAAABlbWVyYWxkQGVtZXJhbGQuaWVhLmNvbQADABUMAQAAAAMA/g8GAAAA
HgABMAEAAAAaAAAAJ2VtZXJhbGRAZW1lcmFsZC5pZWEuY29tJwAAAAIBCzABAAAAHQAAAFNNVFA6
RU1FUkFMREBFTUVSQUxELklFQS5DT00AAAAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAAGAAAAGVt
ZXJhbGRAZW1lcmFsZC5pZWEuY29tAAIB918BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAA
AGVtZXJhbGRAZW1lcmFsZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAA
AwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAALpXwEEgAEAFQAAAFJFOiBCaWxsaW5nIFF1
ZXN0aW9uACoHAQWAAwAOAAAAzQcDAAsACQApADUAAgBLAQEggAMADgAAAM0HAwALAAkAJwAnAAIA
OwEBCYABACEAAABGNDUyRDczNDQ2OTlEMDExQkYzMTAwQTBDOTA2MkUyRgADBwEDkAYA/AkAACEA
AAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAALACkAAAAAAAMALgAAAAAAAwA2AAAAAABAADkAwAla
XCouvAEeAHAAAQAAABUAAABSRTogQmlsbGluZyBRdWVzdGlvbgAAAAACAXEAAQAAABYAAAABvC4q
WHA011L1mUYR0L8xAKDJBi4vAAAeAB4MAQAAAAUAAABTTVRQAAAAAB4AHwwBAAAAEAAAAGVtaWxs
ZXJAZGVsLm5ldAADAAYQn/eShAMABxAlBwAAHgAIEAEAAABlAAAAV0VBUkVHRVRUSU5HVEhFU0FN
RVRISU5HVEhFWUxPT0tMSUtFVEhFT1ZFUkFHRVNDSEFSR0VTQlVUQVJFQURERURBR0FJTkVWRVJZ
VElNRVlPVVJVTkNIQVJHRVNSVU5DSEFSRwAAAAACAQkQAQAAAOUGAADhBgAAuAsAAExaRnXmbx64
dwAKAQMB9yACpAPjAgBjgmgKwHNldDAgBxOHAoMAUA72cHJxMg/2Jn0KgAjIIDsJbzI1ZjUCgAqB
dWMAUAsDYwMAQQtgbmcxMDMzYQumIFdlIArAFnBnhQ/AdAuAZyB0aBZwHHNhB4AXQRcRLiAgklQX
YHkgCQBvaxigTGlrF8IWcG92BJBhzxbQBCAPchniYnUFQBaSVGFkAQBkFoBnC3EgXmUZoRiQFwAX
sXkIYCBccnUDoBolGDFSHOgg3jMcOBbRHmEJ8HQIgQQghxuxF1ILgHZvaWMWcYJuG2BubyB3YRwh
+yFACYBpBUAFsQlwBGAZoJ8XQx0WCqIKgQGRIEQHQIsg0hiQaQEAYXM/I4XnJTcLMBkAMzYBQBUQ
AUApEUBvdAWQdBCEMTbUIC0n4k8FEGcLgAdA/wXQB5AXkBbQJ+MlJib0JsGDCxMm9mktMTQ0AUDx
GQAxODABQAzQK4MkEOpGA2E6DINiFkEDEAMgDExhBhALYCBbU01YVFA6A/AtwEAJw271D8AuL2Fd
I4UkEAZgAjClLRdUClBzZCFwLAXQIwrAD3AgMTExsDE5gDk3IDk6MzUP8NJNL+dUby0XRQeAGcAu
bBtgMdADEUcDYHVwsS/odWJqJyEtF0Itsf0XElExURcAAiApjyqaJkSzC7Yjk0hpFoAtwCwjhOZJ
FsAnACBrC4AxgBaAfxeAH6AVYRZwJuECYCJgIMcXYAlwI3VJdCcEIARgrxahF1EDoBkCbBiQYgWQ
9GF1D7AgO/APgCKRITE2YwpBI4R3D4AFQEkn3T2wZCCgGBElKkg94T6h00GjD4BwcAnwcy0QI5Pe
Vz8yO/IhkhdSQkHAMgF3I/IbsTR2QxkAH4EjhHCfGrEbsS5AMYAnECAoGQPQMi8xLzKQKT8UD7D3
JFAnMBdAeURAIkEvYCFg9wlQO6YfMXMDcCLmPsAbIH9I1zLwBbFMEEmwIPIXUmL/LbEjhBiyBCAZ
BwWhCXBKYb8XoAhgAjBI5RWQD+BoCGGHH+EEIDJwLjk1KTrF/G93G+JDsUUTQjAXTSDjn0olIHVL
WgdAPCFvZhoX/0zZMjAy4E4EU5UPcAWQGOB/IAU7lSCEBCAPsCcwN/EgfwIQBcAiyUUyHzEaEBnA
evkYkG51BtAEkAQgW9FOZvcPQCOTSPQiQCEEoBeiBGD9AjBoP7FAIBnRV0IecFHDkiJfwCQ1UmA4
NWHw9xfhBCEjk3NRwTTBP+BSRP8akyHxT0kh8RbWGiQbYB50/wQgXAIjhFJUGEAjhBhgUiH/UiFB
pEB0D7E1cB/2NHYbIK5tC4BEhQZhdiCyVEqh/UR2UG0wUXNTEAhwI4QFoME30CA9IDAuLBEjk90B
kHgYQG6jI4RSSLJuoN9RhyOENyY1Q26RRAcxahG+VV/xXwVwCER2cN1BLcC5UyAgTxmhHENuoCJZ
w/0JgCIjhBhABgABkDxxCyLPUtRR4nCzcAVlZ2OACsH+Q0x0cLFSYiOEdlJ6iG7A/jU6tWhJT0Q8
EARwGpM30actwUIwB5BuJwVAdwWw/ms+FjtBTBBAcRtgIfFp5P+AwRdQQcBoRmnCbBRKk20//gqA
8i5AblNXUWP0TiYZwP90YXDOhMR6HVdRbslBsiHg1mR/khdgbGogZSHwPdHxQotQLlMYMETxFqFB
8n5qQCBKcTfCFyVOohcSZv8c4FujXwU78CFgQ6ECIASB3xcSBpAXQhahj8JhIWJcAv8XsiFAHyJa
WCB2XdQXEyFA3zfQCsAiAVNSQcEwMbBOI/8hQCJVO1FOVIECWwVBRYsR/xmAGrFAgZQlAQAkUEjB
JOCfMgECICBSIeBsIGR1O1H/GJBOJmKxIaAcEW8GPYFnBLGWhk1CUj6hIaJtBTD3GJCYcSN1RH9h
JHKaEkCD0RdSU1FMUCFtA4GVw/9UAwQAJRsYYABwT3F18CcA7iFElU63FmBiAMA30ASQnSOEKjUx
CeEHwHQ9ph/Lpy+ngyqlFiJMC4AY4MxMb0AAmuIgfngBCHD9V2BHCQCXAJrhd4Aj8nfxDxUDY4A9
wAJAcDovL/p3rJAuLxomk2OAD+CuGL+ol6skDIQkAQhQF7FQC2D1GJBPA6BPCHA1MBeia/L/U2Gu
H6Vha/MXISEwACAXYH+kwwOgMdAo4Q9wQCECQHO/MbBMEBqwPdEDoAfCSBegGnBjUGkWoa64VEVM
JDogfNA4LSZgMy0QODg5OHfxRkFYebfYMTJNgSJgNQEuv3T/qJanj7z/p88lVyfUwA/BH//CLylm
NGsXEqkwbnGyGRkAtzfQgtIEkEAiYDSTLgiQXGEuoNElKhIBAMhwAAAAAwAQEAAAAAADABEQAAAA
AAMAgBD/////QAAHMAAEYQwqLrwBQAAIMAAEYQwqLrwBCwAAgAggBgAAAAAAwAAAAAAAAEYAAAAA
A4UAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMABYAIIAYAAAAAAMAAAAAA
AABGAAAAAFKFAAC3DQAAHgAlgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC4wAAMA
JoAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAvgAggBgAAAAAAwAAAAAAAAEYAAAAADoUA
AAAAAAADADCACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAMoAIIAYAAAAAAMAAAAAAAABG
AAAAABiFAAAAAAAAHgBBgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AQoAI
IAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAEOACCAGAAAAAADAAAAAAAAARgAA
AAA4hQAAAQAAAAEAAAAAAAAAHgA9AAEAAAAFAAAAUkU6IAAAAAADAA00/TcAAK/G
------ =_NextPart_000_01BC2E00.762DEC10--