General ledger grouped by account and then by Party / Against Account

ERPNext Accounting
, ,
1

Hi everyone,

My accountant has requested me a particular report. He wants to get a General Ledger that:

  • First groups by Account.
  • Then groups either by Party or Against Account if the former is not defined.
    The actual interface for the General Ledger allows for one selection of grouping, but further grouping is not allowed there.

His rationale for his request is that this will allow him to use a single report to easily audit the different accounts knowing the party or its use.

Currently to solve his request I can do it manually exporting the report grouped by Account and later using a spreadsheet to group it by the other fields (and calculate that new grouping total), but that’s a manual labor.

Anyone could give a me a hint on how to accomplish this, please?

Thank you!