How do I create an FR report with drilldown that doesn't show the FR code

Sage ERP Accpac General Ledger 6.0

How do I create an FR report with drilldown that doesn't show the FR code?

In an environment where multiple users may be accessing Financial Statement reports, and the report specifications are not to be edited, the Financial Statement criteria can be removed from the report.

Solution

Remove the FR codes by going through the following steps:

  1. Design and save a financial statement using the G/L Statement Designer.

  2. Open Financial Reporter > G/L Print Financial Statements.

  3. Select the report you created in step 1.

  4. In the upper right hand corner, in the Include section, check Drilldown Information.

  5. Enter the rest of the report criteria (Fiscal Option, Report Type, Sort By, etc).

  6. In the Print Destination section, select File or E-mail.

  7. Click Print.

Note: Reports created in this manner must be opened using Statement Designer. You will not be able to view these reports by accessing Microsoft Excel directly, as you require the FR Macro loaded. The FR Macro can only be loaded by accessing Microsoft Excel through the Statement Designer.

See also