AUGForums.com

An Acumatica User Group

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

Acumatica Standard Reports: GL Register Detailed

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

The format of the report is almost exactly the same as the GL Edit Detailed report, except the GL Edit Detailed report shows batches that have not been Posted, Released, or Voided whereas the GL Register Detailed report shows batches that have been Released and Posted.

Screenshots

Here are some screenshots from the report:

Acumatica Standard Reports: GL Register Detailed

Acumatica Standard Reports: GL Register Detailed

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

Filters

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

Acumatica GL Register Detailed Report Schema Builder

Groups

There is one group on this report and it involves two fields:

  1. group1
    1. Batch.Module
    2. Batch.BatchNbr

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

  • 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
  • EP 35: Ideas for AUGForums.com Live with Ryan Brown (Podcast) December 12, 2020
  • EP 34: Talking Acumatica eCommerce and the Next Normal for Distribution, Wholesale, and Manufacturing with Ted Stenstrom (Podcast) December 11, 2020
Acumatica Learning Resources

Recent Forum Posts

  • Acumatica Payroll PTO Banks adjustment

    Has anyone figured out how you would make a manual entr...

    By MSylvia, 3 hours ago

  • Best Practices/Suggested Processes for Before and After Acumatica Version Upgrade

    We have a process in Sage 100 where we will run various...

    By CLove26, 3 hours ago

  • Denominated Currency Accounts, Foreign Currency and Project Accounting

    I'm noting this here for some future reference. I've s...

    By megan.friesen, 4 hours ago

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

    I tried a simple test in 2020R1 and 2020R2 and it doesn...

    By AhmedBahar, 5 hours ago

  • Combining Bill Retainage Invoices to one AR Invoice in Construction

    Hi was wondering if anyone has come up with a good work...

    By Mike Baio, 10 hours ago

  • RE: Generic Inquiry RESULTS GRID Column Order

    On the Results Grid tab you can drag and drop the items...

    By Michael Roszkowski, 12 hours ago

  • RE: Acumatica 2020 R2 OwnerID Field

    Thank you, Tim. Just faced this problem in a customized...

    By Anna Borisova, 1 day ago

  • Import Azure AD Groups to User Roles Screen

    Hi AUG, I'm cross posting this from the community as I ...

    By Michael.Barker, 1 day ago

  • Link EPApproval to APInvoice

    I am trying to write a GI that will link an Invoice to ...

    By Michael Roszkowski, 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.