AUGForums.com

An Acumatica User Group

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

Using Acumatica Report Designer – First Time

July 26, 2013 by Tim Rodman

The Acumatica Report Designer is a stand-alone program that allows you to create reports in Acumatica.

Here was my first experience using the program.

1. Open the Report Designer program on the Windows Start Menu.
2013-07-25_233033

2. All reports are stored as an XML file with the extension .rpx. To open an existing report, you can go to File -> Open From Server… on the menu.
2013-07-25_233812

3. Enter the path to your Acumatica installation, then enter your login info. Note that, if you have multiple companies as I do, you have to put the company name after the username (separated by @), otherwise you will get an error that says:

Error during login: PX.Data.PXUndefinedCompanyException: Unable determine proper company id for the request.
at PX.Data.PXDatabaseProviderBase.b()
at PX.Data.PXDatabaseProviderBase.getCompanyID(String tableName, companySetting& setting)
at PX.Data.PXDatabaseProviderBase.getRestriction(String table, String alias, Boolean mainRestriction, Boolean isRightJoin, Nullable` 1 effectiveCid)
at PX.Data.PXDatabaseProviderBase.appendWhereClauseToSelect(String tableName, PXDataField[] pars, StringBuilder bld)
at PX.Data.PXDatabaseProviderBase.SelectSingle(Type table, IEnumerable` 1 joins, PXDataField[] pars)
at PX.Data.PXDatabase.SelectSingle[Table](PXDataField[] pars)
at PX.Data.PXDatabaseMembershipProvider.ValidateUserPassword(String username, String password, Boolean onlyAllowed)
at PX.Data.PXActiveDirectorySyncMembershipProvider.ValidateUser(String username, String password, String& providerLogin)
at PX.Data.PXActiveDirectorySyncMembershipProvider.ValidateUser(String username, String password)
at PX.Api.WebServiceBase.Login(String name, String password)
2015-08-19_17-01-35
2013-07-27_145438

4. The company that I want in this case is called Demo Data. After entering your login info, click the Load reports list button to see a list of all available reports.
2013-07-25_233942

5. Select a report and click OK.
2013-07-25_234735

6. Note in the screenshot above that I selected the gl633500.rpx report. I knew that was the report that I wanted because I wanted to edit the Transactions for Account report in the Financial module. Since every screen in Acumatica has a unique ID, the report is actually just the ID for the screen in this case. You can determine the ID for a screen by putting your mouse over the screen name in the Navigation Pane or by clicking on the screen name, then looking at the address that appears on the top of your browser. As you can see in the screenshots below, both methods yield the result of GL633500.
2013-07-25_2351322013-07-25_235211

7. Now I have a scary looking report that I can break if I’m not careful. Hopefully, after going through the 112 page S130 Reports Dashboards and Inquiries course, I will know what all the stuff below means.
2013-07-25_235500

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica Report Designer, Acumatica Reporting, Acumatica Training, Acumatica University

By using this website, you agree to our Terms of Use (click here)

Online Members

Recent Blog Posts

  • Acumatica Comma-Separated List of Shipments for a Sales Order using a Generic Inquiry and SQL View January 26, 2021
  • 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 Learning Resources

Recent Forum Posts

  • RE: What is your role at your company?

    @dianne-a Sounds like you've had an interesting journey...

    By Tim Rodman, 4 hours ago

  • RE: What is your role at your company?

    My job title is Systems Analyst and I used to be a soft...

    By Dianne A, 4 hours ago

  • RE: Emailing Sales Orders / Quotes from Mobile App

    Hey Gustavo; did you ever get any where with this. I ha...

    By kevin.ruppert, 5 hours ago

  • RE: Importing Acumatica User Roles / User Security Permissions from Excel

    @ahmedbahar I am experiencing the same issue. I am on 2...

    By Adam-McGuinnes, 8 hours ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    I have the same issue and I use SubReport (in your case...

    By Idrus, 19 hours ago

  • RE: Is the Parameter Schema Field Mandatory?

    I think it's required. Without it, Acumatica doesn't kn...

    By Tim Rodman, 21 hours ago

  • RE: Can a customer Cross Reference for a parent account feed automatically to child accounts?

    @daniel I always like going simpler myself whenever pos...

    By Tim Rodman, 21 hours ago

  • RE: Carrier VDA Shipping Label (VDA 4994)

    Someone out there might have one, but I don't unfortuna...

    By Tim Rodman, 21 hours ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    I am attempting several different methods. The issue i...

    By Rick Taylor, 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.