x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 119 subscribers
  • Views 602 views
  • Users 0 members are here
Browse Forums
Announcements
268
topics
260
replies
Databases and Operating Systems
755
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
849
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
407
replies
zia wang

F/S by department

Posted By

Hi there,

What FR function should I use in order to create a report showing department side by side? Also, is there a way to combine two departments?

Thanks,

Zia

Parents
  • 0

    Use a function like FRAMTA with a selection criteria in the third parameter to select the department. Eg, have: =FRAMTA("NETYTD","","(ACSEGVAL02 = ""100"")") in one column and =FRAMTA("NETYTD","","(ACSEGVAL02 = ""200"")") in the next column. You will need to use the appropriate ACSEGVAL for your department. You can add departments with normal Excel formulas like: =F14+G14. 

    Another alternative is to use FRS which has a sample side-by-side departmental report you can use. See: http://www.dingosoft.co/frs.html

Reply
  • 0

    Use a function like FRAMTA with a selection criteria in the third parameter to select the department. Eg, have: =FRAMTA("NETYTD","","(ACSEGVAL02 = ""100"")") in one column and =FRAMTA("NETYTD","","(ACSEGVAL02 = ""200"")") in the next column. You will need to use the appropriate ACSEGVAL for your department. You can add departments with normal Excel formulas like: =F14+G14. 

    Another alternative is to use FRS which has a sample side-by-side departmental report you can use. See: http://www.dingosoft.co/frs.html

Children
No Data

*Community Hub is the new name for Sage City