AUGForums.com

An Acumatica User Group

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

Acumatica .rps Versus .rpx File Types

January 15, 2015 by Tim Rodman

The Edit Report button in Acumatica can be confusing

If your user has the ReportDesigner role assigned to it, things can get a little confusing.

First, check to see if you have the ReportDesigner role by going to Configuration –> User Security –> Manage –> Users (SM201010) and checking to see if the ReportDesigner role is checked like this:

Acumatica ReportDesigner Role

The Confusing Part

The confusing part comes in when you actually open a report. Let’s try Finance –> Accounts Payable –> Reports –> Audit –> Vendor Summary (AP655000) for example. If you have the ReportDesigner role, you will have a button that says Edit Report like this:

Acumatica Edit Report Button

Now, this button looks pretty harmless, but it can be confusing. The reason is that, when you press it, it downloads a file with the .rps file extension. If you download the file, then open it, you will be taken immediately to the Acumatica Report Designer login screen where you just have to enter your password.

Opening an Acumatica .rps File

Once you enter your password, it appears that you just opened the report from the .rps file which might lead you to believe that the .rps file is the report definition file.

However, once you go to File –> Save As… on the menu like this:

Saving an Acumatica .rpx file

It wants to save a file with an extension of .rpx instead of .rps:

Saving an Acumatica .rpx file

So, what’s the deal?

The .rps file is actually nothing more than a file that automatically fills out some of the fields in the Acumatica Report Designer login screen.

You can prove this by opening the .rps file in a program like Notepad++ and looking at the contents:

Contents of an Acumatica .rps file

Then, you can open the .rpx file in a program like Notepad++ and look at the contents:

 

Contents of an Acumatica .rpx file

As you can see from the screenshots above, the .rps file is only 3 lines and it is simply a text file that stores the information needed for the Report Designer program to go and find the actual report definition file in the Acumatica application.

However, the .rpx file is 964 lines in our example. It is an XML file that stores the full report definition and allows Report Designer to open the entire report definition without needing to talk to the Acumatica application. So, if you were on a computer without an internet connection, you could open an .rpx file, but not an .rps file.

Now You Know

And knowing is… Well, a picture explains it better:

Knowing the difference between the .rps and .rpx files in Acumatica

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

  • 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, 3 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, 3 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, 4 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, 7 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, 18 hours ago

  • RE: Is the Parameter Schema Field Mandatory?

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

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

  • RE: Carrier VDA Shipping Label (VDA 4994)

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

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