login: demopl

hasło: demopl

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.

 

 FASTR for E1 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.