fix: unknown column 'ref_exchange_rate'
diff --git a/erpnext/patches/v13_0/modify_invalid_gain_loss_gl_entries.py b/erpnext/patches/v13_0/modify_invalid_gain_loss_gl_entries.py
index 4781ccb..81b72cf 100644
--- a/erpnext/patches/v13_0/modify_invalid_gain_loss_gl_entries.py
+++ b/erpnext/patches/v13_0/modify_invalid_gain_loss_gl_entries.py
@@ -4,6 +4,9 @@
def execute():
+ frappe.reload_doc('accounts', 'doctype', 'purchase_invoice_advance')
+ frappe.reload_doc('accounts', 'doctype', 'sales_invoice_advance')
+
purchase_invoices = frappe.db.sql("""
select
parenttype as type, parent as name
@@ -35,6 +38,7 @@
doc.docstatus = 2
doc.make_gl_entries()
for advance in doc.advances:
- advance.db_set('exchange_gain_loss', 0, False)
+ if advance.ref_exchange_rate == 1:
+ advance.db_set('exchange_gain_loss', 0, False)
doc.docstatus = 1
doc.make_gl_entries()
\ No newline at end of file