关于Acumatica报表设计器OAuth2支持及RPX文件管理的技术问询

1. Can I download/edit/upload RPX files using only SSO credentials via the browser? #

Yes, this is absolutely feasible with your current OAuth2 (Google) SSO setup, but with a key caveat around the offline editing step:

• Download: Once you’re authenticated to Acumatica via SSO in your browser, navigate to the report’s location (e.g., within a Customization Project or the Report Maintenance screen). You’ll be able to download the RPX file directly without needing a local Acumatica password—your active SSO session handles the authentication.
• Offline Editing: You’ll still need to use the desktop Report Designer tool to edit the RPX file offline. As you noted, this tool doesn’t support OAuth2 yet, but since you’re only editing locally (not connecting to the Acumatica instance during editing), this doesn’t require any credentials at this stage.
• Upload: Return to your authenticated browser session (still logged in via SSO) and upload the modified RPX file through the same web interface you used to download it. Your SSO session will validate your permissions for the upload.

Just make sure your Acumatica user account has the necessary permissions (like Customization Manager or Report Editor) to access and modify report files—SSO authentication alone won’t bypass permission checks.

2. Where can I get the Report Designer source code to add OAuth2 support? #

Unfortunately, Acumatica does not publicly distribute the source code for the Report Designer tool—it’s part of their closed-source commercial offering. That means you can’t directly modify the tool’s code to add OAuth2 support yourself. However, you have a few alternative paths:

• Submit a Feature Request: Reach out to Acumatica’s support team or your account manager to request OAuth2 support for the Report Designer. If enough customers request this functionality, it may be added in a future release.
• Leverage Acumatica’s API: You could build a small script or utility that uses Acumatica’s REST API (which supports OAuth2) to automate the download and upload of RPX files. This way, you can handle the authentication via OAuth2 programmatically, then use the desktop Report Designer for editing between API calls.
• Check for Customization Hooks: Review Acumatica’s official documentation for any extensibility points related to report management, but based on my experience, there’s no publicly available hook to modify the Report Designer’s authentication flow.

内容的提问来源于stack exchange，提问作者Matthew Mellon