Added this formula in the generic inquiry
This error appears when trying to view generic inquiry. not sure what does this error means
Answer
Error: The virtual field cannot be used in a condition expression.
Best answer by emilythaw16
Quoting :
I got the similar error. I used the ‘SalesPerson’ table and then, instead of using SalespersonID_description, used ‘Descr’ field. And it works - I can apply the condition on this field.
+1Hi
Can you try with SalespersonID instead of salespersonID _ description.
If you still facing issue, please share the GI in xml format.
Deebhan Hari E
+19Hi,
If you want to use those fields in formulas, you need to bring these fields from the Main DAC but not reference DAC.
In the above GI, you need to join the SalesPerson table (using SalesPersonID condition) and use the SalesPerson fields in the formulas.
Hope this helps!!
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
hi
I have joined the tables in the GI.
as shown in the screenshot below, the first three works. but when I apply the IIF() Function, I will still face the Error: The virtual field SalespersonID_description cannot be used in a condition expression.
+19Hi,
Quoting :
I got the similar error. I used the ‘SalesPerson’ table and then, instead of using SalespersonID_description, used ‘Descr’ field. And it works - I can apply the condition on this field.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.