fix: use correct field name in accounts controller (#39884)
Changes to get advance payments in SI or PI from JV's
diff --git a/erpnext/controllers/accounts_controller.py b/erpnext/controllers/accounts_controller.py
index 308a134..34eff77 100644
--- a/erpnext/controllers/accounts_controller.py
+++ b/erpnext/controllers/accounts_controller.py
@@ -2691,7 +2691,7 @@
if order_list:
q = q.where(
- (journal_acc.reference_type == order_doctype) & ((journal_acc.reference_type).isin(order_list))
+ (journal_acc.reference_type == order_doctype) & ((journal_acc.reference_name).isin(order_list))
)
q = q.orderby(journal_entry.posting_date)