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: CA Edit

June 18, 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 CA Edit (CA612000) report in Acumatica shows you the transactions that have been entered through the Transactions (CA304000) screen and that are not On Hold and not Released.

Screenshots

Here are some screenshots from the report:

Acumatica Standard Reports: CA Edit

Acumatica Standard Reports: CA Edit

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 (the joins to the CATran table are very complicated and I couldn’t represent them graphically):

Acumatica CA Edit Report Data Access Classes (DAC)

Filters

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

Acumatica CA Edit Report Schema Builder

Groups

There is one group on this report:

  1. groupCash Account
    1. CashAccount.CashAccountCD
    2. CashAccount.Descr

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 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 171: Automating Acumatica Sales Orders with Artificial Intelligence (Podcast) April 23, 2026
  • EP 170: Unboxing AI Assistant in Acumatica 2026 R1 (Podcast) April 19, 2026
  • EP 169: Laura Jaffe – Unlocking Acumatica Report Designer (Podcast) April 8, 2026
  • EP 168: Joe DiPaolo – Hosted Acumatica and Joe’s Jr. AI Developers (Podcast) March 31, 2026
  • EP 167: Nicole Ronchetti – A Claude Skill for Acumatica ERP (Podcast) March 27, 2026

Recent Forum Posts

  • cschwark

    Nested SubReport Issue

    I have a custom Shift Changeover Checklist report (AM64...

    By cschwark , 2 days ago

  • tmac

    RE: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min

    I've had a similar issue with the out-of-the-box Fixed ...

    By tmac , 3 weeks ago

  • Ed Dolan

    RE: Limited or no support from Acumatica?

    @jjbotes Good thoughts. We'll endeavor to find a soluti...

    By Ed Dolan , 1 month ago

  • Johan Botes

    RE: Limited or no support from Acumatica?

    The question is "when" in the business process does the...

    By Johan Botes , 1 month ago

  • Ed Dolan

    RE: Limited or no support from Acumatica?

    @jjbotes Thank you for the feedback. I will discuss wit...

    By Ed Dolan , 1 month ago

  • Johan Botes

    RE: Limited or no support from Acumatica?

    Acumatica can have positive units in stock but a negati...

    By Johan Botes , 1 month ago

  • Ed Dolan

    RE: Limited or no support from Acumatica?

    @azeigler I am concerned as well about the lack of s...

    By Ed Dolan , 1 month ago

  • Johan Botes

    RE: Limited or no support from Acumatica?

    Hi Ed - the principle is embedded in standard functiona...

    By Johan Botes , 1 month ago

  • Ed Dolan

    RE: Limited or no support from Acumatica?

    Johan, Thanks for the rely and I hope you are well. ...

    By Ed Dolan , 1 month ago

Terms of Use & Disclaimers :: Privacy Policy

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