For job costing... E/R line items - already EOT's - main EOT's - sub dates and time - need two new columns in the database - see table time_sub_dates - new column invoice_number int(10) unsigned default 0 indexed - new column total_time decimal(10,2) unsigned default 0.00 (this is the aggergate - add code to the action for adds and edits) Invoice line items - already - db has the field - need to show on add/edit - need to show on printable - may need options for searching - he would like to look at a graph... what has been billed and what has been billed - he would also like to see a graph... what has been paid and what hasn't bee paid - almost a mini P&L per job (per EOT) - we talked about Drew and the Pool company - he uses locations - we want to use EOT's - Drew can use locations to get a mini P&L per job (loc). we want the same thing using EOT's. - real time as it happens - cost plus stuff - sometimes, the costs may change on the fly, if needed - eventually, he may want full disbatching and what jobs, equipment, labor, costs, e/r's, invoices, timecards, etc. - they need some control over the expenses and invoices (manual changes allowed) - we looked at Additional Tie-In's/Assignments/Pools ("any" person, place, or thing) - Subs - help file - https://data0.adilas.biz/top_secret/help.cfm?id=391&pwd=sub - this could be a later thing - lots of potential here - this could be tied to the time_sub_special_flags table - the pools deal with these table... - time_sub_pools, time_sub_pool_assignments, time_sub_assignments