Accpac Financial Statements - Printing Departmental vs Consolidated
Posted by Plus Consultants on Thu, Oct 28, 2010 @ 06:42 PM
When you print your financial statements from the Sage Accpac GL Financial Reporter, you can choose to print a single, consolidated report, or you can print separate reports for different account number segments. For example, if one of your account number segments is a department code, you can print a separate report for each department.
To print separate reports with the Financial Reporter you must print by any segment of your account numbers (except the account segment). In other words, if you have three segments in your account numbers, Region, Department, and Account, you have to sort by the Region segment or the Department segment before you can choose "Report as Separate."
To print separate reports by Region and Department, you choose the Region or Department segment for the Sort by selection, then, in the grid, choose "Separate" for the other segment.
You can print separate segments using FR View from within the Statement Designer or from the Print Financial Statement icon.
If you use the Print Financial Statements icon, it repeats the report generation process for each account segment code, printing each separate report in turn.
Furthermore, your financial statements can be designed to say “Consolidated” if you choose to Report As “Consolidated” OR to print the Department code and description. The formula that you would embed into your financial statement would be:
=IF(FR("ReportAs")="Consolidated","Consolidated","Department : "&FR("curacsegval2") &" - "&FRSDESC(2,FR("CurAcSegVal2")))
A sample of the result would be:
“Department : 100 – Operations”
Happy Reporting!