Samples-Comparison different period balance
Compare current month with last month overhead.
Define data selection in two cells as followings, set different period for the two cells.
Samples-Comparison different ledger type,CO,BU,FY,...
Compare BA and AA ledger. Define data selection in two cells as followings, set different ledger for the two cells. The same to compare different Company,Fiscal Year, Business Unit.
Samples-Consolidation
Making consolidation report of company 00001 and company 00002
Do following settings. Same settings for different Business Unit,Fiscal Year,Ledger Type and etc.
Samples-Level of Detail
If you set level of detail for a cell,you should make sure related Business Unit(MCU) and Object(OBJ) are defined correctly.
Samples-Using category code
JDE chart of account has 23 category code. This can be used for kinds of group purpose. UFR supports all these 23 category code.
Samples- Using cell adduction to define Flexible data selection
The "Right Operand" can be an adduction. For example, you set Susidiary in the cell A1, and you define data selections like the following. When you change the cell value of A1, the data selection result changed accordingly. More detail can be found here.

Home

Excel Templates

Software