Welcome Guest, you are in: <root>AFIweb • Login

Page History: Financial Report Writer

Compare Page Revisions

33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Fri, 22 May 2009 11:40

Table of Contents [Hide/Show] Default Menu Location General Description Report Header Page Roll Up Groups Summarize Footer Number of Columns Account Range Account Report Groups Include Account Numbers Remove Zero Balances Drill Down View GL Account Short, GL Account Long, Segment Short, Segment Long Financial Report Writer Columns Tab Additional Report Fields for Customization

Default Menu Location¶

Reports >> General Ledger >> Financial Report Writer

Financial report writer Header tab screenshot

General Description¶

Financial Report Writer has the ability to generate different reports based on GL postings.

Report Header Page¶

Report Name: Unique name to identify the report.

Heading: The heading to print on the top of the report.

Sequence: By Account Number By Sequence Number - Uses the sequence number assigned on the GL Account Maintenance screen.

Roll Up Groups¶

Double click the underline text to create a roll up group.

Right click the underline text to show your new roll up group and select.

Click here for a screenshot

Summarize¶

Comes from the "GLsegments" rule which populates the segments screen.

This is another type of roll up.

Footer¶

The text to print on the bottom of the report.

Number of Columns¶

Determines how many columns will be on the report.

Current maximum number of columns is 17.

Note: Changing the number of columns will over write the existing report.

Account Range¶

Enter the beginning account range.

Enter the ending account range.

Account Report Groups¶

Double click the underline text to create the account report groups.

Right click the underline text to show your new account groups and select.

Click here for a screenshot

Include Account Numbers¶

Displays the account numbers on the report.

Remove Zero Balances¶

Displays the report removing all zero balance records.

Drill Down View¶

Creates a hyperlink report allowing access to more detail information.

GL Account Short, GL Account Long, Segment Short, Segment Long ¶

Determine where to pull the description from to display on the report.

Financial Report Writer Columns Tab¶

Columns are determine by the number of columns selected on the header page.

Financial report writer Columns tab screenshot

Account Mask: A type of roll up by segment values. This will list all related values into the first gl code.

EndBal/BegBal/YTD/PTD: Selection of Ending Balance, Beginning Balance, Year-to-Date or Period-to-Date

Dynamic or Static or Formula: Selection of Dynamic or Static Dates; Formulas or % of Group.

When Dynamic is selected the options available are: This, Next, Last, Last Year and Period Offset. The next data element selections are: Fiscal Period, Fiscal Quarter and Fiscal Year.

When Static is selected the year/period combination must be entered.

When Formula is selected a column must be selected, then the type of formula and another column. Formulas allow adding, subtracting and dividing of columns.

When % of Group is selected a group defined in the Account Report Groups (from the header tab) must be selected.

The last data element allows a selection of Actual data or any imported budget information.

Additional Report Fields for Customization¶