« Return to Thread: Picking project/timesheet items for invoice
Re: Picking project/timesheet items for invoice
by rstone
::
Rate this Message:
Hi Nathan,
Indeed, I found several timesheet items that were off. The way these happened is that the timesheets were recorded, and then additional work added to the activities. When invoicing, I neglected to change the timesheets, instead making the changes to the invoices directly. So the timesheets were under, not over the invoices. I went through these items and corrected the hours. The SQL no longer finds imballances, but the items still show up in the pick list when creating new invoices. Also, there are other timesheet entries that have been invoiced, were not imballanced, and still show up in the pick list.
Not sure how much that helps. Let me know if there is anything else I can try to help track this down.
Many thanks,
Ron
--
Ron Stone
613 322-1175
Skype: ronstone2000
------------------------------------------------------------------------------
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
Indeed, I found several timesheet items that were off. The way these happened is that the timesheets were recorded, and then additional work added to the activities. When invoicing, I neglected to change the timesheets, instead making the changes to the invoices directly. So the timesheets were under, not over the invoices. I went through these items and corrected the hours. The SQL no longer finds imballances, but the items still show up in the pick list when creating new invoices. Also, there are other timesheet entries that have been invoiced, were not imballanced, and still show up in the pick list.
Not sure how much that helps. Let me know if there is anything else I can try to help track this down.
Many thanks,
Ron
On Thu, May 7, 2009 at 5:03 PM, Nathan Gray <nathan@...> wrote:
You can try this SQL:
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.
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.You can try SVN r 3460, but if there aren't any partially invoiced elements, it won't help.
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.
http://perp.svn.sourceforge.net/viewvc/perp/trunk/perp_ar/inc/class.ProjectManagerInvoicableItem.inc.php?revision=3460&pathrev=3460
Nathan Gray
nathan at goarctic dot com
--
Ron Stone
613 322-1175
Skype: ronstone2000
------------------------------------------------------------------------------
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
« Return to Thread: Picking project/timesheet items for invoice
| Free embeddable forum powered by Nabble | Forum Help |
