x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 5 replies
  • Subscribers 118 subscribers
  • Views 6287 views
  • Users 0 members are here
Browse Forums
Announcements
268
topics
260
replies
Databases and Operating Systems
758
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
851
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
182
topics
410
replies
Bert McAulay

Need to print Department name on FR income statement

SOLVED
Posted By

I am trying to print a departmental income statement from FR in Sage 300 ERP 2014 and need it to print the department name. Here is my scenario:

  • GL Account Structure is xxxx-xxxx with the second segment being the department
  • When running the report, "Report As" is consolidated and cannot be changed
  • At run-time, I am selecting the department that I want
  • Numbers are reporting correctly but the heading will not display the correct description for the department

I am using this formula:

=FRSDESC(2,FR("CurAcSegval02"))

In the report design section, this returns #VALUE! and when I run the report, it displays #N/A

If I modify my formula to =FRSDESC(2,"0301") it will give me the segment description from Sage 300 as expected.

I need to wildcard this value as we have over 300 departments in this database.

Thanks all...

Parents Reply
  • 0 in reply to Ronald B.

    My wife is pretty smart, but my FRS financial reporter makes it a lot easier ;-) Just use the $CURACSEGVAL string variables anywhere in the header and it will automatically print the name when printing statements separately. All the standard reports come set up like this already. Also, when printing statements separately in FRS, each department is a separate page in the one report - not separate reports :-)

Children
No Data

*Community Hub is the new name for Sage City