AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • 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)
Building Generic Inquiries & Pivot Tables

Online Members

 No online members at the moment

Recent Blog Posts

  • EP 158: Garrett Rochell – Acumatica Upgades, especially with the Modern UI (Podcast) October 4, 2025
  • acuCONNECT 2025 – Visualizing Inventory Balance $ and Service Level % TOGETHER September 19, 2025
  • EP 157: acuCONNECT 2025 Preparation – Part 4 (Podcast) September 16, 2025
  • EP 156: acuCONNECT 2025 Preparation – Part 3 (Podcast) September 6, 2025
  • EP 155: Chris Hackett – Update on Acumatica User Groups (Podcast) August 26, 2025

Recent Forum Posts

  • matthewjames

    RE: Generic Inquiry Screenid changes to ScreenId=00000000

    if anyone gets this error again (resetting screen ID to...

    By matthewjames , 3 days ago

  • Travis

    RE: Pick List report suddenly not splitting on Shipment

    I never found a solution initially - here I am 3 years ...

    By Travis , 3 weeks ago

  • ToonSix

    RE: Feeling Stuck on Making a Sandbox of our Database

    Delete as many snapshots as possible before making a ne...

    By ToonSix , 3 weeks ago

  • Retha

    RE: Printing Product Labels from Purchase Receipt

    I have read the article on the How to print multiple pr...

    By Retha , 1 month ago

  • Paul Lambert

    RE: Generic Inquiry into Business Event to monitor Import Scenarios

    An idea I've been brainstorming and haven't yet tested ...

    By Paul Lambert , 1 month ago

  • Jacky Mao

    How to make Customer Class ID available in Business Events for AR302000 (Payments and Applications)

    Hi everyone, I’m trying to create a Business Event fo...

    By Jacky Mao , 1 month ago

  • Lunar Windbloom

    Feeling Stuck on Making a Sandbox of our Database

    Hi all! Hope your day is going well! It's finally the...

    By Lunar Windbloom , 2 months ago

  • Tim Laird

    RE: [SOOrder.Status] = 'Open' always returns false

    @russ Customer Classes are user maintained, so you setu...

    By Tim Laird , 2 months ago

  • Tim Laird

    RE: What Triggers a Customization to need a Restart?

    OK, one more update. This creeped up again this weeken...

    By Tim Laird , 2 months ago

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.