Adilas.biz Developer's Notebook Report - 12/1/2008 to 12/31/2008 - (33)
|
||||||
Photos
|
Time Id | Color | Title/Caption | Start Date | Notes | |
AU 2688 | Daily Tasks | 12/1/2008 |
• Working on the bulk verify deposits section. • Posted files, updated help files and emailed updates to accounting associates. |
|||
AU 2712 | Daily Ideas | 12/1/2008 |
On bulk verify: • Add a date range • Add a next n on the bottom |
|||
AU 2417 | Tech & Brainstorming - Balance Sheet Tables & Sample Groupings | 12/2/2008 |
Sample Balance Sheet Groupings: Destination: Balance Sheet Category: Assets (Groups & Sub Groups) - Current Assets: o Cash/bank Accounts o Petty Cash o Inventory o Accounts Receivable o Other Current Assets - Long-Term Assets (Fixed): o Fixed Assets o Equipment o Tools o Buildings o Real Estate o Other Assets o Accumulated Depreciation Category: Liabilities (Groups & Sub Groups) - Current Liabilities o Accounts Payable o Other Current Liabilities - Long-Term Liabilities o Long-Term Accounts Payable o Loans/Notes Payable o Other Liabilities Category: Equity (Groups & Sub Groups) - Capital o Paid in Capital - Other Equity o Net Profit o Retained Earnings o Distributions (Please see diagram on scan in photo gallery) Balance Sheet Subs & Items Planning (Please see scans in photo gallery) Finished Balance Sheet Items Tables with subs: Page was originally started on 11/12/08 Balance Sheet Items Table Balance System Type Table Balance Sheet History Table Balance Sheet Subs Balance System Types (Please see scan in photo gallery) |
|||
AU 2689 | Daily Tasks | 12/2/2008 |
• Went in to Steve’s house to brainstorm on balance sheet items. • Talked about me going in the field more. 10 miles. • Working on balance sheet groupings and stuff. |
|||
AU 2418 | Brainstorming - Balance Sheet Items & Steps in Starting a New Corp | 12/3/2008 |
Requirements for Creating a Balance Sheet Item: - Must have a bank - Must have balance sheet items turned on o This is where I will create the system defaults o First check and then create if needed System Generated B.S. Items: - B.S. – Assets – Current Assets – Cash/Bank Accounts o Each bank account name (dynamic) - B.S. – Assets – Current Assets – Petty Cash o Each active location with a positive petty cash value (dynamic) - B.S. – Assets – Current Assets – Inventory o Each vendor for parts (dynamic) o Each make for units (dynamic) o ??? does inventory go with current assets or by itself under B.S. – Assets – Inventory • Then grouped by inventory type • Parts by part category and then vendor • Units by make - B.S. – Assets – Current Assets – Accounts Receivable - B.S. – Liabilities – Current Liabilities – Accounts Payable - B.S. – Equity – Other Equity – Net Profit - Others: REI’s, Units, PO’s, Floorplan, Payroll - Keep a record of crop B.S. groupings and id number. This will help when system creates new system B.S. item. If everything starts at zero… only add as needed Steps that a new corp makes: 1. New corp - No B.S. items created 2. Assign new corp to inventory types - If assigned to B.S. inventory types - Set up all defaults groups, sub groups, etc. 3. On locations, watch for petty cash values - If yes, create B.S. item 4. On banks, watch for new banks - If yes, create a B.S. items 5. On units, watch for new items - B.S. item 6. On parts, watch for abnormal part (unlimited don’t count) this may be part of a P.O. or a standalone part. It really doesn’t count until it gets brought into inventory. - (5 & 6 – could be multiple on a per vendor or per make basis) 7. On PO’s – watch for 1st PO 8. On units, watch for 1st floorplan item 9. On e/r watch for 1st Split 10. On e/r watch for 1st REI 11. On invoices watch for 1st unpaid invoice |
|||
AU 2690 | Daily Tasks | 12/3/2008 |
• Brainstorming on balance sheet items. • On the phone with Steve going over brainstorming ideas. • Small help file update. |
|||
AU 2691 | Daily Tasks | 12/4/2008 |
• On the phone with Steve going over options for web services. • Working on the part id # conversion. The old way was to use a vendor and part number as the main key. The new way is to use the part id (single number) as the key id. |
|||
AU 2419 | Note - On the Balance Sheet | 12/5/2008 |
Ideas about the balance sheet and how we provide the tools but we let the users make the final call. Very similar to the B.S. round 1, we need to pull back everything we can for the users. We also need to leave some flexibility into the tool or builder. Options on round 1 that are pretty cool: - Pulls back data into a giant form - Items may be added/edited/combined/shown/hidden/etc. - All refreshed are done on the form page. The actual report page is just changes and data from the form. No calcs are done on the actual report page. All it does (the report) is bring the data (form) forward and format it. Options on round 2 that would make it cool: - Local java script to help with calcs - Allow for sort # to be changed on the fly - Button for show/save as pdf - Maybe when we save as a pdf, allow them to save a physical copy online and that becomes the history or archived copy. o This could make the database table really small – just record the date, the pdf name and loc, and the name of balance sheet. Let the users browse their saved and archived copies at any time. o Small server load. All we do is pull up a saved pdf and show it. We don’t even car what it has on it. No calcs, no drill-downs, no look back on the database. It is what it is… |
|||
AU 2692 | Daily Tasks | 12/5/2008 |
• Brainstorming on balance sheet items and how to tie-in update PO’s. • Also spend some time documenting ideas on what kind of tool to make the balance sheet report and how to use pdf docs as the archived copy. Definitely had some inspiration here. • Working on the part id conversion. |
|||
AU 2693 | Daily Tasks | 12/8/2008 |
• Working on the conversion between part number and vendor id (old combo) to the view part id #. • Also spent some time monitoring server status and emailing Crystal Tech. |
|||
AU 2694 | Daily Tasks | 12/9/2008 |
• Worked on update PO’s and repopulating actual costs on old update PO’s. • On the phone with Steve going over clients, options, pricing, web services, custom code, etc. Over an hour on the phone. |
|||
AU 2695 | Daily Tasks | 12/10/2008 |
• Up early (2:00am) to post files. • Posted, updated, and tested. • Pulled down a copy of the adilas database. Added a part status option to the parts table and part searches. Posted files online. • On the phone with Steve a couple of times. Talked about new updates and needing a possible hybrid system (use of technologies) to make everything work. • Added the part id to the check parts method to help prompt when editing old part #’s. |
|||
AU 2420 | Tech - Balance Sheet Tables | 12/11/2008 |
Tech – Balance Sheet Tables Balance Sheet Photos Table Balance Sheet Archives Table (Please see scan in photo gallery) On inventory look-backs: - Maybe use reverse filters. Do a quick simple search (counter only) to see if there are more records before or behind. This could easily be translated into something… IN (value) or something… NOT IN (value) |
|||
AU 2696 | Daily Tasks | 12/11/2008 |
• Small help file update. • Also added a new error message if changing part #’s. • Brainstormed on balance sheet items. • Built six new tables to hold balance sheet items. • On the phone with Steve. |
|||
AU 2697 | Daily Tasks | 12/12/2008 | • Working on a new alpha sort order for reimbursements and splits. | |||
AU 2698 | Daily Tasks | 12/13/2008 |
• Finished up the new alpha sort order for reimbursements, splits, and PO’s. • Fixed some math calc problems. Tried to post files but had major internet problems. • Went in to town to use the internet and got things to work. I spent almost 3 hours trying to get files posted. In the mean-time, the adilas application was down (partially). 10 miles. • Sent an email update to Steve about uploading problem. • Worked on creating balance sheet groupings. |
|||
AU 2699 | Daily Tasks | 12/15/2008 |
• Working on default grouping for balance sheet items. • Working add/edit grouping page. Changed the dates on the deposit and receipt totals page. • Added sort options for groups, sub groups, and types. • Other changes to help with flow. |
|||
AU 2700 | Daily Tasks | 12/16/2008 | • Working on the add/edit balance sheet pages. | |||
AU 2701 | Daily Tasks | 12/17/2008 |
• Working on balance sheet items. • Started pulling in system generated balance sheet items. |
|||
AU 2702 | Daily Tasks | 12/18/2008 |
• Working on balance sheet inventory reports (dynamic look-back reports). • On the phone with Steve going over manufacturing stuff and research on SQL joins and sub queries. • More research on advanced join and unions. • Spent some time playing with SQL concepts. |
|||
AU 2713 | Daily Ideas | 12/18/2008 |
On balance sheet items – what are the goals for parts • Qty, cost – what do I have left? – I don’t care how much is still there; I only want what is left and how much it is worth. |
|||
AU 2703 | Daily Tasks | 12/19/2008 | • SQL research. I think that I need to add a date to the PO and invoice line items table. | |||
AU 2704 | Daily Tasks | 12/20/2008 |
• Went in to work with Steve on balance sheet items. Brainstorming and talking about a business plan. 10 miles. • Updated all of the add and edit pages that deal with date stamping the PO/invoice line items. This is for date sensitive quantity tracking. |
|||
AU 2714 | Daily Ideas | 12/20/2008 |
-Create (user only) windows into e/r’s and statements and deposits and invoices and quotes – everything – just their stuff – personal sandbox. -Add a monthly acceptance screen. –Date stamp it and only show once per month. -Be able to get at their own data – back-up and on extraction tool. -Later on – when tying in b.s. items – prompt for action – the action is a form with check boxes and valves – let them choose destinations and values. Do the math and make sure they match. -On an edit, prompt for action – show relations and destinations and prompt for action. May need to use a remove only permission compared with an edit/update. Keep it clean. -Super simple black and white invoice and quote – super printer friendly. -Show stats per corp “database stuff” – tie into corp history – maybe two different things corp history and user history - Lines - Items - Values - tables -On corp history show a break down for a week at a time (default) - x # of invoices - x # of PO’s - x # of Deposits - x # of E/R’s - x # of Customers - x # of Vendors - x # of users - x # of locations Start basic and then show more details on the drill downs. For example, maybe a week’s worth of data is being shown; allow the user to filter by user (default to all or corp level). |
|||
AU 2705 | Daily Tasks | 12/22/2008 |
• Working on system balance sheet items. • Worked on unit group reports and inventory drill-downs. • Started on parts inventory drill-downs. |
|||
AU 2706 | Daily Tasks | 12/23/2008 | • Working on accounts receivable drill-downs and started on accounts payable drill-downs for balance sheet items. | |||
AU 2707 | Daily Tasks | 12/24/2008 | • Working on accounts receivable drill-downs and started on accounts payable drill-downs for balance sheet items. | |||
AU 2708 | Daily Tasks | 12/26/2008 |
• Worked on b.s. and payables drill-downs. • Steve came over and we went over balance sheet items and direction. • Changed the main page to allow a checkbox interface to select either assets, liabilities, or equity. |
|||
AU 2709 | Daily Tasks | 12/29/2008 |
• Prep for meeting with clients • Went out to a client’s house to do some consulting. Visited with them about changes and new options. 15 miles. • Working on 2009 tax tables. Both state and federal tax calcs. |
|||
AU 2710 | Daily Tasks | 12/30/2008 | • Checking into a problem with reimbursements. | |||
AU 2711 | Daily Tasks | 12/31/2008 |
• Working on 2009 tax tables and balance sheet stuff. • Worked on tying in locations to payables. |
|||
AU 2715 | Daily Ideas | 12/31/2008 |
-Current project – current feature project -On main home page – below text – have link to current featured project -Phase – category (name), most recent photos 1st -Photo management -New photos for home page – they will send before the bottom red line -Click here to order a free sample pack of floorplans. Email and data storage. Name, address, phone #, email, style checkboxes. -Email client with how to get at stats -Search engine optimization |
|||
AU 3560 | 2008 | 12/31/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. |
|||