Sales Invoice Timesheet Group by

ERPNext Selling/CRM
1

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.

2

Hi,
I think you are displaying result in child table through Sql query

if yes,then
Use following in sql query-

select sum(billing_hrs), timesheet
group by timesheet

Shraddha Ranjane,
Indictrans

3

Hi @shraddha,

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 into
Setup->Custom Script>Sales Invoice-Client?