Print issue {{ frappe.db.get_value("Customer", doc.customer, "tax_id") }}

Frappe Framework Print Formats
1

i using
TRN#: {{ frappe.db.get_value(“Customer”, doc.customer, “tax_id”) }}
and
Customer#:{{ frappe.db.get_value(“Customer”, doc.customer, “customer_code”) }}

They are displaying in erpnext like

44
442446×1314 281 KB

But when i output pdf, these two fields display “None”
59
591526×962 121 KB

How to make the value can be displayed in pdf.

My system is:
ERPNext: v11.1.44 (master)
Frappe Framework: v11.1.39 (master)

1 Like
2

Try this …
edit the site_config.json, and add the static IP address of your local server.

eg.
“host_name”: “http://192.168.1.111”
then do a bench restart

3

thank you for your reply.
Now in my site_config.json
“host_name”: “https://erp.manchemical.com”,

so now if i change to static IP,like http://192.168.1.111

Is there any other problem happen?

4

i did two trials:
“host_name”: “http://localhost”,
and
“host_name”: “http://192.168.1.111”,

the same problem, in erpnext, ok, but display “none” in pdf.

5

You need to adjust the IP address to match your requirements - I just used 192.168.1.111 as an example

6

i think i using http://localhost is the same function as static ip, right?
Now localhost is not working for solving this issue.

7

If you have an entry in the /etc/hosts file that matches the IP of your machine, then it should also work, so like this (but change the xxx to match the actual IP)

127.0.0.1 localhost
192.168.1.xxx erp.manchemical.com

8

now in my /etc/hosts:

127.0.1.1 manchemical.com manchemical
127.0.0.1 localhost

So i need to add 192.168.1.xxx erp.manchemical.com, or change
127.0.1.1 manchemical.com manchemical?

9

Now I add 167.xx.68.6 erp.manchemical.com:
So it looks like:

127.0.1.1 manchemical.com manchemical
127.0.0.1 localhost
167.xx.68.6 erp.manchemical.com

167.xx.68.6 is my server ip.

10

but still display “none” in pdf.

11

just now even i change
“host_name”: “https://167.xx.68.6” in site_config.json
and bench restart.

Still “none” in pdf.

sorry, i am fresh in erpnext, and appreciated to help me, please help me to solve this issue!

12

Did you create a report builder version, or is this a Jinja2 output?

13

i dont know, i installed original erpnext.

14

How is this even related?

15

Check if the customer has that data. I will provide a sample below with even additional custom fields:
{%- if frappe.db.get_value(“Customer”, doc.customer, “customer_type”) == “Individual” -%}
{%- if frappe.db.get_value(“Customer”, doc.customer, “tax_id”) -%}{{ frappe.db.get_value(“Customer”, doc.customer, “tax_id”) }}{%- endif -%}
{%- else -%}
{{ frappe.db.get_value(“Customer”, doc.customer, “tax_office”) }}/{{ frappe.db.get_value(“Customer”, doc.customer, “tax_id”) }}{%- endif -%}

1 Like
16

can try to help if you can post the whole code

18

i tried your code today, still problem.
please check the code here:

<!---Start:Header--->

<div id="header">
<table style="width:100%;margin:0;padding:0; max-width:100%;font-family:verdana; font-size:10px;color:#666">
<tr>
<td colspan="6" style="width:50%;padding-left:10px">TO:</td><td colspan="4" style="width:50%;padding-left:10px">Customer Reference</td>
</tr>
<tr>

<td colspan="6" rowspan="6" style="width:50%;padding-left:10px;font-style:italic;color:#333">{{ doc.customer_name or '' }}<br />{{ doc. address_display or '' }}<br />TRN#:{{ frappe.db.get_value("Customer", doc.customer, "tax_id") }}
 </td>
<td style="padding-left:10px;width:16%">Customer#:</td>
<td align="right" style="width:11%; font-style:italic;color:#333">
{{ frappe.db.get_value("Customer", doc.customer, "customer_code") }}</td>
<td style="padding-left:10px;width:13%">Invoice#:</td>
<td align="right" style="width:10%;font-style:italic;color:#333"><span class="serials">{{ doc.name }}</span></td>
</tr>
<tr>
<td style="padding-left:10px;width:16%">Currency:</td>
<td align="right" style="width:11%;font-style:italic;color:#333">{{ doc. currency or ''}}</td>
<td style="padding-left:10px;width:13%">IncoTerm:</td>
<td align="right" style="width:10%;font-style:italic;color:#333">{{ doc. incoterm or ''}}-{{ doc. incoterm_fill or ''}}</td>
</tr>
<tr>
<td style="padding-left:10px;width:16%">Transport:</td>
<td align="right" style="width:11%;font-style:italic;color:#333">{{ doc. transport or ''}}</td>
<td style="padding-left:10px;width:13%">Lead Time:</td>
<td align="right" style="width:10%;font-style:italic;color:#333">{{ doc. lead_time or '' }}</td>
</tr>
<tr>
<td style="padding-left:10px;width:16%">Prepared By:</td>
 {% if doc.owner -%}
    {% set u = frappe.get_doc("User", doc.owner) %}    {% endif %}       
<td align="right" style="width:11%;font-style:italic;color:#333">{{ u.first_name or ''}}</td>

<td style="padding-left:10px;width:13%">Credit:</td>
<td align="right" style="width:10%;font-style:italic;color:#333">{{ doc.get_formatted("credit_days") or ''}} Days</td>
</tr>
<tr>
 {% if doc.company %}      
    {% set u = frappe.get_doc("Company", doc.company) %}           
{% endif %}
  <td style="padding-left:10px;width:16%">Company:</td>
  <td colspan="3" align="right" style="width:11%;font-style:italic;color:#333"><span style="margin-right: 10px">{{ doc.company or '' }}</span> {{ u.other_company_name or '' }}</td>
  </tr>
<tr>

<td style="padding-left:10px;width:16%">License#: </td>

<td align="right" style="width:11%;font-style:italic;color:#333">{{ u. license_no or '' }}</td>
<td style="padding-left:10px;width:13%">TRN#:</td>
<td align="right" style="width:10%;font-style:italic;color:#333">{{ u. trn_no or '' }}</td>
</tr>
<tr>
{% if doc.contact_person %}      
    {% set u = frappe.get_doc("Contact", doc.contact_person) %}           
{% endif %}
<td style="width:5%;padding-left:20px">Tel:</td>
<td colspan="2" style="width:20%;font-style:italic;color:#333">{{ u.phone or '' }}</td>
<td style="width:5%;padding-left:20px">Fax:</td>
<td colspan="2" style="width:20%;font-style:italic;color:#333">{{ u.fax or '' }}</td>
<td style="padding-left:10px;width:16%">Tel: </td>
{% if doc.company %}      
    {% set u = frappe.get_doc("Company", doc.company) %}           
{% endif %}
<td align="right" style="width:11%;font-style:italic;color:#333">{{ u.phone_no or '' }}</td>
<td style="padding-left:10px;width:13%">Fax:</td>
<td align="right" style="width:10%;font-style:italic;color:#333">{{ u.fax or '' }}</td>
</tr>
<tr>
<td style="width:5%;padding-left:20px">Email:</td>
{% if doc.contact_person %}      
    {% set u = frappe.get_doc("Contact", doc.contact_person) %}           
{% endif %}
<td colspan="5" style="width:45%;font-style:italic;color:#333">{{ u.email_id or '' }}</td>
<td style="padding-left:10px;width:16%">Issued On:</td>
<td align="right" style="width:11%;font-style:italic;color:#333;">{{ doc.get_formatted("transaction_date") or ''}}</td>
<td style="padding-left:10px;width:13%">Overdue:</td>
<td align="right" style="width:10%;font-style:italic;color:#333;">{{ doc.get_formatted("valid_till") or ''}}</td>
</tr>

</table>
</div>

<!---End:Header--->
19

these two place has display issue.

20

what happens when you type the code under bench console?

21

We definitely need the line numbers. We are not personal debuggers.