I have a client for whom I am doing two projects
…
The client needs a report on total hours/$ billed to date on each project.
I’m having a hard time seeing how to get at this information accurately. I
don’t see an association between line items on invoices and the categories
of the calendar items on which they were based.
Any tips? Is there an SQL tally that would produce the numbers I need?
Project manager can help keep them separate, and performs totaling.
Takes a little extra work though. You might be able to add it in
retroactivly, but I’m not sure how it works with recurring events.
You could write SQL to total it up. Something like:
SELECT SUM(unit_price * quantity), cal_category
FROM perp_invoice_line
LEFT JOIN egw_cal ON
perp_invoice_line.invoicable_class = ‘CalendarInvoicable’ AND
perp_invoice_line.invoicable_id = egw_cal.cal_id
GROUP BY cal_category
Nathan
Simplify data backup and recovery for your virtual environment with vRanger.
Installation’s a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Data protection magic?
Nope - It’s vRanger. Get your free trial download today.
http://p.sf.net/sfu/quest-sfdev2dev
Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers
