The tool is similar to FASTR and WORLDWriter (on AS400) but it is more flexible and offers more option. The main purpose is to allow a user to create custom report that reads any data from any tables in JDE and presents it in a nice and usable form.
The main features are described below:
- Unlimited number of user defined rows
- Possibility to define rows manually or on the fly by a SQL statement (for example show 1 row per each revenue account in Account Master), possibility to define a sequencing of the lines
- Unlimited number of user defined columns
- Cell override support (on a specific line and for a specific column a different calculation may be defined)
- reusable selections and sequencings (one definition of data selection can be reused by several reports)
- support for Periodbalance, YTDbalance and other special functions related to Account Balances
- each cell on the result PDF is calculated using a formula that uses setup of a row and a column with possible cell override, it may have type of string/number/date, it may have a special background color
- formulas support several functions such as IF (excel like), UDC (to read UDC description), NAME (to get current user's name), PN/FY/FROM/THRU (to get the period for which the report was run), TRANS (to translate a value) and more, it is also possible to refer values of any other rows / columns / cells
- possibility to export the calculated data from JDE to excel/word/Internet explorer including the proper formatting and colors of the fields
- performance optimization - the calculation is done in C function that was optimized for performance
- online or UBE calculation - user can calculate the report interactively or using a UBE (useful for more difficult and large reports)
- possibility to define user rights to read / update / execute the defined reports (by groups or by reports)
- reports/selections/sequencings may belong to groups (for example Finance / Assets / Invoices / Taxes etc.), the user rights may be also defined for the groups
- one report may be presented in several languages (all hardcoded texts can be translated)
- user defined constants (may be defined for each run of a report to influence the results)
- formatting of the calculated values has several advanced features such as rounding / presenting in thousands / padding with blanks or zeros / formatting of dates and more
A small example of just a few lines of demo data:
The red row and green column are calculated from other cells, the purple field has a cell override with a constant value.