AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Generic I...
GI Conditions on Su...
 
Notifications
Clear all

Questions GI Conditions on Substrings of Subaccount Segment Values

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 7 years ago
3 Posts
2 Users
0 Reactions
2,457 Views
RSS
Royce Lithgo
Posts: 557
 Royce Lithgo
Topic starter
March 27, 2019 6:32 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

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
Royce Lithgo
Posts: 557
 Royce Lithgo
Topic starter
March 27, 2019 8:42 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

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


Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
April 25, 2019 9:51 pm
(@timrodman)
Famed Member
Joined: 11 years ago

Good idea. I just added my vote.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 21 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×