AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register

Acumatica Reporting Spotlight: Trial Balance Summary

February 12, 2015 by Tim Rodman

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 Summary (GL632000) report in Acumatica lets you view your Balance Sheet for a financial period of your choice. A Balance Sheet, or Trial Balance, is a very common report in an accounting system. You see the balance at the beginning of the period, any debits and credits that happened during the period, and finally the ending balance for the period.

When you first run the report, you need to enter a Ledger and a Financial Period, but you can leave the Branch empty which will give you a Consolidated Balance Sheet across all of your branches. This is pretty cool because most ERP systems require special software if you want to do consolidated reporting. And although you can’t do consolidated reporting across multiple Companies in Acumatica Report Designer (at least not that I know of), Branches are very powerful and can often replace the need for a separate Company in Acumatica.

You’ll notice in the second screenshot below that the Account field is a hyperlink. Clicking an account hyperlink will take you to the Account Details (GL404000) generic inquiry screen with the Account field pre-populated.

Screenshots

Here are some screenshots from the report:

Acumatica Trial Balance Summary Report

Acumatica Trial Balance Summary Report

Acumatica Trial Balance Summary 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:

Acumatica Trial Balance Summary Report Data Access Classes (DAC)

Filters

Here is a snapshot of the filters that are being used in the report. The parameters are included as well as a filter to only show Asset (A) and Liability (L) accounts:

Acumatica Trial Balance Summary Report Schema Builder

Groups

The data in this report is grouped into three groups based on the fields displayed underneath each group:

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

Additional Notes

  • The tables in the database have the Company column as one of the primary keys, but there is no need to use it in a join because Acumatica does it automatically for you (which is why I don’t think you can do consolidated reporting across companies using Acumatica Report Designer).
  • Notice that the GLSetup table is isolated on its own in the DAC Schema screenshot. The join used is actually a Cross join which works because there is only one row with setting data in it for each company.
  • The groupFooterSection1 and groupFooterSection3 sections aren’t used at the same time. They are displayed alternatively depending on which Sign of the Trial Balance option is selected in the General Ledger Preferences (GL102000) screen:
    Sign of the Trial Balance option in the General Ledger Preferences (GL102000) screen

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica Blog, Acumatica Business Intelligence, Acumatica Learning, Acumatica Out of the Box Reports, Acumatica Report Designer, Acumatica Report Writer, Acumatica Reports, Acumatica Schema Browser, Acumatica Standard Reports, Acumatica Training, Acumatica Trial Balance

By using this website, you agree to our Terms of Use (click here)

Online Members

Recent Blog Posts

  • EP 38: From Welder to Consultant, Nick Savage-Mady on his journey with Acumatica and MYOB Advanced (Podcast) January 21, 2021
  • Acumatica Reporting Tools Consulting January 19, 2021
  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
  • Acumatica and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
Acumatica Learning Resources

Recent Forum Posts

  • RE: Amend a SO with a status of "Shipping"

    I would first try to use Automation steps and adding th...

    By Ryan Brown, 8 hours ago

  • RE: Timecard reports/queries

    @tricia-carlson Ah, good point. I think you'd need to m...

    By Tim Rodman, 15 hours ago

  • RE: Saving a GI as a table to use in a separate GI

    Using a Generic Inquiry in another Generic Inquiry isn'...

    By Tim Rodman, 15 hours ago

  • RE: Adding a TAB to the Stock Item for Customer Forecasting Info

    Hi @stacy-johnson, I think you’ll have better luc...

    By Tim Rodman, 15 hours ago

  • RE: How do you link a SO to a PO AFTER the PO is created?

    The link is stored on the Sales Order Line, so you have...

    By Tim Rodman, 15 hours ago

  • RE: Amend a SO with a status of "Shipping"

    I think @ryanxbyte might have done a customization to h...

    By Tim Rodman, 15 hours ago

  • RE: Acumatica version 2019R1: ERP instance, companies/tenants, branches

    You can do it by User, but not by Company as far as I k...

    By Tim Rodman, 15 hours ago

  • RE: Format of the financial period from the textbox.

    @nicksm I think you're on the right track with CInt, bu...

    By Tim Rodman, 15 hours ago

  • RE: Mass change for Invoice Template

    This looks slightly different than my screenshot: ...

    By Tim Rodman, 15 hours ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.