I would like to create “last price” column on Sales Invoice (pt-br: “ultimo preço”) that shows last price for that item, for that customer.
Is it possible to achieve that by script?
I was trying to use
get_value(doctype, fieldname, filters=None, as_dict=True, debug=False, parent=None)
but I’m struggling at filtering by parent’s field ‘customer’:
it would be something like:
doctype: "Sales Invoice Item" fieldname: "rate" filters: [ ["item_name", "=", itemName] //something to access parent and filter by "customer" ]
Do you have any suggestion? I saw something about someone creating new field on child that fetches customer from parent… but it may limit some uses… Thanks in advance!