rate = frappe.db.get_all('Purchase Invoice Item', filters={'item_code': 'TEST_DEMO'}, fields=['rate'], limit=1, order_by='creation desc')
if rate:
item_rate = rate[0]['rate']
else:
item_rate = 0 # Provide a default value if the record is not found
@Omar_Mohammed try this : rate=frappe.db.sql("Select rate from ``tabPuchase Invoice Item`` where item_code=%(item)s order by creation limit 1 " ,values={"item":"TEST_DEMO"})[0]