Skip to main content
Answer

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

  • September 25, 2023
  • 1 reply
  • 59 views
param2022
Jr Varsity II
Forum|alt.badge.img

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

Thanks

Best answer by BenjaminCrisman

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.

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • Answer
  • September 26, 2023

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.

Laura03
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