100001Q - Copy formulas in columns
By selecting the Copy formulas in columns ARES procedure from the Wizards menu in the toolbar of financial report, you can copy formulas into columns.
|
Source balance
|
Select the source financial report for copying formulas.
|
|
Dest. Balance
|
Select the destination financial report for copying formulas. Program only copies the lines with the same line number.
|
|
Source formula
|
Select the source column for copying formula (1-10).
|
|
Destination formula
|
Select the destination column for copying formula from source.
|
|
Copy formulas unchanged
|
This means that program will copy formulas and just add calculation for column C. The letter A will be replaced by the letter C for the third column.
|
|
Copy formulas and add prefix for intial date calculation
|
Similar to the above function, whereas all formulas get prefix X.
|
A practical use of prefix X in formulas: the program takes into account only the posts from initial balance on a specific date colored yellow for comparative period, in this case 01.01.2007, as shown in the image below. On report, anValue3 must be entered for Column C and report must be ''flagged' in procedure to use this date. Some reports for some localizations have already been predefined (currently only for CG localization). Predefined reports for other localizations will be created if needed.
