| commit | a7cf7fbccc73c47e03152aeb20e66ad4d0017db4 | [log] [tgz] |
|---|---|---|
| author | Charles-Henri Decultot <chdecultot@dokos.io> | Thu Mar 21 13:28:14 2019 +0000 |
| committer | Charles-Henri Decultot <chdecultot@dokos.io> | Thu Mar 21 13:28:14 2019 +0000 |
| tree | 23bbc60d4359236eb23d5de7c053d35dd67e1c2c | |
| parent | 2ae018a65367f5f48915a5cf885ad39a8760a40d [diff] |
Fix: Mapping issue in sql query
diff --git "a/erpnext/regional/report/fichier_des_ecritures_comptables_\133fec\135/fichier_des_ecritures_comptables_\133fec\135.py" "b/erpnext/regional/report/fichier_des_ecritures_comptables_\133fec\135/fichier_des_ecritures_comptables_\133fec\135.py" index 5fbf700..6b8d3f0 100644 --- "a/erpnext/regional/report/fichier_des_ecritures_comptables_\133fec\135/fichier_des_ecritures_comptables_\133fec\135.py" +++ "b/erpnext/regional/report/fichier_des_ecritures_comptables_\133fec\135/fichier_des_ecritures_comptables_\133fec\135.py"
@@ -87,8 +87,8 @@ left join `tabPurchase Invoice` pur on gl.voucher_no = pur.name left join `tabJournal Entry` jnl on gl.voucher_no = jnl.name left join `tabPayment Entry` pay on gl.voucher_no = pay.name - left join `tabCustomer` cus on gl.party = cus.customer_name - left join `tabSupplier` sup on gl.party = sup.supplier_name + left join `tabCustomer` cus on gl.party = cus.name + left join `tabSupplier` sup on gl.party = sup.name where gl.company=%(company)s and gl.fiscal_year=%(fiscal_year)s {group_by_condition} order by GlPostDate, voucher_no"""\