Skip to main content
Solved

I want to filter contact by customer in report design parameter

  • June 13, 2024
  • 5 replies
  • 229 views
  • Translate All
Freshman II
Forum|alt.badge.img

but I cannot filter it. I use this : =Report.GetFieldSchema('Contact.ContactID,CustomerID')

Best answer by nhatnghetinh

Hi @vannakheng66 

Currently, I see that the View names in the "Parameters" Tab cannot condition each other. Conditions (such as: filter contact by customerID) you can create in Tabs “Relationships” & "Filters"

 

Best Regards,

NNT

View original

5 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+14

Hi @vannakheng66 

Which Acumatica report do you want to filter contact by customer ?

 

Best Regards,

NNT

Translate
I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
    Freshman II
    Forum|alt.badge.img

    Hi @vannakheng66 

    Which Acumatica report do you want to filter contact by customer ?

     

    Best Regards,

    NNT

    my new report in acumatica 2022R2

    Translate
    nhatnghetinh
    Captain II
    Forum|alt.badge.img+14

    Hi @vannakheng66 

    Please use: = Report.GetFieldSchema('Contact.ContactID')

     

     

     

     

     

    Best Regards,

    NNT

    Translate
    I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
      Freshman II
      Forum|alt.badge.img

      Hi @vannakheng66 

      Please use: = Report.GetFieldSchema('Contact.ContactID')

       

       

       

       

       

      Best Regards,

      NNT

      I want to filter contact by customerID parameter. If we use like this Report.GetFieldSchema('Contact.ContactID'), It will load all contacts not contact of customer.

      Translate
      nhatnghetinh
      Captain II
      Forum|alt.badge.img+14

      Hi @vannakheng66 

      Currently, I see that the View names in the "Parameters" Tab cannot condition each other. Conditions (such as: filter contact by customerID) you can create in Tabs “Relationships” & "Filters"

       

      Best Regards,

      NNT

      Translate
      I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
        Terms & ConditionsAccessibility 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