From: kenny j. <jeo...@ya...> - 2003-09-07 02:28:11
|
Hi,James, 1) I believe it is better to have a table for account numbers, and the fields should be: account_number, account_title, account_type (such as current asset, fixed asset, other asset, current liability,long-term liability, equity, income,cost of goods sold, expense, other income, and other expense), and active_or_inactive. Account numbers should not be deleted if they have been used. For the two tables, payment and receipt, it is better to add a field for account numbers. It is not necessary to have a field for taxable/non-taxable if account numbers are used. With these information, it is easier to generate income statement and balance sheet. I can create the general ledger report without the account_number table. However, the balance sheet accounts should show beginning balance and ending balance, but income statement accounts should show only the total amounts for each income statement accounts, for the selected period such as 01-01-2003 thru 12-31-2003. ******* 2) From dates.php: <select name="startday"> <? for ($i = 1; $i < 32; $i++) { ?> <option value="<? echo $i ?>"><? echo $i ?></option> <? } ?> </select> Users may make some stupid mistakes, such as choosing 02-30-2003, 04-31-2003, 06-31-2003, 09-31-2003, or 11-31-2003. These are incorrect dates. There may be some problems if these errors are stored in database. 3)For the equity section of the balance sheet: it is different for different type of businesses (sole proprietorship, partnership, LLC, C-corporation, S-corporation, and trust). It is better to add a table for keeping the business information, including the name of the business, address, phone, fax, website,email,type of business, accounting method, year-end date, user-names and passwords,etc. Thanks, Kenny Jeong __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com |