Skip to main content
Answer

Report's custom report parameters not displaying any results.

  • November 22, 2024
  • 3 replies
  • 69 views
K
Freshman II
Forum|alt.badge.img

I’m trying to create a report attached below, and use custom data as a filter field. However, whenever I try to search via the filter box, no data appears within the search function. I’ve tried my best to keep the report as close to the standard ones as possible, but I’m not sure what is causing this issue.

 

Best answer by DipakNilkanth

Hi ​@kkraus,

Try to add Batch Type as a Parameter and includes the Batch Type parameter in your Batch Number Parameter View name as below.
=Report.GetFieldSchema('AMBatch.BatNbr,BatchType')

 


Hope, it helps!

1 Attachments
    robk20

    3 replies

    DipakNilkanth
    Pro III
    Forum|alt.badge.img+13
    • DipakNilkanth
    • Pro III
    • Answer
    • November 23, 2024

    Hi ​@kkraus,

    Try to add Batch Type as a Parameter and includes the Batch Type parameter in your Batch Number Parameter View name as below.
    =Report.GetFieldSchema('AMBatch.BatNbr,BatchType')

     


    Hope, it helps!

    Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
    Chris Hackett
    A
    K
    Freshman II
    Forum|alt.badge.img
    • kkraus
    • Author
    • Freshman II
    • November 25, 2024

    ​@Dipak Nilkanth, That worked. Had to use Doc Type instead of Batch Type, but it worked perfectly.

    Chris Hackett
    DipakNilkanth
    DipakNilkanth
    Pro III
    Forum|alt.badge.img+13

    ​@kkraus, Happy to hear. Thank you for sharing the solution with Acumatica community.

    Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
    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