Print Format in erpnext

[Uyya_Vaijeyanthi_Bal]

ya in address there is no item.
I want to fetch list of Item from Item Doctype

[kolate_sambhaji]

Do you have any reference of item in Address Template.
What is your use-case?

[Uyya_Vaijeyanthi_Bal]

No dont have any reference.
Give me a sample to fetch from another doctype with reference

[kolate_sambhaji]

@kolate_sambhaji

frappe.db.get_value(‘Customer’, doc.customer, ‘credit_days’)

here doc.customer is reference.

[Uyya_Vaijeyanthi_Bal]

{{ frappe.db.get_value(‘Customer’, doc.customer, ‘customer_type’) }}

I have given this in address doctype
Im getting error as
Traceback (innermost last):
File “/home/vaijeyanthi/frappe-bench/apps/frappe/frappe/app.py”, line 51, in application
response = frappe.handler.handle()
File “/home/vaijeyanthi/frappe-bench/apps/frappe/frappe/handler.py”, line 69, in handle
execute_cmd(cmd)
File “/home/vaijeyanthi/frappe-bench/apps/frappe/frappe/handler.py”, line 92, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/vaijeyanthi/frappe-bench/apps/frappe/frappe/init.py”, line 751, in call
return fn(*args, **newargs)
File “/home/vaijeyanthi/frappe-bench/apps/frappe/frappe/templates/pages/print.py”, line 107, in get_html
html = template.render(args, filters={“len”: len})
File “/home/vaijeyanthi/frappe-bench/env/local/lib/python2.7/site-packages/jinja2/environment.py”, line 969, in render
return self.environment.handle_exception(exc_info, True)
File “/home/vaijeyanthi/frappe-bench/env/local/lib/python2.7/site-packages/jinja2/environment.py”, line 742, in handle_exception
reraise(exc_type, exc_value, tb)
File “”, line 1, in template
TemplateSyntaxError: unexpected char u’&’ at 103

[kolate_sambhaji]

please remove curly brackets,

frappe.db.get_value('Customer', doc.customer, 'customer_type')

[kolate_sambhaji]

Can you share your print format?

[Uyya_Vaijeyanthi_Bal]

if i remove curley brackets. it just printing

  frappe.db.get_value('Customer', doc.customer, 'customer_type')

the same

[kolate_sambhaji]

can you share your print format?

[Uyya_Vaijeyanthi_Bal]

[kolate_sambhaji]

@Uyya_Vaijeyanthi_Bal

frappe.db.get_value(‘Customer’, doc.customer, ‘customer_type’)

Ohh, you are using print format builder.
Please check my images

Steps:

1. in print format builder UI, Drag Custom HTML into location you want to print.
2. Click on Edit Html
3. write this code {{ frappe.db.get_value(‘Customer’, doc.customer, ‘customer_type’) }}
4. refresh your print format. This will show customer details as Individual

[Uyya_Vaijeyanthi_Bal]

Ok … Thankyou… Its working

[Rohan_J]

@kolate_sambhaji: Hi Sambhaji,

I have address as a linked field in a doctype. All entries made while filling this DocType are storedas entries under “Address” DocType. When I want to print our the entire address in the print, how do I reference the particular address that is linked to this document? I hope this makes sense.

[kolate_sambhaji]

@Rohan_J You need to fetch address using Address template, then you can print it.

e.g.1 purchase common.js
//on selecting address in shipping_address full address is copied into shipping_address_display

	shipping_address: function(){
		var me = this;
		erpnext.utils.get_address_display(this.frm, "shipping_address",
			"shipping_address_display", is_your_company_address=true)
	},

e.g.2

cur_frm.cscript.buyer = function() {
  erpnext.utils.get_address_display(this.frm, "buyer", "buyer_address");
}; 

//buyer is address field, and on select of buyer, I am fetching full address in buyer_address

[Mukesh_Variyani]

Hi @kolate_sambhaji,

“get_address_display” is not working in v8, can you suggest changed method for v8?

Thanks

Edit: found the solution
Replace: erpnext.utils.get_address_display
with : frappe.geo.doctype.address.address.get_address_display

[krishnanhemanth]

Hi @kolate_sambhaji
I am trying to create custom reports
any reference where i can start learning
what all language should i know
thanks
hemanth

[clarkej]

Welcome krishnanhemanth

There’s this if you have not seen it

https://frappe.github.io/erpnext/user/manual/en/customize-erpnext/articles/making-custom-reports-in-erpnext

[krishnanhemanth]

Thanks for the reply clarkej
iam building custom reports for printing
for example sales invoice wrt my company standards
i go to customise
then pick or delete elements and click update
but nothing gets updated in the print
dont know whats wrong
hemanth

[krishnanhemanth]

Hi clarkej
Begining to get a feel of this
iam attaching a sample invoice
i want to get the bottom elements into the main section

how do i do it
plz help
regards
Hemanth

[clarkej]

Is that possibly an Item line item element from an Items table?

I seek working examples to learn how the Items table works.

I found these for ideas

Item custom field in Invoice

Hi there, I was able to customize ErpNext Stock>Item and have added Item_Type and Item_Color fields. This is working well and now I have items with these details in ErpNext. But when I sell these items, I want these item details to also show up in the Invoice. The Item table does not show these custom fields. Could someone tell me how the custom field data can be available else where in ErpNext?

Item Table in Quotation - Total Issue

Hi @Sumit_Arora, System uses the the table which has fieldname items, check below code You have to make changes in this file and making changes in this file will broke your application. Can you share the case study to add new child table Quotation Item which is already there on the Quotation?

Have you any favourite pointers to share?