but I cannot filter it. I use this : =Report.GetFieldSchema('Contact.ContactID,CustomerID')
Answer
I want to filter contact by customer in report design parameter
Best answer by nhatnghetinh
Hi
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
+11Hi
Which Acumatica report do you want to filter contact by customer ?
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Hi
Which Acumatica report do you want to filter contact by customer ?
Best Regards,
NNT
my new report in acumatica 2022R2
+11Hi
Please use: = Report.GetFieldSchema('Contact.ContactID')
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Hi
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.
+11Hi
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
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.