I want to do something like this…
si = frappe.get_doc(“Sales Invoice”,sale_invoice.name)
si.update({“update_stock”:1 })
if si.sales_account == ‘’:
si.update({“sales_account”:si.items[0].income_account})
cmp_abbr_by_name = frappe.db.sql(“”“SELECT abbr FROM tabCompany
WHERE name = %s”“”,si.company, as_dict = 1)
abbr = cmp_abbr_by_name[0].abbr
for item in si.items:
item.update({“warehouse”:"Finished Goods - " + abbr})
si.save()
si.submit()