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 Standard Reports: Open GL Documents

May 14, 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 Open GL Documents (GL656000) report in Acumatica allows you to view all the unposted GL documents in Acumatica. It’s easy to forget about an unposted transaction. This report helps you to track them down and clean them up.

Screenshots

Here are some screenshots from the report:

Acumatica Standard Reports: Open GL Documents

Acumatica Standard Reports: Open GL Documents

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

Filters

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

Acumatica Open GL Documents Report Schema Builder

Groups

There are no groups on this report.

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.