Retrieve Item Price object from Price List and Item Code

[wjonatan]

Hi All,

What I am asking is somewhat similar to this discussion.

Price List in BOM Item

Hi Everyone, I want to use Price List in BOM Item Table. But the problem is, I am getting error when I tried to use it. [image] I tried it using the below codes: cur_frm.add_fetch('item_code','price_list_name','buying_price_list') AND I tried: cur_frm.add_fetch('item_code','price_list','buying_price_list') But everytime, when I select an item in the BOM Item, it gives me an error shown below: raceback (innermost last): File “/home/sam/frappe-bench/apps/frappe/frappe/app.py”, line 57, …

In “Sales Order Item” and “Purchase Order Item”, the default is set up to show the actual price for each item entered (based on Price List and Item Code). What I am trying to show is the unique ID of the “Item Price” object, usually ITEM-PRICE-XXXXX.

I understand about using Custom Script and having customized field, but what function is required to search an object (Item Price) based on two objects (Item Code and Price List)? add_fetch can only get data from one object.

Thank you.

Rgds, William