x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 15 replies
  • Subscribers 119 subscribers
  • Views 5884 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
770
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
854
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
878
topics
3k
replies
Sage CRM for Sage 300
183
topics
415
replies
Sage300

Wildcard in the first section of GL code

SOLVED
Posted By

Dear Friend, 

My company are using a several-section numbering for GL code and i would like to know how to wildcard the first part of GL code?

For example, GL code, 100-02-03,101-02-04,102-02-05, 102-03-01 etc. if i like to use wildcard in the first section of the code(100,101,102) to sum up all GL with the 02 in the second section into one report line, that is sum-up=100-02-03 +101-02-04 +102-02-05. Anybody can give me help?

Thank you very much!

Frank

Parents Reply
  • 0 in reply to Sage300

    That's not going to work. What you have above should be entered as:
    ="(ACSEGVAL02 = ""02"" AND ACCTID != ""102-03-01"")"

    Sorry I see I made a typo in my previous reply, I left out the ! in ACCTID != "102-03-01", which translates to account not equal to 102-03-01.

    But in your selection ACSEGVAL02="02" you exclude 102-03-01, so the second part is not required and has no affect.

Children

*Community Hub is the new name for Sage City