[fix] [minor] add customer_name/supplier_name in sales/purchase register
diff --git a/accounts/report/item_wise_purchase_register/item_wise_purchase_register.py b/accounts/report/item_wise_purchase_register/item_wise_purchase_register.py
index f7afb3d..9f5f071 100644
--- a/accounts/report/item_wise_purchase_register/item_wise_purchase_register.py
+++ b/accounts/report/item_wise_purchase_register/item_wise_purchase_register.py
@@ -26,9 +26,9 @@
data = []
for d in item_list:
expense_head = d.expense_head or aii_account_map.get(d.company)
- data.append([d.item_code, d.item_name, d.item_group, d.name, d.posting_date, d.supplier,
- d.credit_to, d.project_name, d.company, d.purchase_order, d.purchase_receipt,
- expense_head, d.qty, d.rate, d.amount])
+ data.append([d.item_code, d.item_name, d.item_group, d.name, d.posting_date,
+ d.supplier_name, d.credit_to, d.project_name, d.company, d.purchase_order,
+ d.purchase_receipt, expense_head, d.qty, d.rate, d.amount])
return columns, data
@@ -59,7 +59,7 @@
return webnotes.conn.sql("""select pi.name, pi.posting_date, pi.credit_to, pi.company,
pi.supplier, pi.remarks, pi_item.item_code, pi_item.item_name, pi_item.item_group,
pi_item.project_name, pi_item.purchase_order, pi_item.purchase_receipt,
- pi_item.expense_head, pi_item.qty, pi_item.rate, pi_item.amount
+ pi_item.expense_head, pi_item.qty, pi_item.rate, pi_item.amount, pi.supplier_name
from `tabPurchase Invoice` pi, `tabPurchase Invoice Item` pi_item
where pi.name = pi_item.parent and pi.docstatus = 1 %s
order by pi.posting_date desc, pi_item.item_code desc""" % conditions, filters, as_dict=1)
diff --git a/accounts/report/item_wise_sales_register/item_wise_sales_register.py b/accounts/report/item_wise_sales_register/item_wise_sales_register.py
index f3ed2a1..4d099e0 100644
--- a/accounts/report/item_wise_sales_register/item_wise_sales_register.py
+++ b/accounts/report/item_wise_sales_register/item_wise_sales_register.py
@@ -16,7 +16,6 @@
from __future__ import unicode_literals
import webnotes
-from webnotes.utils import flt
def execute(filters=None):
if not filters: filters = {}
@@ -26,9 +25,9 @@
data = []
for d in item_list:
- data.append([d.item_code, d.item_name, d.item_group, d.name, d.posting_date, d.customer,
- d.debit_to, d.territory, d.project_name, d.company, d.sales_order, d.delivery_note,
- d.income_account, d.qty, d.basic_rate, d.amount])
+ data.append([d.item_code, d.item_name, d.item_group, d.name, d.posting_date,
+ d.customer_name, d.debit_to, d.territory, d.project_name, d.company, d.sales_order,
+ d.delivery_note, d.income_account, d.qty, d.basic_rate, d.amount])
return columns, data
@@ -61,7 +60,7 @@
return webnotes.conn.sql("""select si.name, si.posting_date, si.debit_to, si.project_name,
si.customer, si.remarks, si.territory, si.company, si_item.item_code, si_item.item_name,
si_item.item_group, si_item.sales_order, si_item.delivery_note, si_item.income_account,
- si_item.qty, si_item.basic_rate, si_item.amount
+ si_item.qty, si_item.basic_rate, si_item.amount, si.customer_name
from `tabSales Invoice` si, `tabSales Invoice Item` si_item
where si.name = si_item.parent and si.docstatus = 1 %s
order by si.posting_date desc, si_item.item_code desc""" % conditions, filters, as_dict=1)
\ No newline at end of file
diff --git a/accounts/report/purchase_register/purchase_register.py b/accounts/report/purchase_register/purchase_register.py
index 6fec660..705a654 100644
--- a/accounts/report/purchase_register/purchase_register.py
+++ b/accounts/report/purchase_register/purchase_register.py
@@ -42,7 +42,7 @@
purchase_receipt = list(set(invoice_po_pr_map.get(inv.name, {}).get("purchase_receipt", [])))
project_name = list(set(invoice_po_pr_map.get(inv.name, {}).get("project_name", [])))
- row = [inv.name, inv.posting_date, inv.supplier, inv.credit_to,
+ row = [inv.name, inv.posting_date, inv.supplier_name, inv.credit_to,
account_map.get(inv.credit_to), ", ".join(project_name), inv.bill_no, inv.bill_date,
inv.remarks, ", ".join(purchase_order), ", ".join(purchase_receipt)]
@@ -68,7 +68,7 @@
def get_columns(invoice_list):
"""return columns based on filters"""
columns = [
- "Invoice:Link/Purchase Invoice:120", "Posting Date:Date:80", "Supplier:Link/Supplier:120",
+ "Invoice:Link/Purchase Invoice:120", "Posting Date:Date:80", "Supplier::120",
"Supplier Account:Link/Account:120", "Account Group:LInk/Account:120",
"Project:Link/Project:80", "Bill No::120", "Bill Date:Date:80", "Remarks::150",
"Purchase Order:Link/Purchase Order:100", "Purchase Receipt:Link/Purchase Receipt:100"
@@ -118,9 +118,8 @@
def get_invoices(filters):
conditions = get_conditions(filters)
- return webnotes.conn.sql("""select name, posting_date, credit_to,
- supplier, bill_no, bill_date, remarks, net_total,
- total_tax, grand_total, outstanding_amount
+ return webnotes.conn.sql("""select name, posting_date, credit_to, supplier, supplier_name,
+ bill_no, bill_date, remarks, net_total, total_tax, grand_total, outstanding_amount
from `tabPurchase Invoice` where docstatus = 1 %s
order by posting_date desc, name desc""" % conditions, filters, as_dict=1)
diff --git a/accounts/report/sales_register/sales_register.py b/accounts/report/sales_register/sales_register.py
index 4c49cc8..2bc2850 100644
--- a/accounts/report/sales_register/sales_register.py
+++ b/accounts/report/sales_register/sales_register.py
@@ -42,7 +42,7 @@
sales_order = list(set(invoice_so_dn_map.get(inv.name, {}).get("sales_order", [])))
delivery_note = list(set(invoice_so_dn_map.get(inv.name, {}).get("delivery_note", [])))
- row = [inv.name, inv.posting_date, inv.customer, inv.debit_to,
+ row = [inv.name, inv.posting_date, inv.customer_name, inv.debit_to,
account_map.get(inv.debit_to), customer_map.get(inv.customer), inv.project_name,
inv.remarks, ", ".join(sales_order), ", ".join(delivery_note)]
@@ -68,7 +68,7 @@
def get_columns(invoice_list):
"""return columns based on filters"""
columns = [
- "Invoice:Link/Sales Invoice:120", "Posting Date:Date:80", "Customer:Link/Customer:120",
+ "Invoice:Link/Sales Invoice:120", "Posting Date:Date:80", "Customer::120",
"Customer Account:Link/Account:120", "Account Group:LInk/Account:120",
"Territory:Link/Territory:80", "Project:Link/Project:80",
"Remarks::150", "Sales Order:Link/Sales Order:100", "Delivery Note:Link/Delivery Note:100"
@@ -118,7 +118,7 @@
def get_invoices(filters):
conditions = get_conditions(filters)
return webnotes.conn.sql("""select name, posting_date, debit_to, project_name, customer,
- remarks, net_total, other_charges_total, grand_total, rounded_total,
+ customer_name, remarks, net_total, other_charges_total, grand_total, rounded_total,
outstanding_amount from `tabSales Invoice`
where docstatus = 1 %s order by posting_date desc, name desc""" %
conditions, filters, as_dict=1)