AUGForums.com

An Acumatica User Group

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

Building your first report in Acumatica Report Designer

January 8, 2015 by Tim Rodman

Last week we covered how to login to Acumatica Report Designer (click here) so you can retrieve a report directly from the Acumatica ERP application.

This week we’ll cover how to build a simple report from scratch that will display the list of our customers and run it from the Acumatica application.

Step 1: Open the Acumatica Report Designer application

After it opens, you should see a blank page like this.

Acumatica Report Designer Blank Slate

Go outside and take a breath of fresh air. Here you are, staring at a blank canvas with infinite possibilities. Building a report is an art and the report designer program is your canvas. Feel free to think of yourself as an artist. You might even want to go out and buy a beret so you can look like an artist like this guy here:

An artist pondering his next Acumatica report

 

Step 2: Build the schema

In order to build a report, you need to connect to the Acumatica data objects by going to File –> Build schema… on the menu.

Build schema...

 

Use the same URL and login credentials that you used last week to connect to an existing report. After you enter the information, click the Load schema button and you should see something like this:

Load schema

 

Note: The @Demo in the screenshot above is only needed if you have multiple companies. In my screenshot above, admin is the user and Demo is the company. If there was only one company, I would only have had to put admin, not admin@Demo.

The items listed on the left-hand side are called Data Access Classes (DAC). You can choose more than one to combine them in your report, but for the purposes of our simple customer list example, let’s just choose one. Click the BAccount DAC, click the arrow icon to select it, and then move to the Filters tab on the top.

Selecting a DAC

 

Now we need to filter the DAC. Because BAccount has more than just customers in it, we need to add a filter so that our report will only return customers. We can do this by filtering to only show records where Type equals “CU”. After filling out the fields, click the OK button.

Applying a filter in Acumatica Report Designer

Step 3: Add fields to the report

Now that we are done building the schema, we can add our fields to the report. For our example, we’ll just grab one field, AcctName and add it to the report. Just click the Fields tab on the right-hand side and then drag the AcctName field onto the detailSection1 area of the report.

Selecting a field in Acumatica Report Designer

 

After you drag the field to the detailSection1 area of the report, shrink the section so it looks something like this:

Shrinking detailSection1 in Acumatica Report Designer

 

Step 4: Save the report into Acumatica

Use the File –> Save To Server… option to save the report into the server:

Save To Server...

 

Pick a unique report name like MyFirstTestReport.rpx and click the OK button.

Save report on server

 

Step 5: Add the report to the Acumatica menu

I’m going to add it to the Audit folder in the Accounts Receivable module and use a ScreenID that hasn’t been used yet like this:

Add a report to the Acumatica menu

 

Step 6: Run the report

Find the report on the menu and click the Run Report button:

Running an Acumatica report

 

And, voila, there’s your first report in Acumatica Report Designer:

Our finished report

 

Here’s a quick video version of this post:

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica Blog, Acumatica Business Intelligence, Acumatica Learning, Acumatica Report Designer, Acumatica Report Writer, Acumatica 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, 2 hours ago

  • RE: Odata Feed in 2020 R1

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

    By Tim Rodman, 2 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, 2 hours ago

  • RE: Payment and Application Type - Customer Refund

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

    By Tim Rodman, 2 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, 16 hours ago

  • RE: Timecard reports/queries

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

    By Tim Rodman, 23 hours 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.