Skip to main content
Answer

How to filter or exclude parameter data in report

  • September 19, 2024
  • 2 replies
  • 129 views

Forum|alt.badge.img

Hi,

 

I have a customize report, in which I am using two parameters one is order type and second is order number. In the second parameter field we want to show only those order which are approved currently system is fetching all the orders. attached screenshot for reference.

 

 

 

 

Best answer by DipakNilkanth

Hi @suchit39,

Have you gone through the This forum?

You need to add particular status to the filers section, So only those orders will be fetched and available for selection.

Hope, it helps!

2 replies

DipakNilkanth
Pro III
Forum|alt.badge.img+13
  • Pro III
  • Answer
  • September 19, 2024

Hi @suchit39,

Have you gone through the This forum?

You need to add particular status to the filers section, So only those orders will be fetched and available for selection.

Hope, it helps!


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • September 19, 2024

Hello,

Did you compare your report Parameters to similar parameters used in standard Acumatica Reports?  Here is an example using Receivables → Printed Forms → Invoice/Memo Report. In Invoice/Memo report, we first choose Document Type and then Reference Number lookup reflects only reference numbers that match the document type we selected:

 

I hope this example helps you.

 

Laura