Run a different Report

  • 10 July 2024
  • 2 replies

Userlevel 1

In this report if i select the document type as “Credit Memo” and a Ref Nbr related to that and run this report, I want to output a different report(Credit Note Report) that has the same parameters as this. If i select “Invoice” doc type then i want this report(Sales Invoice Report) it self to output. Is that possible to do ? If so then how ?

Thank you in advance!


2 replies

Userlevel 4

Hi @ifelix 

I don’t think you can do that natively. This page is automatically generated for the Report by the Report Engine only to configure parameters for the associated report. It’s not customizable (at least not in an easy way).

However, you can achieve similar functionality by creating your custom screen. We can redirect users to a report by custom buttons, and in that button, you can check the selected Doc Type and redirect to a different report based on that.

Userlevel 7
Badge +10

The other option would be to basically create the Credit Memo report inside the invoice report.  You would have duplicate sections in the report with different settings based on the doc type.  So you might have a header section that is visible if Doc Type = CRM for the credit memo and another section if Doc Type <> CRM, and the same with the detail and footer sections.  

Irina’s How to guide here shows how to hide a detail line and the same principle would apply to other sections as well: 



About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved