search

frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
21.56k stars 7.29k forks source link

General Ledger Summary Report #15404

Open heatherpotter opened 6 years ago

heatherpotter commented 6 years ago

Can we have standard report on ERPNext (cloud) for GL Summary report? I'm looking for something high level that shows the debits/credits/total for each GL account without all the details. Many accountants just need the high level report and not all the details to do their calculations. Details are only needed when looking for something specific or digging in to the data.

Example report: gl_dist_summary

Here is the thread on the forum: https://discuss.erpnext.com/t/general-ledger-summary-report/40748/8

heatherpotter commented 6 years ago

On forum, @jigneshpshah wrote this query report which is exactly what I need: select
account AS "Account:Link/Account:150", sum(debit)As "Debit:Currency:120", sum(credit) AS "Credit:Currency:120", (sum(debit) - sum(credit)) as "Net:Currency:120" from tabGL Entry group by account