Query related material doc

ERPNext
1

Hi, all,
i had created PO using material request…i want show the material request number and the material request name who has requested to that document which is fetch from material request form and want to show in PO format…

2

There must be some material request reference?

use

frappe.db.get_value("doctype", "docname", "fieldname")

to fetch value.

e.g. frappe.db.get_value("Material Request", "MREQ-00001", "required_fieldname")

3

Hi,

i tried this… but still i got error…
here is my code…

imp12.png886×398 9.16 KB

dis got this error:-

imp11.png708×458 24.9 KB

…

4

frappe.db.get_value("Material Request", "Material Request", doc.name)

Incorrect way,

Check this,

frappe.db.get_value(Doctype, docname, required_field)    

e.g.

frappe.db.get_value("Material Request", "MREQ-00001", "name")

In your case, I think material Request reference is in items table
Try this

 frappe.db.get_value("Material Request", doc.items[0].material_request,  "owner")
5

i want show full name of the requested person instead of email id…is it possible…?

6

frappe.db.get_value(“Material Request”, doc.items[0].material_request, “owner”)…its shown email of the requested person…i want to show full name of the requesting person…is it possible?