Skip to main content
Solved

Report Designer: Dependent parameters

  • 24 April 2024
  • 2 replies
  • 54 views

I need to load Invoice numbers related to a specific customer. How can i achieve this? I am passing ‘ARInvoice.RefNbr.CustomerID’ in the report designer parameters but no invoice numbers are displayed. Please help!

Report Parameters

 

2 replies

Userlevel 7
Badge +4

Hi @ifelix! In this case there is no dependent relationship between customer and refnbr, so this type of parameter is not going to work.

What you would need to do is make a custom table which could have this relationship already defined, then you could use it in the report parameter.

 

Userlevel 2
Badge

you could look at Report Parameter dependent on another Parameter/Filter Customer Parameter to Parent Account • Acumatica Report Designer • Acumatica User Group Forums (augforums.com)

 

it seems there is the ability to filter “certain” parameters by other parameters already selected but it depends on the tables available. check royce’s reply

 

Reply