Acumatica Report Reviews: Trial Balance Detailed

This post is part of a two year series of posts related to the out of the box reports in Acumatica. For a full list, click here.

The Trial Balance Detailed (GL632500) report in Acumatica is very similar to the Trial Balance Summary report that we looked at last week (click here), but with one additional column added.

The main difference is that the Trial Balance Detailed report shows a separate row for each Account/Subaccount combination whereas the Trial Balance Summary report only shows a separate row for each Account. Bottom line, the Trial Balance Detailed report is more, um, DETAILED.

Even the Account hyperlink field functions the same as it does in the Trial Balance Summary report by taking you directly to the Account Details (GL404000) generic inquiry screen. The only difference is that it pre-populates both the Account and Subaccount fields instead of just the Account field. When you leave the Subaccount field blank in the destination generic inquiry screen, it shows all subaccounts for the Account selected.

Screenshots

Here are some screenshots from the report:

DAC Schema

I went through the DAC relationships on the Relationships tab in the Schema Builder window and came up with the following graphical representation (which is the same as the Trial Balance Summary report from last week):

Filters

Here is a snapshot of the filters that are being used in the report. You guessed it, they’re the same as the Trial Balance Summary report from last week.

Groups

The data in this report is grouped into three groups based on the fields displayed underneath each group. Compared to the Trial Balance Summary report from last week, there is one additional field in the third group (Sub.SubCD):

1. Ledger
   1. GLHistoryByPeriod.LedgerID
2. AccountType
   1. Account.COAOrder
   2. Account.Type
3. AccountCode
   1. Account.AccountCD
   2. Sub.SubCD

Additional Notes

• The same additional notes from last week (click here) also apply to this report.
• I forgot to point out last week how they achieve getting the blue hyperlink under each account which takes you directly to the Account Details (GL404000) generic inquiry screen for that account. All you have to do is set the NavigateMethod to Server instead of Client. This is a great example of one of the benefits of using an embedded report writer like Acumatica Report Designer because it has built-in intelligence like knowing how to navigate to an account.