I noticed that some rows in the InvoiceItems table don't have values in
their "Login" field.
For example,
Login Description Amount
===========================================
kim PPP 5-hr dialup 250.00
kim - PPP Setup charge 1,500.00
kim - 15 Days 125.00
I would like to suggest the following :
Login Description
Amount
========================================================
kim PPP 5-hr dialup renewal fee (for April 1 to April 30)
250.00
kim PPP Setup charge
1,500.00
kim Prorated renewal fee for 15 Days (March 16 to 31)
125.00
Better yet, having a "Type" field in the InvoiceItems table to inidicate
what kind of bill item was would be nice. For example :
Type
====
Renewal Fee
Setup Fee
Prorated Fee
etc ...
Another nice-to-have would be a Start-date and and End-date field to
inidcate what dates the bill item covers. And for excess usage charges, you
could add an Excess-minutes and Excess-charge field.
Having these extra fields would allow us to design our reports with a lot
more control.
What do you think ?
- Danny
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart