By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
3
Posts
2
Users
0
Reactions
2,114
Views
March 27, 2019 6:32 pm
I need to do a condition like 1st char of one subaccount segment does not match 1st char of another subaccount segment. It doesn't look like this is possible because I need to apply a function to the field on the left and in GI Conditions, the left fields are always drop downs. Is there any hack to accomplish this?
2 Replies
March 27, 2019 8:42 pm
I eventually solved this with a horrendous Query. Would have been far simpler if the Condition "Does Not Start With" were available.
Please vote for my idea - not sure why they didn't include negatives of some of the Conditions.
https://feedback.acumatica.com/ideas/ACU-I-2086
April 25, 2019 9:51 pm
Good idea. I just added my vote.