Updates:

March 15, 2009

Updated

Fixes some bugs

1. Collectibles
Returns a wrong total after searching for subscriber name
2. Paid Charges
Returns a wrong total after searching for subscriber name
4. Wire Inventory
Name and Address was added in the note field
5. Disbursement History
Total was added before the Date column
6. Payment History
Total was added before the Subscriber No column
7. Ledger
Allows you to go directly to Receive payment form by double clicking the listview
8. Reconnection
Remove the word disconnected in the name textbox
9. qry_Payments
Be sure to update the qry_Payments query. Just overwrite your existing query in data.mdb if you are currently using this program.

Previous updates

Added earliestDate variable to hold a value for the earliest date of payment in receive payment form to avoid data from hiding in the report.

Added encoder in Disconnection and Reconnection List.

The source code contain advance coding specially on how to manipulate data using SQL Language. You will appreciate how I use the WHERE Clause statement to SELECT, INSERT, UPDATE record from the database using a combination of sql statement.

Basic features include:

1. Monthly Charges
2. Receive Payment
3. Customer Ledger
4. Collectibles
5. Paid Charges
6. Payment History
7. Reporting
8. And a lot more...

For username and password plus .ocx file please visit http://www.sourcecodester.com/visual-basic/billing-software.html

P.S. Part of the code especially in module section is made by Philip Naparan. All other code and systems concept are mine.