x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 9 replies
  • Answers 1 answer
  • Subscribers 116 subscribers
  • Views 420 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
767
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
877
topics
3k
replies
Sage CRM for Sage 300
183
topics
415
replies
Darren Williams

Financial Reporter Account Reference Syntax

SUGGESTED
Posted By

Ok Financial Reporter gurus. I cant figure out the correct syntax for account references with multiple segments. I have a client with an account segment that use 3 segments. I want to select a range of accounts that can filter on the 3rd segment. 

For example accounts 1000-100-01, 1000-100-02 and 1000-100-03. I want to select a range that includes ALL of the first 2 segments but only 02-03 of the third segment. I cannot get it to work. Is there a way to use column B instead to exclude a specific segment code?

Parents
  • 0

    FRS is a fully integrated (no Excel required) financial reporter for Sage300 which is much easier to use and has way more features. It's also fairly inexpensive.

    In FRS, you can just select the segment from the drop-down list and enter a range (using the finder if you wish).

    Having said that, are your segment values all 2 characters long? If you have values like "021", "024", "031", "034", "041", "044" and you are trying to get all the 02s to 03s then you will have to do something like:

    ACSEGVAL03 >= "02" AND (ACSEGVAL03 <= "03" OR ACSEGVAL03 LIKE "03%")

    FRS does this automatically.

    Otherwise, just  ACSEGVAL03 >= "02" AND ACSEGVAL03 <= "03"  should work. 

Reply
  • 0

    FRS is a fully integrated (no Excel required) financial reporter for Sage300 which is much easier to use and has way more features. It's also fairly inexpensive.

    In FRS, you can just select the segment from the drop-down list and enter a range (using the finder if you wish).

    Having said that, are your segment values all 2 characters long? If you have values like "021", "024", "031", "034", "041", "044" and you are trying to get all the 02s to 03s then you will have to do something like:

    ACSEGVAL03 >= "02" AND (ACSEGVAL03 <= "03" OR ACSEGVAL03 LIKE "03%")

    FRS does this automatically.

    Otherwise, just  ACSEGVAL03 >= "02" AND ACSEGVAL03 <= "03"  should work. 

Children

*Community Hub is the new name for Sage City