Skip to main content
Solved

Report's custom report parameters not displaying any results.

  • November 22, 2024
  • 3 replies
  • 82 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 Dipak Nilkanth

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!

      3 replies

      Dipak Nilkanth
      Pro III
      Forum|alt.badge.img+14

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

          Dipak Nilkanth
          Pro III
          Forum|alt.badge.img+14

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

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