Populate the Material selection in report based on the status of material

  • 25 September 2023
  • 1 reply

Userlevel 2

I have my custom report. I want to populate the material number selector based on the status and date selected in the above parameters. How can we do that any ideas ??

Report screen



Best answer by BenjaminCrisman 26 September 2023, 17:02

View original

1 reply

Userlevel 7
Badge +4

Hi @param2022! To do this you would need a customization since there is no dependency between the date, the status, and the material.

An example of this is like on an AR Invoice where the RefNbr is actually dependent on the DocType and can’t populate until the DocType is specified.

You would need to create some custom table which takes care of these relations, add it to the site and then test it against the report parameters.


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