The tool is similar to FASTR (on AS400) but it is more flexible and offers more options, 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.
Click this link to download documentation
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.
