AUGForums.com

An Acumatica User Group

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

Acumatica Standard Reports: GL Recurring Transactions Detailed

May 7, 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 Recurring Transactions Detailed (GL640500) report in Acumatica shows your recurring transactions that have been setup in the Recurring Transactions (GL203500) screen. It is very similar to the GL Recurring Transactions (GL641500) report except that it shows the individual debits and credits for each scheduled batch.

Screenshots

Here are some screenshots from the report:

Acumatica Standard Reports: GL Recurring Transactions Detailed

Acumatica Standard Reports: GL Recurring Transactions 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 Recurring Transactions Detailed Report Data Access Classes (DAC)

Filters

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

Acumatica GL Recurring Transactions Detailed Report Schema Builder

Groups

There are two groups on this report:

  1. group1
    1. Schedule.ScheduleID
  2. group2
    1. 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 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 and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
Acumatica Learning Resources

Recent Forum Posts

  • RE: Bug in processing a Purchase Requisition

    Hi @jhoannaj, I think you’ll have better luck wit...

    By Tim Rodman, 2 hours ago

  • RE: AP Void Question

    Hi @mikerosz, I think you’ll have better luck wit...

    By Tim Rodman, 2 hours ago

  • RE: Split Default Warehouses

    Hi @matthewjames, I think you’ll have better luck...

    By Tim Rodman, 2 hours ago

  • RE: Tracking Purchase Order Changes in Acumatica

    @kurtybauer Great point about the AuditHistory table si...

    By Tim Rodman, 3 hours ago

  • RE: Odata Feed in 2020 R1

    I have experienced #2 and #3, but not #1.

    By Tim Rodman, 3 hours ago

  • RE: Bug: Unable to Preview Reports on Report Designer

    I haven't used the preview feature much other than when...

    By Tim Rodman, 3 hours ago

  • RE: Payment and Application Type - Customer Refund

    Hi @tlynn, I think you’ll have better luck with t...

    By Tim Rodman, 3 hours ago

  • RE: Amend a SO with a status of "Shipping"

    I would first try to use Automation steps and adding th...

    By Ryan Brown, 17 hours ago

  • RE: Timecard reports/queries

    @tricia-carlson Ah, good point. I think you'd need to m...

    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.