General Ledger Report for all accounts for a particular year

Hi @khowe86 see the GI attached. It has many columns but you should be able to add/remove and filter for data you’re looking for

Can people share GI’s?

This is literally just the GLTran table.  There is no beg/end balance per the OP’s request.  

Wonder if anyone has this, basically something like the FINANCE> Transaction for Account without the account limitation in inquiry form. 

A General Ledger Detail Report that can be run by account(s), date range, or periods is badly needed. It needs to contain as described in the original post in a concise manner. The out-of-the-box “GL Detail Report” I ran of our 2025 activity to provide to our auditors was over 37,000 pages! I had to provide it in .pdf format because it maxed out the rows in Excel (couldn’t get the full report).  I ended up running two separate reports to chunk the year into smaller bits so that I could export to excel so our auditors had a file that was easier to work with.  Despite that, our auditors reported that they had to dump the report through some AI tools to get it in a format they could work with.  The report design layout is part of overall problem with this report.  Please ​Acumatica, give us a solution and consult with an accountant on it. 

I’m not sure if this is helpful but I run the “Transactions for Period” under “Reports” in the General Ledger module.  I was able to run a detailed GL report.

Monica, 

I appreciate the suggestion.  That report design is very close to what would be an ideal state.  The biggest complaints for me include the customer/vendor # is presented instead of the name, which would be much more helpful in analyzing the data, and it is account by individual subaccount.  For accounts with lots of activity you can easily loose site of what account you are looking at once you are off the very 1st page of data as on successive pages the account number and name fall off.  If you picture what my report might be with a complex subaccount structure and many subaccount string possibilities, you suddenly have accounts with 15+ subaccount combinations and to have each one listed in it’s own little account activity sub report is not ideal.  I’d prefer the subaccount to be a column under the account.  This report also doesn’t have start and end date capability, which is necessary for this format. So again, I’m left with a report that gets HUGE, around 30,000 pages if I were to try and run it for a whole year, which is just longer than it needs to be strictly because of the report design.