Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Financial Reporter

Posted By jpgvmms 1 month ago

Is there a way in excel fr to define 4 account groups and also a specific account structure and account segment value.

Im trying something like=

="ACCTGRPCOD = ""19"" OR ACCTGRPCOD = ""16"" OR ACCTGRPCOD = ""17"" OR ACCTGRPCOD = ""18" AND ABRKID="CXX" and ACSEGVAL02=""100"""

But no luck. Any ideas?

Top Replies

Jim Love 1 month ago +1

Put it in your FR forumla and use parentheses. For example: =@FRAMTA("NETYTD.L1","","(ACSEGVAL02 = ""767"") OR (ACSEGVAL02 = ""930"")")

Parents

0 Jim Love 1 month ago

Put it in your FR forumla and use parentheses. For example: =@FRAMTA("NETYTD.L1","","(ACSEGVAL02 = ""767"") OR (ACSEGVAL02 = ""930"")")
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jpgvmms 1 month ago in reply to Jim Love

Thank you, on another note, is it possible to do a range for ACSEGVAL?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jim Love 1 month ago in reply to jpgvmms

Use a colon : to separate the beginning and ending numbers of a range.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jim Love 1 month ago in reply to jpgvmms

Use a colon : to separate the beginning and ending numbers of a range.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 300

Financial Reporter

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING