How to Get value from another document in script report?

JackLe · January 7, 2015, 3:55am

I can Get value from another document in Print Format.

frappe.db.get_value("[doctype]", "[name]", "fieldname")

How to Get value from another document in script report ?

rmehta · January 7, 2015, 4:54am

Same script should work. Did you try?

JackLe · January 7, 2015, 8:14am

Thank rmehta.
In General Leger report. in file : general_leger.html
I want to get Addrees company.

<h2 class="text-center">{%= __("Statement of Account") %}</h2>
<h4 class="text-center">{%= filters.account && (filters.account + ", ")  || "" %} {%= filters.company %}</h4>
<h2 class="text-center">{%= frappe.db.get_value("Company", filters.company, "address") %}</h2>

It error.
JackLe

JackLe · January 9, 2015, 2:01am

Hi, rmehta
I want to view company address in Gerneral Leger report. How to do that ?
JackLe

rmehta · January 9, 2015, 6:11am

This is the print format and is generated on the client side. You can’t use python functions here.

Make a letter head based on company name. All letter heads are loaded in boot so you can use:

{%= frappe.boot.letter_heads["my company letterhead"] %}

JackLe · January 10, 2015, 3:34am

Thanks, rmehta.
I don’t understand . Can you explain to me ?.
I want to view company address in Gerneral Leger report.
Can you review some code ?
I think it likes Scrip in Print Format. But I can’t do that.
JackLe,

rmehta · January 12, 2015, 9:01am

What did you not understand? Did you try my suggestion?

JackLe · January 13, 2015, 2:11am

Hi rmehta.

github.com

frappe/erpnext/blob/develop/erpnext/accounts/report/general_ledger/general_ledger.html

<h2 class="text-center">{%= __("Statement of Account") %}</h2>
<h4 class="text-center">
	{% if (filters.party_name) { %}
		{%= filters.party_name %}
	{% } else if (filters.party && filters.party.length) { %}
		{%= filters.party %}
	{% } else if (filters.account) { %}
		{%= filters.account %}
	{% } %}
</h4>

<h6 class="text-center">
	{% if (filters.tax_id) { %}
	{%= __("Tax Id: ")%}	{%= filters.tax_id %}
	{% } %}
</h6>

<h5 class="text-center">
	{%= frappe.datetime.str_to_user(filters.from_date) %}
	{%= __("to") %}

This file has been truncated. show original

I want to view my company address.

How can i do that ?
Jack Le.

rmehta · January 15, 2015, 6:49am

Add your address in your letter head.

Or you can send your company address via boot.py and then access it in the client site at frappe.boot.address

KS_Deal · May 23, 2019, 7:10am

@rmehta I have create python function to get the Customer address from sales Invoice. Now I want to replicate this address in Custom Script Report. I am trying with jinja. but I am not getting address into report.