Adilas.biz Developer's Notebook Report - 1/1/2008 to 1/31/2008 - (27)
|
||||||
Photos
|
Time Id | Color | Title/Caption | Start Date | Notes | |
AU 1593 | Daily Tasks | 1/1/2008 |
• Downloading a full copy of the LTF database. • Small year-end fixes, 2008 tax tables. • Small fixes with sub inventory types, credit card fees for inventory, small meeting with Steve and started to combine all vendors together. |
|||
AU 2421 | Daily Ideas | 1/1/2008 |
-Check the .com site. -Check the description field for parts, notes, and printable notes full vendor list. |
|||
AU 3559 | 2008 | 1/1/2008 |
YEARLY ACCOMPLISHMENTS 2008 Steve, This is a list of things that happened and accomplishments made during the 2008 year on adilas. It was a great year with tons of great stuff. If you need more detail, just let me know. I have everything documented down to the date. January 2008: • adilas, llc. officially became its own llc. • Changed vendors from shared (global) to corp specific. • Added destinations, categories, groups, and sub groups to expense and deposit types. • Moved the location on deposits from the main to the line items. February 2008: • The income statement (P&L) was added to the system. • Added permission pre-sets and color codes. • Split expense/receipts into main, line items, and payments. • Added payment options for expense/receipts to the main during add mode. • Set up our first international client on adilas. • Created the adilas logo. March 2008: • Migrated all fields and databases from old server to new adilas.biz server. • Changed from word “store” to “location” system wide. • Added PO photo gallery. • Added multi clock in/out feature. • Moved all sub navigation links to top of the page. April 2008: • Added the check request system. • Added a quick search to the top of every page. This idea came from David Berkenkotter. • Changed customer and vendor searches from two-part search (fist letter drop-down and optional characters) to a single text field look-up. • Added a printable customer list. • Expanded payroll from semimonthly to all other frequencies (daily, weekly, bi-weekly, semimonthly, monthly, quarterly, semiannually, and annual). • Added running bank balances and special bank balance search page. May 2008: • Added payables section for reimbursements, splits, and PO’s. • Added pages to show sub expense/receipts for splits and reimbursements. • Posted the adilas.biz check write system. Check on the top format. June 2008: • Added a special check write set-up page and section. This allowed for custom settings on the check write system. • Added the first round of the balance sheet (hidden to most users). • Created the adilas, llc. operating agreement, signed papers, and set up adilas bank account. • Allowed individuals to be used for parts and PO’s. Formally, only businesses could be used. • Added the customer or web portion of the adilas.biz site. This is where customers could browse inventory via web services without being in the secure portion of the site. • Added applied to stock flags on expense/receipts that were used as outside repairs on units. • Added drill-down links for outside repairs and internal invoices on the unit detail page. • Added a unit break-down report that show all expense and invoice details (main and line items) for a single stock/unit. • Added holiday pay to payroll options. July 2008: • Added a tie-in between payroll and expense/receipts. • Added key word searches for “last” and “new” on all quick search fields. • Added payables section for stock/units. August 2008: • Added odd days until first payment on finance calculator. • Reworked the floorplan section and allowed for payables on floored units. • Created a “What is adilas?” flyer for a trade show. Posted file online. • Standardized look and feel for all pages. • Added tons of special validation for XSS (cross site scripting) hacks. Page security to prevent hackers from misusing the application. • Added the duplicate to cart function for invoices. • Changed adilas server over to semi-dedicated server. September 2008: • Added save as pdf on income statement (P&L). • Added additional customers to shopping cart, invoices, quotes, and units. • Added ability to add more than one part to an invoice at a time. • Added check in the middle and check on the bottom formats as adilas check write options. October 2008: • Added a grouped receivables report. • Added an apply payments section for invoices. • Added invoice statements. • Added new pagination “next” and “prev” buttons to all reports that show more than one page. • Added the key word “home” to all quick searches. • Added a grouped payables report. November 2008: • Converted all outside web traffic (customer/web side requests) to another server and database. Used web services to push data from adilas to remote server to help with load balancing (server resources). • Added bulk verify pages for deposits and expense/receipt payments. • Added new options and fields to the check/payment search. Showed print status info and payment verification info. • Removed the requirement to lock line items before verifying. December 2008: • Converted the parts from a two-part combo (part number and vendor id) to a single part id number. • Added actual costs to update PO’s. • Added alpha sorts on reimbursements, splits, and PO’s. • Working on the second round of the balance sheet. Created both system maintained and user maintained balance sheet items. Major work on drill-downs for balance sheet look-backs. Files not yet posted. • Posted new 2009 tax files and tables. |
|||
AU 1594 | Daily Tasks | 1/2/2008 |
• Building a new printable vendors list. • Went in to meet with Steve. We went over payables and check requests. 10 miles. • Posted new files online for vendor changes. • Sent out an email notification. |
|||
AU 2422 | Daily Ideas | 1/2/2008 |
Process – paying a bill Army Surplus 1. Get bill – out two weeks (due date) $100 2. Create a PO a. Stock it in 3. Scan invoice and create an expense (main) 4. Search any piece that has not been paid a. Multi’s both ways (many pmts for single items – single pmt for multi items) 5. Assign to a PO 6. Make the pmt Like the Reimbursements with ability to pay only part of the total. -Reverse the deposit & invoice system. -Check request, vendor, stores, possible amount -Bank Balances: verified, printed, approved, requested pending -Add an aaah… I don’t know account to all new corps for people who have the admin permission – allow approval on the fly. Make a one page disclosure statement |
|||
AU 1595 | Daily Tasks | 1/3/2008 |
• Year-end tax stuff and commission reports. • Locked down vin number, created color coded graphics, changing wording from “general unit” to “specific units”. Changed “parts” to “general inventory”. • Posted new files online and tested files. |
|||
AU 1596 | Daily Tasks | 1/5/2008 |
• Added grand totals to year end reports for an associate. • Updated help files. • Started into some adilas special pages. • On the phone with Steve and then an associate. • Rewriting permission list online. |
|||
AU 1597 | Daily Tasks | 1/7/2008 |
• Helping an associate with a problem invoice. • Editing the permission list and making a pdf version. • On the phone with Steve. |
|||
AU 1598 | Daily Tasks | 1/8/2008 |
• Brainstorming on balance sheet stuff. Ideas on special expenses and special deposits. • Meeting with Steve going over new changes. |
|||
AU 2400 | Brainstorming - Sample Start-up Company | 1/8/2008 |
Sample Start-up Company 1. Initial investment of $10,000 and want to set up a new corporation - Set up new corporation - Set up new bank - $0 balance - Set up a balance sheet item(s) one for each investor o New chart of accounts – balance sheet – Equity – Capital Paid In (chart of account) - New balance sheet item with sub - Go right into a special deposit and tie it to the balance sheet item - New chart of account – balance sheet – Asset – Cash/bank balance - Once all is done fully owed equity goes up by $10,000 and the bank balance and assets goes up by $10,000 Accounting method: item was put in first and then the deposit was made. 1. Initial investment of $10,000 and want to set up a new corporation - Set up new corporation - Set up new bank, $0 balance - Make a deposit - Choose from deposit options: o Sales/invoice deposit o Transfer funds o Special deposit - Choose special deposit - Choose from a list of options: o Special orders – need to stock in a unit or need to create a PO for a part o Deposit on existing inventory – already in the system on an incoming PO o Refund – need to tie to an expense/receipt o Credit – could be money or other current asset form o Shareholder/investment – needs a balance sheet item o Loans – needs a balance sheet item o Donations – tie to invoice – long term liabilities o Sales – tie to invoice o General/Other – flexible and open - Choose shareholder/investment - Choose from existing balance sheet item or create new - Create new balance sheet item and sub - Finish up special deposit – ends up same as above – only difference, we hold your hand through the process Operations method: do a special deposit and let it prompt you to input the balance sheet item Use $6,000 to buy a delivery van – Paid in full - Set up a new balance sheet item and sub - Set up new chart of account o Balance sheet – Assets – Equipment –Delivery Van - Create a special expense/receipt and tie it to the van or balance sheet item - Create a new chart of account for the receipt – don’t want this expense type to go to the income statement – not sure what to do? o Balance sheet – Assets – cash/bank balance Accounting method: item is put in first and then paid for |
|||
AU 2423 | Daily Ideas | 1/8/2008 |
Purchasing an asset with cash – in other words cash goes negative and we don’t want to show on income statement - Balance Sheet – Expense – Purchasing an asset for balance sheet items - Add a new id holder to: o Deposit line items o Receipt line items o Invoice line items - Only show this ide when using special balance sheet related actions. - If I need to make the above account 4 deep – Balance Sheet – Expense – Balance Sheet Items – Purchasing a unit - This type of account may be need for things like reimbursements – original idea was to create an account destination called flow through – that terminology may cause people to freak out. These are just expenses that hit the balance sheet as a reduction in cash or bank account funds. |
|||
AU 1599 | Daily Tasks | 1/9/2008 |
• Brainstorming on chart of accounts. Destinations, categories, groups, sub groups, and types. • Creating new database tables on paper. |
|||
AU 2401 | Tech - Current Chart of Accounts Table & New Changes | 1/9/2008 |
Tech – Current Chart of Accounts Table and new changes as of 1/9/08 (Please see scan in photo gallery) |
|||
AU 2424 | Daily Ideas | 1/9/2008 |
Questions for Steve: - What are some good default categories, groups, and types? - What about Inventory & Cost of Sales? Where do we get these from? What do we call them? - What about digital signatures? Security? Multi sigs? Custom work rate? - What about logos on checks? Customer work rate? - What about Deposit Types? Where do they show up (if anywhere)? What would be their destination, category, group, etc.? (Assets or Income or Special Income) New Ideas: - Bank statements need to have a photo gallery maybe tie to a new permission also may need statement #’s along with it - Max of 2 signatures per check - Max of 4 approvals on a check – each person will have their own checkbox - Photo gallery on all balance sheet items (PO’s as well) - On special deposits and special expenses we may need to allow an auto verify to help bank accounts - Need a special clean-up report: o Dup checks o Dup deposits o Dup expenses o Etc. - On Amortization schedule need months, percentage, principal, first payment date - Goes on top of income statement: o Bad debt o Total sales – bad debt = adjusted income - Amex is similar to bad debt. It needs to be an adjustment to total revenue. Make a special account for each corp and lock it down/ - Split deposits between stores – user’s request - Invoice/deposit types instead of deposit types - Add a flag so that it checks between invoice and stock details - Kill the part “other” – too open |
|||
AU 1600 | Daily Tasks | 1/10/2008 | • Went into Steve’s house for an all-day brainstorming session on chart of accounts and balance sheet items. 10 miles. | |||
AU 1601 | Daily Tasks | 1/14/2008 |
• PCI Compliance stuff for LTF. • Working on account types and destinations. • Had a meeting with Steve to go over accounts. 10 miles. |
|||
AU 1602 | Daily Tasks | 1/21/2008 | • Working on account types and default groups and sub groups. | |||
AU 1603 | Daily Tasks | 1/22/2008 |
• Working on default types. • Started an add/edit pages for groupings. |
|||
AU 1604 | Daily Tasks | 1/23/2008 | • Working on add/edit pages for account groupings. | |||
AU 1605 | Daily Tasks | 1/24/2008 |
• Getting LTF disks ready for a contact. • Talking a client about the web site layout. • Small bug fix on manager’s checkbook. • Working on groupings and chart of accounts. |
|||
AU 1606 | Daily Tasks | 1/25/2008 | • Went in to meet with Steve. Went over new changes and ran a scenario on land properties. 10 miles. | |||
AU 1607 | Daily Tasks | 1/28/2008 |
• Working on splitting deposits. • Moved the store id from the main to the line items. |
|||
AU 1608 | Daily Tasks | 1/29/2008 |
• Adding xss validation to pages. • Added a target percentage. • Started working on new income statement search form. |
|||
AU 2425 | Daily Ideas | 1/29/2008 |
-Add the ssl link on all user and bank pages ‘https://’ -On permissions add some speed set ups -Hide some of the stuff on the models page for specific units -On all state look-ups I need Mexico and other international check zip codes -On Income Statement – have form and then other report page. Still need: year to date button & button for quick look – main groupings, sub groups, expanded -On main groups add a field for target percentage |
|||
AU 1609 | Daily Tasks | 1/30/2008 | • Working on the new income statement. | |||
AU 2426 | Daily Ideas | 1/30/2008 |
Revenue: - Invoices: o Units o Parts o Labor o Rental o Warranties - Loop over all hardcoded parts Other Revenue: - Non sales related deposits Total Revenue: Revenue Adjustments: - Trade-in adjustments - Negative deposits Total Adjusted Revenue COGS - Units - Parts - Labor - Rental - Warranties - Loop over all hardcoded - Special COGS from expense line items GP Revenue: - Inventory Type o Sub Inventory Type • Make Expenses: - Group o Sub Group • Type |
|||
AU 1610 | Daily Tasks | 1/31/2008 |
• Took off the hacker safe logo and control scan logos from the LTF website. • Working on the new income statement. • Steve called and I gave him an update as to the progress. |
|||