AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

Acumatica Report Reviews: GL Register

April 9, 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 GL Register (GL620500) report in Acumatica shows your all the batches in the system that have been Posted or Released, regardless of the module.

This is the opposite of the reports that we looked at the past few weeks because it shows batches that HAVE been Posted or Released, not those that HAVE NOT been Posted or Released.

Screenshots

Here are some screenshots from the report:

Acumatica Report Review: GL Register

Acumatica Report Review: GL Register

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 GL Register Report Data Access Classes (DAC)

Filters

Here is a snapshot of the filters that are being used in the report:

Acumatica GL Register Report Schema Builder

Groups

There are no groups in this report. It is just a flat list of batches.

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 Reporting, Acumatica Reports, Acumatica Schema Browser, Acumatica Standard Reports, Acumatica Training

By using this website, you agree to our Terms of Use (click here)
Building Generic Inquiries & Pivot Tables

Online Members

 No online members at the moment

Recent Blog Posts

  • EP 166: Tim uses ChatGPT and Claude to build something cool (Podcast) March 21, 2026
  • EP 165: Jake Wells – EOS Scorecard and Acumatica Dashboards (Podcast) March 12, 2026
  • EP 164: Phil Steichen – Vibe Coding your own Business Intelligence tool (Podcast) February 19, 2026
  • EP 163: Daryl Bowman – Dissecting the new Acumatica Calendar Board (Podcast) February 9, 2026
  • EP 162: Gabriel Michaud – Catching up on new cool stuff in Velixo and Excel (Podcast) February 2, 2026

Recent Forum Posts

  • Ed Dolan

    Negative/Credit Inventory Value?

    We are starting a new line of business to recycle const...

    By Ed Dolan , 1 day ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodmanrodman Question for you. What table joins d...

    By Tami , 1 week ago

  • Brynn Rutherford

    RE: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min

    @timrodman - It won't let me attach the file. I will em...

    By Brynn Rutherford , 1 week ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Thank you! We just upgraded to 2025R1 in ...

    By Tami , 1 week ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    @tlynn Looks like someone already created a product ide...

    By Tim Rodman , 1 week ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Yes! If that parameter was optional it wo...

    By Tami , 1 week ago

  • Tim Rodman

    RE: Can not delete an automated schedule

    I doubt it since Business Events are stored on the Busi...

    By Tim Rodman , 2 weeks ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    Is the problem with this Critical Materials (AM401000) ...

    By Tim Rodman , 2 weeks ago

  • Tim Rodman

    RE: Update the Unit Rate for Existing Project Templates

    The following worked for me.   Here's the Data...

    By Tim Rodman , 2 weeks ago

Terms of Use & Disclaimers :: Privacy Policy

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