As we can see in the 8th row the total is 3,146,168.24, then why the Total row has different values? If there are not any other accounts then it should be the same as Closing balance right?
Can anyone please guide me with it?
Hi,
Go to the Chart of Accounts and Select Tree View. Click on Three Dots and Click Rebuild Tree.
This should solve the total issue.
Thanks,
Divyesh Mangroliya
@mangroliya Thanks for the reply brother. I followed the steps you have shared but unfortunately it didn’t solved the issue. Still the grand total is different from the Total row above on it. I don’t know are we missing out something or this can be a bug from the Frappe side?
Hi,
After looking at the screenshot carefully, I think you are using the customized General Ledger Report. If Yes, Untick the “Add Total Row” in the Report.
Thanks,
Divyesh Mangroliya
@mangroliya Yes you are right Add Total Row has been checked. But one thing to note that this is not the customized report. This is the default General Ledger report available in erpnext.
Also on my side it is not editable. What should I do? I have one option to write a Query from Frappe Cloud.
On the three dots on the top right duplicate the report and name it something else and then remove the tick.
Hopefully it will work
@asieftejani Thanks for the reply brother. Even if I duplicate it, still the report is read-only. We are not able to edit it as you can see in the screenshot.
@NeelBrahmbhatt are you able to enable developer_mode?
@asieftejani As I am on live site I don’t know how to enable developer_mode from Frappe Cloud. Any suggestions will be helpful.
@NeelBrahmbhatt
Okay you are probably on a shared bench
For now you can explain to your manager that unless he wants to pay more per month (private bench) the total is opening balance + each debit/credit entry + total + closing balance (3 times the total in this case)
Its not a bug but is useful in some reports where total are optional (and therefore can be ticked or unticked)
@asieftejani I think so we are on private bench only as our current plan is $50/month. One option I have is to disable the Total Row by a DB query from Bench Console. Shall I do that?
@NeelBrahmbhatt yes thats a good idea. I also forgot you can do this on the frontend
Framework - System - System Console - frappe.db.set_value(‘Report’, ‘General Ledger’, ‘add_total_row’, 0)
Although not sure if it will work as I see at code level apps/erpnext/erpnext/accounts/report/general_ledger/general_ledger.json also has an entry
“add_total_row”: 1,
I think that is what is used to build the original db entry on installation. Can anyone please confirm that?
I’d check what that “Total” row is actually summing. In a lot of GL reports it’s total activity for the period, not the closing balance. If there’s only one account and it’s meant to total the closing balance column, then yeah, I’d expect those numbers to match.
