AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • 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)

Online Members

Recent Blog Posts

  • Acumatica Comma-Separated List of Shipments for a Sales Order using a Generic Inquiry and SQL View January 26, 2021
  • 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 Learning Resources

Recent Forum Posts

  • RE: Serial numbers in columns

    Hi Tim! Attached is my rpx. Odd Inge

    By ohalvors, 8 hours ago

  • RE: Serial numbers in columns

    Can you attach the .rpx file of the report that you're ...

    By Tim Rodman, 11 hours ago

  • RE: What is your role at your company?

    @dianne-a Sounds like you've had an interesting journey...

    By Tim Rodman, 18 hours ago

  • RE: What is your role at your company?

    My job title is Systems Analyst and I used to be a soft...

    By Dianne A, 18 hours ago

  • RE: Emailing Sales Orders / Quotes from Mobile App

    Hey Gustavo; did you ever get any where with this. I ha...

    By kevin.ruppert, 20 hours ago

  • RE: Importing Acumatica User Roles / User Security Permissions from Excel

    @ahmedbahar I am experiencing the same issue. I am on 2...

    By Adam-McGuinnes, 22 hours ago

  • Serial numbers in columns

    Hello! I am trying to print serial numbers in columns o...

    By ohalvors, 1 day ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    I have the same issue and I use SubReport (in your case...

    By Idrus, 1 day ago

  • RE: Is the Parameter Schema Field Mandatory?

    I think it's required. Without it, Acumatica doesn't kn...

    By Tim Rodman, 1 day 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.