On 7-May-09, at 2:37 PM, Ron Stone wrote:
> Yes, always the full quantity, unless I somehow overtyped something.
> I'll double check against invoices.
You can try this SQL:
SELECT
egw_pm_elements.pe_title,
SUM(quantity) AS invoiced_quantity,
SUM(egw_pm_elements.pe_used_quantity) AS used_quantity
FROM perp_invoice_line
JOIN egw_pm_elements ON
perp_invoice_line.invoicable_class =
'ProjectManagerInvoicable' AND
perp_invoice_line.invoicable_id = egw_pm_elements.pm_id AND
perp_invoice_line.invoicable_item_line = egw_pm_elements.pe_id
GROUP BY invoicable_class, invoicable_id, invoicable_item_line
HAVING invoiced_quantity != used_quantity
Anything that shows up was only partially invoiced.
> It may be that the problem you described below is unrelated, but I'd
> be happy to test a solution against the behavior I see.
You can try SVN r 3460, but if there aren't any partially invoiced
elements, it won't help.
http://perp.svn.sourceforge.net/viewvc/perp/trunk/perp_ar/inc/class.ProjectManagerInvoicableItem.inc.php?revision=3460&pathrev=3460Nathan Gray
nathan at goarctic dot com
------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled.
http://p.sf.net/sfu/kodak-com_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers
