Solved

Report Designer: Dependent parameters

  • 24 April 2024
  • 2 replies
  • 41 views
I
Rank
Userlevel 1
Badge

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

 

icon

Best answer by BenjaminCrisman 24 April 2024, 15:26

View original

2 replies

BenjaminCrisman
Rank
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.

 

M
Rank
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


Terms & ConditionsCookie settings
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