AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Courses
  • 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)

Online Members

Recent Blog Posts

  • 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
  • EP 35: Ideas for AUGForums.com Live with Ryan Brown (Podcast) December 12, 2020
  • EP 34: Talking Acumatica eCommerce and the Next Normal for Distribution, Wholesale, and Manufacturing with Ted Stenstrom (Podcast) December 11, 2020
Acumatica Learning Resources

Recent Forum Posts

  • RE: Generic Inquiry RESULTS GRID Column Order

    On the Results Grid tab you can drag and drop the items...

    By Michael Roszkowski, 20 mins ago

  • RE: Acumatica 2020 R2 OwnerID Field

    Thank you, Tim. Just faced this problem in a customized...

    By Anna Borisova, 15 hours ago

  • Import Azure AD Groups to User Roles Screen

    Hi AUG, I'm cross posting this from the community as I ...

    By Michael.Barker, 17 hours ago

  • Link EPApproval to APInvoice

    I am trying to write a GI that will link an Invoice to ...

    By Michael Roszkowski, 17 hours ago

  • RE: Using SMS

    Lightspeed Voice has a message service "built" in. Thi...

    By Doug, 22 hours ago

  • User access right - cost on Sales Order

    Hi, I have a problem that i can't solve. I have build...

    By Fosse, 1 day ago

  • RE: Problem when i have more then one Alternate ID

    Thanks for the answers! Unfortunately I don't think ...

    By Fosse, 1 day ago

  • RE: Using « start with » unstead of « contrains »

    It's a contains search, not a "starts with" search unfo...

    By Tim Rodman, 1 day ago

  • RE: Problem when i have more then one Alternate ID

    This article I wrote explains how to work with barcodes...

    By Carl Brooks, 2 days 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.