| commit | 48e4abf43f34ef04ce5f06a0a423c6c640d66865 | [log] [tgz] |
|---|---|---|
| author | Saqib <nextchamp.saqib@gmail.com> | Mon May 25 19:21:08 2020 +0530 |
| committer | GitHub <noreply@github.com> | Mon May 25 19:21:08 2020 +0530 |
| tree | 46937d4d873abef263af528427416bde7e521e71 | |
| parent | 4dd6b9986fbf5320a80288b871d32ded4c4e39f1 [diff] |
fix: fetch depreciation amount only if depr entry is made (#21893)
diff --git a/erpnext/accounts/report/asset_depreciations_and_balances/asset_depreciations_and_balances.py b/erpnext/accounts/report/asset_depreciations_and_balances/asset_depreciations_and_balances.py index d7efbad..80bccaf 100644 --- a/erpnext/accounts/report/asset_depreciations_and_balances/asset_depreciations_and_balances.py +++ b/erpnext/accounts/report/asset_depreciations_and_balances/asset_depreciations_and_balances.py
@@ -111,7 +111,7 @@ 0 end), 0) as depreciation_amount_during_the_period from `tabAsset` a, `tabDepreciation Schedule` ds - where a.docstatus=1 and a.company=%(company)s and a.purchase_date <= %(to_date)s and a.name = ds.parent + where a.docstatus=1 and a.company=%(company)s and a.purchase_date <= %(to_date)s and a.name = ds.parent and ifnull(ds.journal_entry, '') != '' group by a.asset_category union SELECT a.asset_category,