adjusts query so multiple plans can be used to create single invoice
diff --git a/erpnext/accounts/doctype/subscriptions/subscriptions.py b/erpnext/accounts/doctype/subscriptions/subscriptions.py
index bee1a05..6cd8934 100644
--- a/erpnext/accounts/doctype/subscriptions/subscriptions.py
+++ b/erpnext/accounts/doctype/subscriptions/subscriptions.py
@@ -158,8 +158,8 @@
if plan_items:
item_names = frappe.db.sql(
- 'select item as item_code, cost as rate from `tabSubscription Plan` where name=%s',
- plan_items, as_dict=1
+ 'select item as item_code, cost as rate from `tabSubscription Plan` where name in %s',
+ (plan_items,), as_dict=1
)
return item_names