Skip to main content
Answer

Passing Parent Parameter to multiple generic inquires as data source

  • May 8, 2025
  • 2 replies
  • 140 views
D

Trying out the new generic inquiry as data source capabilities in 2024.

Doing a Customer Sales report combining MTD and YTD.

Created MTD Generic Inquiry - all good. Month Parameter

Created YTD Generic Inquiry - all good. Month Parameter

Created a new inquiry with the MTD and YTD as data sources however I cannot get it to work when using a Month parameter on the Parent Inquiry.

Have tried using it as per release notes (“When parameters in the parent and source inquiry share the same names, the system creates a link between these parameters”) - does not work.

Have tried Conditions and even adding it to the relation joins.

Has anyone worked out the trick to get this working?

Best answer by JeffPatch

I have past “parameters” through to the child GI DACs but I used the paramters in the joins.  But this requires design considerations.

But I am particularly interested the note from the Release notes - “When parameters in the parent and source inquiry share the same names, the system creates a link between these parameters”.  Could mean the formula name that you can only see in the XML

    2 replies

    J
    Freshman III
    • JeffPatch
    • Freshman III
    • Answer
    • May 12, 2025

    I have past “parameters” through to the child GI DACs but I used the paramters in the joins.  But this requires design considerations.

    But I am particularly interested the note from the Release notes - “When parameters in the parent and source inquiry share the same names, the system creates a link between these parameters”.  Could mean the formula name that you can only see in the XML

    Chris Hackett
    R
    Freshman II
    • rafaelcolon
    • Freshman II
    • August 7, 2025

    Can you show as to how you were able to do this? We tried only adding a parameter on the parent inquiry with the same name hoping that the system automatically makes the link to the child inquiry but nothing happens.

    Is there something I need to do to explicitly pass down the parameter to the child inquiry in the parent inquiry?

    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