Skip to main content
Answer

Report Designer: Dependent parameters

  • April 24, 2024
  • 2 replies
  • 226 views
I
Freshman I
Forum|alt.badge.img

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

 

Best answer by BenjaminCrisman

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.

 

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • Answer
  • April 24, 2024

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.

 

Chris Hackett
I
M
Varsity I
Forum|alt.badge.img

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

 

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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