Sales invoice print format customization

gabtzi · January 7, 2016, 12:15pm

Hi,

I’m trying to change the way my invoices are printed and first I want to disable printing the item description.

If I disable the description field in the items table like this

I lose the whole description column including item_name and item_code.

Any ideas how I can fix that?

I’ve tried setting in customize form various options for, print hide in the corresponding fields and always end up with the same result. Either I show the full description including the other fields, or all the fields disappear.

I have no clue where to look at. Any help is appreciated.

kolate_sambhaji · January 7, 2016, 12:29pm

another way is to create custom print format.

github.com

sbkolate/erpnext_print_format/blob/master/v5/Custom SO.html#L66


      
                  {%- endif -%}
              </div>
                      
          </div>
                  
          <br>
          
          
<table class="table table-condensed table-hover table-bordered">
                  <tr>
                      <th>Sr</th>
                      <th>Description</th>
                      <th class="text-right">Quantity</th>
                      <th class="text-right">Rate</th>
                      <th class="text-right">Amount</th>
                  </tr>
                  {%- for row in doc.items -%}
                  <tr>
                      <td style="width: 3%;">{{ row.idx }}</td>
                      <td style="width: 57%;">
              {% if row.in_format_data("image") and row.get("image") -%}
          <div class="pull-left" style="max-width: 20%; margin-right: 10px;">

This is created in html and jinjha template

Nishant_Jariwala · January 7, 2016, 12:30pm

Hi,
If you have tried customize form various options then as per my experience one more way,i think you have to use cutom print format.
https://frappe.github.io/erpnext/user/manual/en/customize-erpnext/print-format.html

gabtzi · January 7, 2016, 12:39pm

I see, it seems the only way to do it is build the whole invoice template from scratch then without using the builder although the builder looked really nice and I was hoping to avoid it
.
Thank you very much for the links you provided they should help a lot so I’ll go ahead with this solution

However I’m pretty curious why this happens so I tracked down this piece of code in
erpnext/controllers/print_settings.py

doc.hide_in_print_layout = ["item_code", "item_name", "image", "uom", "stock_uom"]

Is there a reason why forcing to hide these 5 columns in print layouts is hardcoded? It should affect all print layouts too the way I see it.