I like the idea of billing via Timesheet, but right now I'm getting a lot of rows in Invoice.How can I group them for example by Timesheet Number? Also I'd like to add a Total Billing Hours.
Any help with script is welcome.
Hi,I think you are displaying result in child table through Sql query
if yes,thenUse following in sql query-
select sum(billing_hrs), timesheet
group by timesheet
thanks for your reply, but the results above is the standard sales invoice output.I think that this code needs to be somehow modified and perhaps placed intoSetup->Custom Script>Sales Invoice-Client?