Adilas.biz Developer's Notebook Report - 2/1/2007 to 2/28/2007 - (22)
|
||||||
Photos
|
Time Id | Color | Title/Caption | Start Date | Notes | |
AU 3031 | Daily Tasks | 2/6/2007 | • Changes to help with the add/edit payee pages. Created a round trip for add/edit customers. | |||
AU 3032 | Daily Tasks | 2/7/2007 |
• Working on MSAI stuff. • Added banks and transaction #’s to receipts. • Add 1099 flags and account #’s to payees. |
|||
AU 3047 | Daily Ideas | 2/7/2007 |
To Do on the Database: - Change bank 50 to “void” and corp to 1 - Change bank 51 to corp 1 - Change store 22 to “void” and corp to 1 and store name to blank - Change store 61 to corp 1 - Change chart of account 649 to “void” and “void” and corp to 1 - Add a history flag for void (should be #9) - Add bank_id int(10)1 to receipts, index it - Add transaction number var(50) to receipts - Change bank 7 to “No Bank Assigned” – also change other fields - Add payee_account_number to payee var(50) - Add payee 1099 tinyint(1)0 to payee - Run extras/update_receipt_banks.cfm |
|||
AU 3033 | Daily Tasks | 2/8/2007 |
• Working on files for Morning Star. • Added banks, transaction #’s, and navigation links. • Add a void feature to deposits and receipts. Also added some round trip editing for account types. |
|||
AU 3034 | Daily Tasks | 2/9/2007 |
• Working on the new report for account totals. • Uploaded files for Steve to see and use. Temporary. |
|||
AU 3035 | Daily Tasks | 2/12/2007 | • Working on the new reports. The old way works but was slow and cumbersome. Working on speeding up the reports. | |||
AU 3048 | Daily Ideas | 2/12/2007 |
-Works but is intense – currently big query, no grouping. Outer loop about (150 records), inner loop (10-15 records). Problem = cf query timeouts -New idea – All-All -Grab 3 different queries for verified, pending, totals -Select SUM(line) as line-sum, chart of account id, store id -From, where, group by chart of account id & store id, order by -Deposit store amount date verified age – links -Expense vendor amount money check trans date verified age - links |
|||
AU 3036 | Daily Tasks | 2/13/2007 |
• Reworked the expenses and receipt totals report. Posted new files online, tested and added help files. • Working on the verify bank report. Created new pages and added new search options to existing pages. Posted files and updated help files. |
|||
AU 3037 | Daily Tasks | 2/14/2007 | • Working on deposit totals and posting files online. On the phone with Steve. | |||
AU 3038 | Daily Tasks | 2/15/2007 | • Fixing help files for MSAI and checking files online. | |||
AU 3039 | Daily Tasks | 2/19/2007 |
• Working on the page to help split receipts between stores. • Page was preset percentages and calculates the break down on the fly. |
|||
AU 3040 | Daily Tasks | 2/20/2007 |
• Working on split receipts and showing recent activity for each vendor/payee. • Posted files, tested, and worked on updating help files. |
|||
AU 3049 | Daily Ideas | 2/20/2007 |
Keep it simple – take anything out of inventory: 1. Who we are selling to 2. What are we selling them 3. How they are paying 4. Printing and paperwork 5. Accounts receivable – goes into the A/R account and the pull out of the A/R account Big AR - Corp - Store - Salesperson - Individuals/vendors/customers (these two are not together but may swap rank) - Invoices – this needs to be aged out oldest to newest (these two are not together but may swap rank) |
|||
AU 3041 | Daily Tasks | 2/21/2007 |
• Meeting with Steve about where we are headed next with the new application. We went over invoices and accounts receivable. • Quick changes to pagination numbers and calling Crystal Tech about server slowdowns. • Working on the receipt reimbursement section. |
|||
AU 3042 | Daily Tasks | 2/22/2007 | • Working on the reimbursement section of the MSAI website. | |||
AU 3043 | Daily Tasks | 2/23/2007 |
• Working on the reimbursement pages. Posted files and updates help files. • Went into MSAI and showed the girls the new reimbursement pages and flow. 10 miles. • Reading up on java script and using java script with Cold Fusion. |
|||
AU 3050 | Daily Ideas | 2/23/2007 | -Add a lock all checkbox to the lock the line items | |||
AU 3044 | Daily Tasks | 2/26/2007 | • Working on using Cold Fusion and java script to help with locking the line items. Posted new files online. | |||
AU 3045 | Daily Tasks | 2/27/2007 | • Updating migration pages. Getting back into the swing of things with the system. Started the sold reports. | |||
AU 3051 | Daily Ideas | 2/27/2007 |
Blank field – what is your dream? - Build - Grow - Develop - Leave it alone - Paint - Persevere - Enjoy - Sell - Give - Sub/divide - Study - Get help - Grants - Hobby it - Filler store - Mix and match |
|||
AU 3046 | Daily Tasks | 2/28/2007 |
• On the phone with Steve going over things. Talked about schedules and creating the final post for deposits and expenses. • Working on sold reports and other application changes. Posted a few changes dealing with corp users and user lists. |
|||
AU 3052 | Daily Ideas | 2/28/2007 |
System Sketch: Please see scan in photo gallery Inventory – units, parts, & service – the central hub, then connecting out from there - Customers o Quotes o Contact log - Reports o Inventory o Sold o Individual look up o Profit - Photos - Deposits o Posting - Receipts o Posting - Invoices o Printing paperwork - Taxes - Payroll - Floorplan - Maintenance & Subs - Accounting o Balance sheet - Report Builder - Special Search - Migration - Clean-up - Payees & Permissions o Vendors o Clock in/out |
|||