100001Q - Copy forumals in columns
By chOosing the Copy formulas in columns function from the wizards menu in toolbar of financial report you can copy formulas into columns.
|
Source balance
|
Source balance for coping formulas
|
|
Dest. Balance
|
Destination balance for coping formulas. Program will copy only lines with the same line number
|
|
Source formula
|
Source column for copying formula (1-10)
|
|
Destination formula
|
Destination column for copying formula from source.
|
|
Copy formulas unchanged
|
Mean, that program will copy formulas and just add calculation for column C. Letter A will be replaced with letter C for third column
|
|
Copy formulas and add prefix for intial date calculation
|
Similar to previous but also all formulas get prefix X
|
Practical use of prefix X for formulas. Program takes into account only posts from initial balance on that specific date colored yelow for comparative period in my case 01 01 2007 n my case (picture below). On report anValue3 must be entered for Column C and report must be ''flaged' in procedure to use this date. Some reports for some localisation are predefined already. Currently only for CG loc. Others follows if needed
