AUGForums.com

An Acumatica User Group

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

Acumatica Report Reviews: Transactions for Period

February 26, 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 Transactions for Period (GL633000) report in Acumatica allows you to look at each General Ledger account and see all the individual Journal Transactions that posted to a financial period range that you get to specify.

You get to see all the journal entry batches that were posted during the period range so you can easily explore the detailed general ledger activity. Accountants like this kind of stuff.

You can also click on the batch number to be taken to the Journal Transactions (GL301000) screen for that batch. Note: the screenshot below is only showing batches that originated in the GL module, but the report will show you any batch, regardless of the originating module.

Screenshots

Here are some screenshots from the report:

Acumatica Report Review: Transactions for Period

Acumatica Report Review: Transactions for Period

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 Transactions for Period Report Data Access Classes (DAC)

Filters

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

Acumatica Transactions for Period Report Schema Builder

Groups

There is only one group on this report, but it involves two fields:

  1. AccountSubaccount
    1. Account.AccountCD
    2. Sub.SubCD

Additional Notes

  • I have to admit that I don’t completely understand what is going on with the joins here. The graphical representation above is confusing enough, but there is actually even more going on. For example, in the join to HistoryLast (GLHistory), I don’t understand exactly what is happening with the last row. I think it might have something to do with retained earnings, but I’m not sure.
    Acumatica Transactions for Period Report Joins
  • The other join that confuses me is the one to GLTran which uses a GreaterOrEqual and a LessOrEqual link condition. I’ve never done something like this in a SQL join before so I’m still trying to wrap my head around it.
    Acumatica Transactions for Period Report Joins
  • There are a number of different variables being used in groupHeaderSection2 to calculate the ending balance numbers.
    Acumatica Transactions for Period Report Variables
  • You don’t have to run the report for just one period. You could run it across multiple periods (or years) like, say, December 2014 to February 2015.
  • A batch could be listed more than once. It could even be debiting and crediting the same account in the same batch as you can see with batch 00004479 in the screenshot above.

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

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: What is your role at your company?

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

    By Tim Rodman, 4 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, 4 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, 5 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, 7 hours 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, 18 hours ago

  • RE: Is the Parameter Schema Field Mandatory?

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

    By Tim Rodman, 21 hours ago

  • RE: Can a customer Cross Reference for a parent account feed automatically to child accounts?

    @daniel I always like going simpler myself whenever pos...

    By Tim Rodman, 21 hours ago

  • RE: Carrier VDA Shipping Label (VDA 4994)

    Someone out there might have one, but I don't unfortuna...

    By Tim Rodman, 21 hours ago

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

    I am attempting several different methods. The issue i...

    By Rick Taylor, 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.