Search The Adilas.biz Developer's Notebook
Time Period:
Daily (enter the day you want to see)
Monthly
Custom Date Range to
Template Filter:
Color Code:
General Text Filter:

(use a plus "+" sign to separate search terms. ex: jack+jill+hill)
Sort Value:
 
Adilas.biz Developer's Notebook Report - 12/1/2008 to 12/31/2008 - (33)
Photos
Time Id Color Title/Caption Start Date   Notes
Click to view time photos.
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.
 
Click to view time photos.
AU 2712 Daily Ideas 12/1/2008   On bulk verify:
• Add a date range
• Add a next n on the bottom
 
Click to view time photos.
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)
 
Click to view time photos.
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.
 
Click to view time photos.
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
 
Click to view time photos.
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.
 
Click to view time photos.
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.
 
Click to view time photos.
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…
 
Click to view time photos.
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.
 
Click to view time photos.
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.
 
Click to view time photos.
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.
 
Click to view time photos.
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.
 
Click to view time photos.
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)
 
Click to view time photos.
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.
 
Click to view time photos.
AU 2697 Daily Tasks 12/12/2008   • Working on a new alpha sort order for reimbursements and splits.
 
Click to view time photos.
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.
 
Click to view time photos.
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.
 
Click to view time photos.
AU 2700 Daily Tasks 12/16/2008   • Working on the add/edit balance sheet pages.
 
Click to view time photos.
AU 2701 Daily Tasks 12/17/2008   • Working on balance sheet items.
• Started pulling in system generated balance sheet items.
 
Click to view time photos.
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.
 
Click to view time photos.
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.
 
Click to view time photos.
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.
 
Click to view time photos.
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.
 
Click to view time photos.
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).
 
Click to view time photos.
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.
 
Click to view time photos.
AU 2706 Daily Tasks 12/23/2008   • Working on accounts receivable drill-downs and started on accounts payable drill-downs for balance sheet items.
 
Click to view time photos.
AU 2707 Daily Tasks 12/24/2008   • Working on accounts receivable drill-downs and started on accounts payable drill-downs for balance sheet items.
 
Click to view time photos.
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.
 
Click to view time photos.
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.
 
Click to view time photos.
AU 2710 Daily Tasks 12/30/2008   • Checking into a problem with reimbursements.
 
Click to view time photos.
AU 2711 Daily Tasks 12/31/2008   • Working on 2009 tax tables and balance sheet stuff.
• Worked on tying in locations to payables.
 
Click to view time photos.
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
 
Click to view time photos.
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.