Welcome to Randall's Homepage
I have spent 20 years in the IT industry designing and developing systems
and the last 12 years teaching courses at universities (over 5,000 students
taught). I originally got into systems as I found it to be a very challenging
and rewarding field, with the ability to make a difference in helping
businesses to run efficiently. Over the years I have built systems for
airlines, banks, retail firms, and transportation firms. I like golfing,
hiking, and horseback riding. I hold a PhD in Business and Technology from Northcentral University with a specialty in
Check out my books on Kindle, Kobo, Nook, and iTunes.
The University Professor (novel)
You can contact me at email@example.com
or at (403) 703 - 1878.
Life as a Professor
MBA Strategic Analysis
Computerized Financial Systems
This G/L System
is described in the above book on Computerized Financial Systems, which discusses systems for general ledgers, accounts receivable, accounts payable, inventory, fixed assets, payroll, sales, and order processing.
The source code is distributed here so that everyone can build a virus free G/L system. All of the code is kept in a single file and basic coding is used to help illustrate concepts.
This system can be used for a small business but was intended for educational purposes.
To compile this code, unzip it, download a copy of C# Express from Microsoft, open the project solution file, and then press the Start icon. The GLERP.EXE program that is created will make its own database when it is used. Once you have located the program, then you can copy it to other directories to make more companies.
To start using the system:
- Key in a company name
- Key in categories for accounts eg. Assets, Current, Sales, ...
- Key in accounts (types are B for balance sheet and I for income statement)
- Fill in the retained earnings account by the company name (the drop down may be used to see accounts)
- Define financial periods
- Enter a journal # to start a new batch of accounts to put in debit and credit amounts for activities
(valid types are N for normal batches, A for accruals that auto-reverse, and R for recurring batches)
- Process your journal batches (you will be told which journals balance and can be posted)
- View and print your financial reports (and remember to close the year in the last financial period)