ADFS Designer

advanced financial statements (adfs) allow complete customization of financial presentations with control over both rows and columns each gravity statement allows user selection of entities to be included columns are used to filter financial information by date range, entity, and segment or dimensions this allows the selection of filters going left to right across the report rows are used to define the top to bottom presentation of financial information primarily based on gl account numbers access the adfs report designer from the reports menu from the designer menu you can edit or create new reports report sections the report designer is made up of 4 main sections (note the report preview is not used) action menu report options report columns report options action menu choosing either icon displays an advanced reporting screen a report action menu controls how reports are handled save and save as use these functions to save the results of the report layout under an existing or new name the report name is defined in the upper right corner run report use the run report option to run the existing report format in a new window as a complete report with report headers and labels a report can also be run from the adfs report portal by clicking on the report name add column clicking on the add column option adds a new column to the report following the last previously defined column delete use the delete option to delete the report format all aspects of the report will be deleted except row definitions that have been saved p review this option is not used report options run report as of use this date to define how the report columns are referenced using relative dates for example a column with "this year" will be defined as the beginning of the fiscal year to the run report as of date column options like this month and this year use this date to determine column contents report run date can be selected in the adfs portal when selecting the report select company the companies selected in this field will be used to validate accounts used in the rows it is often a good practice to select all companies here so any account can be included in a row selection rounding options select from no rounding to whole dollars, hundreds or thousands report numbers are automatically rounded as defined view zero lines by default, when all numbers in a row are zero, the row is not printed to view zero value rows on the report, check this option show exception report upon selection, the completed report will provide the option to download a report containing the list of missing accounts the exception report displays the accounts that are missing between the first and last account used this report can be useful in identifying any newly added accounts that have not been included in the main report show account numbers if select the left most column of the report will show the account numbers as defined in the report rows description width use this field to control the width of the report row descriptions header and footer labels enter header and footer labels to print on the report the labels will print left, center or right on the report header or footer enter static text using report slugs as follows @current date prints the current date @report date prints the report date report parameters when creating reports you have the option of creating report parameters that allow users to select certain information at run time this avoids having to create multiple reports to allow for different entities or dates report parameters can be created for entity selection date selection budget selection to create a parameter, in the selected dialog you can identify the new parameter requirement a new dialog will allow you to create a parameter name that can be used in the existing column or in another column for example a date parameter called "quarter" can be created and used in multiple columns parameters are maintained under the parameters button on the report definition screen report columns 1 column name each column is defined as c# where the # equals the column number column names are used in column calculations 2 column headings enter column header labels to print when the report is run the labels print above the columns when the report is run enter static text using report slugs as follows @cal month name name of the current month @period number the number of the column period @period year the year of the column period @current date prints the current date @report date prints the report date @fiscal per name the name of the current column period @fiscal year end the year end of the year of the end period date for the column @start date the full date of the start of the period for the column @end date the full date of the end of the period for the column 3 column width each column can have a defined width the width is measured in pixels you can adjust the width for report formatting 4 percentage to report to include on a percentage of the column's values in your report, you can enter it here example 30 will include 30% of the column values in the report 5 column type each column can be defined to show values or a calculation values shows the values calculated from the row and column calculations calculations opens the calculation field allowing column related calculations calculation examples addition/subtraction c1+c2+c3 or c1 + c2 c3 percentage of sales c3%90 (calculate percentages for column c3, use row 90 as the total income divisor) 6 time frame select the column time frame for reporting time frames can be set as relative or absolute a relative time frame uses the report date as its reference for example, month 1 would be the prior month to the report date absolute dates are fixed start and end dates choose custom dates open the start and end date options options new parameter create a date parameter (bs) this year/last year used in a balance sheet presentation totals all of the financial activity from the beginning to the relative date for the current or prior year (is) this year used to show the current years financial activity for income statements (is) last year used to show the complete prior years financial activity for income statements (is) last year (ytd) used to show the prior years financial activity for the reporting date 1 year for income statements (is) this month used to show the current months financial activity for income statements (is) last month used to show the prior months financial activity for income statements (is) this month last year used to show the same month from the prior years financial activity for income statements (is) month 2/ 11 used to show the prior months financial activity for income statements (is) year 2/ 4 used to show the prior years financial activity for income statements 7 entity selector you can select one or more entities to be included in the column alternatively entity group can be selected or a runtime company parameter (see 11 below) 8 currency selector you can select the the entities home currency or the the organizations consolidation currency 9 actual vs budget a column can be defined as an actual number or budget number for the column period if budgets are selected, the budget selection field opens to allow selection of the appropriate budget 10 filter type each column can optionally have a segment filter or a dimension filter if no filter is selected, the value will be calculated exclusively from the row value column segment filters column segment filters will override row definitions example row definition = 4100 (this will summarize all accounts that start with 4100) column filter = 1000, the row/column value will be 4100 1000 dimension values entering a dimension value will filter the results in conjunction with the row value example row definition = 4100 (this will summarize all accounts that start with 4100) dimension value = property 1, the row/column value will be 4100 & property 1 11 currency override symbol when a row is selected to show a currency symbol it will be reflected in each column unless it is overwritten options none use the row definition for the currency symbol yes do not show a currency symbol percent show percent sign in the column 12 no print the column will not print on the report but can be used in calculation 13 company parameter if selected no entity will be embedded in the column the company parameter definition will be inserted and used to select the company a report rows row definitions a group of rows can be saved as a row definition row definitions can be loaded into new or existing report definitions tip row layouts can take time to define saving the row definitions for re use can save significant time in creating other reports row definitions are independent of the reports layout a row definition can be loaded into a report and then edited with out changing the underlying definition add/edit/delete rows rows can be added by selecting the add row at the top row control, or by right clicking on an existing row right clicking on a row allows you to add a row above or below the existing row an existing row can be edited by right clicking on it, or by highlighting the row and clicking on the left edit icon to delete a row, right click on the row and choose the delete option or by highlighting the row and clicking on the left delete icon using the add multiple option you can add multiple accounts at one time, saving time in building templates use load existing row definition to search for and insert an existing row definition when completing a row definition use save row definitions to name and save the definition for future use rows row numbers gravity automatically maintains row numbers as rows are added or deleted row numbers are used in calculation and total rows row type use row type to define how the row is used in the report select the type from the field's drop down list account account range (example) depending on the type selected additional fields may be displayed to define additional controls in this example, the account row type has been selected account row type fields are described below label format the label to be printed on the financial report account define the row's account from the coa use the field's drop down list to select an account alternatively you can select a portion of an account using a wild card for example 41?? can be used to summarize any account that starts with 41 dimension values can be defined as part of the row definition dimensions can be used in rows or columns, but not in both is row expandable if selected the row will provide an auto expansion option at run time that would expand the row values by dimension sign change the sign of the row value for presentation purposes this does not change the underlying data column override to print the row value in only one column instead of all defined columns select column override and select the column to print in controls np = no print do not print this row, use it in calculations only cs = currency sign print a currency sign on all row values ot her row types description label print this label only no numbers print in this row retained earnings using this row type prints the value of retained earnings use this option for balance sheet reports current earnings using this row type prints the value of current earnings use this option for creating balance sheet reports underscore using this row type prints a single underscore on all the report columns double underscore using this row type prints a double underscore on all the report columns total using this row type allows the calculations on row values options are @sum(range) example @sum(10 80) with sum the rows 10 to 80 @sum(value+value value) example @sum(10+50 30) this will add rows 10 +50 and subtract row 10 calculations a calculating row can be used to create complex calculations to use a row in a calculation it would have an "r" then the row number for example calculating gross margin would look like r100/r40 100 row 100 divided by r 40 times 100 account filters one of the most powerful properties of the advanced financial statements is the ability to use filters to determine row values wild cards = whole segment filter ? = character filter the " " is used to define the segment structure row and column filters can be combined to create complex reports column filters override row filters column filters do not override full account values syntax = xxxx xxxx where x is a character or ? wild card, " " is the segment definition and " " is the segment wild card examples row segment value = 4100 this will sum all accounts starting with 4100 row segment value = 41?? 1000 this will sum all accounts that start with 41 and have 1000 in the second segment row segment value = 41?0 this will sum all accounts that start with 41 and end with 0 row segment value = 4100 column c1 filter value = 9010 column c2 filter value = 8080 this will sum all accounts with 4100 9010 in c1 and 4100 8080 in c2 is row expandable selecting this option on a row allow the auto expansion of individual rows by the dimension value this is useful so that each individual dimension value does not have to created as a separate row