Dear ERPNext Community,
is there any possibility to change the columns for the Timesheet Table, in a Sales Invoice print format, which is not a custom Format?
It would be also possible to hide the table (as it is not shown in the customization) and just add a new timesheet table which customized columns. But how to remove the standard one without having a custom print format?
I would aprecheate some help. Thank you.
A snip shot of your issue will be helpful.
Right now I am working with this custom print format and instead of just listing the timesheets as a whole I want to only list the timesheet detail single entrys which description:
{% if doc.timesheets -%}
<div style="page-break-after: always"></div>
<div class="timesheets">
<h3>Timesheets</h3>
<div data-fieldname="timesheets" data-fieldtype="Table">
<table class="table table-bordered table-condensed">
<thead>
<tr>
<th style="width: 40px" class="table-sr">{{ _("Sr") }}</th>
<th style="width: 150px;" class="" data-fieldname="timesheets" data-fieldtype="Table">
{{_("Date")}}</th>
<th style="width: 300px;" class="" data-fieldname="timesheets" data-fieldtype="Table">
{{_("Note")}}</th>
<th style="width: 80px;" class="text-right" data-fieldname="timesheets" data-fieldtype="Table">
{{_("Hours")}}</th>
</tr>
</thead>
<tbody>
{% for ts in doc.timesheets | sort(attribute='start_date') %}
{% set timesheet = frappe.get_doc("Timesheet", ts.time_sheet)%}
<tr style="page-break-inside: avoid;">
<td class="table-sr">{{ loop.index }}</td>
<td class="" data-fieldname="timesheets" data-fieldtype="Table">
<div class="value">
{{ timesheet.get_formatted('start_date') }}
</div>
</td>
<td class="" data-fieldname="timesheets" data-fieldtype="Table">
<div class="value">
{{ timesheet.note }}
</div>
</td>
<td class="text-right" data-fieldname="timesheets" data-fieldtype="Table">
<div class="value">
{{ "{:.2f}".format(timesheet.total_billable_hours) | replace(".", ",") }}
</div>
</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
I did not find any solution, solving this without a custom html print format.