JDExperts Sp. z oo JDFASTR for E1
Contents
1. The above mentioned combination of data selection and data sequencing will produce list of rows for example like this Row Description This Year 1110 Cash in Banks 149775 86 1131 Certificates of Deposit 50000 00 1210 Trade Accounts Receivable 4253350 07 1215 Allow for Doubtful Accounts 32 72 1218 Finance Charges Receivable 00 1222 Drafts Receivable 375 00 00001 Financial Distribution Company 4453533 65 Figure 38 Report with rows defined by data selection JDExperts Sp Z 0 0 Strona 21 7 31 ul Migdatowa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual OUExperts The first 6 lines are generated for the sequence line 2 data item OBJ Object Account text indent of 5 spaces the last line was generated for the sequence line 1 CO Company no indent JDExperts Sp Z 0 0 Strona 22 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual OGExperts 4 6 Column definition To be able to work with column definition on P59FAST JDExperts FASTR Main Report Setup select a report setup from the grid and use the Column Definition from the Row menu gt Grz Sulestrowski JPY900 ORACLE so EowaRos OOExperts REE JDExperts FASTR Main Report Setup He amp Select Find Add Copy Delete Close Form Row Tools A B i X DE B R Favorites Name Group FINANCE v Row Row Definition Records 1 1 Column Definition Customize Grid2. O Configuration Sel Selection Type Table Table View Calculated Calculated Field Type Description View Description Field Description Group AMOUNT c Column Selection F0911 Account Ledger AA Amount ALL BAL M Main Selection F0902 Account Balances ALL ROWOBJ C Column Selection F0911 Account Ledger OBJ Object Account ALL ROW_DSC D Row Description F0901 Account Master DLO1 Description ALL TESTCOL c Column Selection F0911 Account Ledger AA Amount ALL TESTROW R Row Selection F0901 Account Master ALL TRN 1 M Main Selection F0911 Account Ledger ALL Figure 19 FASTR Selection Setup screen A list of existing selections is shown in the grid Navigation is done by standard JDE navigation buttons ORACLE 1D EDWARDS OO xperts Grzegorz Sulestrowski JPY900 Sign Out FASTR Selection Setup i kg Select Find Add Copy Delete Close Tools O B fF X Figure 20 FASTR Selection Setup Navigation buttons Users can Add new or Revise and Review Copy or Delete an existing Selection Setup 4 3 1 Row selection setup The data selection for rows represent the selection criteria to be used in the rows of the JDFASTR report By clicking the Add button on FASTR Selection Setup screen users can create a new selection setup Revise Selection Setup screen is opened JDExperts Sp z 0 0 Strona 12 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User
3. 6 COQxPerts 4 3 Selection Setup The following paragraph will focus on setup of data selection for the report setup Selections are predefined selection criteria used by all commands and formulas intended to select data from the database and present it in row columns or cells To be able to work with selections on P59FAST JDExperts FASTR Main Report Setup use the Selection setup on the Form menu D Grzegorz Sulestrowski JPY900 ORACLE 10 ermaros HO Gxsperts Sign Out JDExperts FASTR Main Report Setup i Select Find Add Copy Delete Close Form Row Tools w O BE i X DR R Favorites Name i rts Group Select One v Form Selection Setup Records 1 1 z Sequence Setup _ Customize Grid 4 O sil Row Descriptions i Publishing Setup Report Formula Translations ert Rows Name Description 1 Group Definition ription 2 Defined Freq Group 6 GL Balances Balances on Bank Constants Manually M FINANCE Export Setup Import Setup Figure 18 P59FAST JDExperts FASTR Main Report Setup Form Selection setup FASTR Selection Setup screen is opened e N Grzegorz Sulestrowski JPY900 ORACLE w EowaRos 6 Q ExPerts Osa dh FASTR Selection Setup A Select Find Add Copy Delete Close Tools W Configuration Name Table View Name I only my selections Calculated Field Group Select One gt Type Select One v Records 1 7 _ a Customize Grid
4. iftrue iffalse result of the function in case the condition is true false alias alias of a DD item that is part of main selection for reports based on data selection it must exist in sequencing for the manually defined it must exist in the row data selection text any text to be trimmed 4 1 2 Supported global variables In the formula users may also specify any of the following global variables Each variable must be closed in brackets and preceded with a for example NAME The variables are case sensitive Please find a list of available global variables in Figure 3 TPN chosenperiodnumbe Figure 3 Supported Global Variables 4 1 3 User defined constants Apart from these predefined variables users may define their own constants JDExperts Sp z 0 0 Strona 57 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual n sx G Sulestrowski JPY900 ORACLE so cowaros OOxperts kama JDExperts FASTR Main Report Setup W Select Find Add Copy Delete Close Form Row Tools A B i X EE B R Favorites Name Group Select One v Sustomize Gris 60O Form Selection Setup Records 1 1 Sequence Setup Row Descriptions Publishing Setup Report Formula Translations Name Description 1 Group Definition rt Rows ription 2 Defined Freq Group GL Balances Balances on Bank Manually M FINANCE Export Setup Import Setup F
5. 8 X O BE R Name GL Balances 4 Records 1 5 _ z Customize Grid EJ O u R Seq Row Row AF Calculation Selection Selection Selection Selection Row ID Nbr Description Formula Parameter 1 Parameter 2 Parameter 3 Numeric Par Format Color T 10 BEAR Bear Creek Bank SELECT GLRow BEAR li o 0 20 FIB First Interstate Bank SELECT GLRow FIB 00 O 30 FRA First Bank of Paris SELECT GLRow FRANCE 00 m 100 TOT Total BEAR FIB FRA 0 R r R Figure 30 Revise Row Definition screen The Figure 30 Revise Row Definition screen shows an example of Row Definition Basically users define rows one by one The following fields in the grid need to be populated a Seq ID the rows will be sorted in given numeric sequence b Row Nbr all reports selections sequencings and other features may be sorted to groups Groups improve the accessibility of the definitions improve work with JDFASTR c Row description row description usually the first column d Calculation formula formula supports SELECT function and references to other rows e Selection Parameters 1 3 a reference value passed to STR1 STR2 STR3 variable in the predefined Selection Please refer to Figure 33 Row Selection Reference to STR1 f Selection Numeric Parameter numeric parameter to be used by SELECT function g Format a type of data selection h Row Color row color override To use predefined Row Selection ente
6. but the processing continues JDExperts Sp Z 0 0 ul Migda owa 4 02 796 Warszawa www jdexperts pl Strona 30 z 31 JDFASTR for E1 Users Manual 6 LIST OF FIGURES FIGURE 1 JDFASTR SETUP OF CUSTOM REPORT csccssccsecsececcsccscccsccaecaecceccsecsecsecseseeceseesesescaeceeesass 4 FIGURE 2 JDFASTR SUPPORTED FUNCTIONS ssscosccsscsscescosscescesccesesscosseecsescsceessestesseeseescessescesssees 5 FIGURE 3 SUPPORTED GLOBAL VARIABLES asa AOS GE EEE AEO Gai AE dak 5 FIGURE 4 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP CONSTANTS csscceccescecceccsccsceseeeeeees 6 FIGURE 5 FASTR USER DEFINED CONSTATNS svnerrnsvnnvnnvnnennsvnnvnnevnnvnnsnnsvnnvnnennnnnennsnnnvnnennennsnnnvnnennsenne 6 FIGURE 6 REVISE USER DEFINED CONSTANTS avnseneennsennvnnvrnvnnnvnnvnnnvnnvnnsnnsvnnvnnennvnnennsnnnennennsnnsennvnnennnenee 6 FIGURE 7 ROW COLUMN AND CELL REFERENCE vvs 7 FIGURE 8 SUPPORTED OPERATORS was si EA KE EPOCE OWA AA O AOS AAA 7 FIGURE 9 FORMATTING OF VALUES sanere Ga adi 7 FIGURE 10 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP GROUP DEFINITION c2sceeceeeeeeeeeeees 8 FIGURE LL FASTR FT GROUPS ola aiw EG Ao GOA OG 8 FIGURE 12 PS59FASTR USER RIGHTS cana GG G RA O Goa 9 FIGURE 13 REVISE USER RIGHTS nsnnssnssesenssessessesssrssessersersresroseosessersresrrerrnsrssresessersseesersresrrerroresersresererresene 9 FIGURE 14 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP semnnevnnsennnen
7. improve work with JDFASTR JDExperts Sp z 0 0 Strona 10 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual G Experts d Report Frequency this parameter indicates how often a recurring report e Rows defined this option determines how are rows defined by Selection or Manually f Division Factor Determines how the displayed amounts appear e Suppress zero lines If this option is selected accounts with zero balances are not processed If this option is not selected all accounts will be processed After populating all required fields click the OK button to save the setup and return to P59FAST JDExperts FASTR Main Report Setup screen e Grzegorz Sulestrowski JPY900 ORACLE sp EowaRos OC xperts Sign Out JDExperts FASTR Main Report Setup PI Select Find R Add Copy Delete Close Form Row Tools 7 B i X DB R Name IV Only my reports Group FINANCE v Records 1 1 ma l Customize Grid 4 O Report Report Rows Name Description 1 Description 2 Defined Freq Group f GLBalances Balances on Bank Accounts Manually M FINANCE Figure 17 P59FAST JDExperts FASTR Main Report Setup screen Limiting records shown Additionally Users can limit the records shown in the grid by selecting the Only my reports or selecting a Group JDExperts Sp Z 0 0 Strona 11z31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual
8. rows are automatically generated on each specified level break Column definition specifies number of columns and the logic for each of them Values in column may be retrieved from the database or calculated from another values of the report for example column 4 equals to column 3 minus column 2 Cell overrides are only supported for reports with manually defined rows If a cell override is used it replaces the column definition Each row column or cell definition may also specify a background colour see orange column Remains and green cell overrides in the example above 4 1 General Setup Information In the definition of row column or cell we specify so called formula This formula contains algebraic expression that may include constants functions and global variables 4 1 1 Supported functions In the definition of row column or cell users specify so called formula This formula contains algebraic expression that may include constants functions and global variables The following functions are supported JDExperts Sp Z 0 0 Strona 47 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual Column JE Row Description Cell Definition E E ition T a YTDBALANCE selection period Use for balance files to obtain year to date value x INCEPTIONTODATE selection period Use for balance files to obtain inception to date X PERIODCREDIT selection period Use for ba
9. 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual GL Balances Company 00001 Period Year 6 5 Date range 01 06 2005 30 06 2005 This Period PreviousPeriod Difference Bear Creek Bank 188553 04 33906 154647 04 First Interstate Bank 747746 95 15000 732746 95 First Bank of Paris 16920 0 16920 Total 953220 48906 904314 Figure 51 Generated MHT file Another possibility how to see the calculated values is using PDF report This will perform standard UBE print however some values might be trimmed and only up to 12 columns fit on the page On the P59FASTV JDExperts FASTR Available Reports choose Export Data from the Row menu ORACLE JD EDWARDS QOOOExperts Grzegorz Sulestrowski JPY900 Sign Out amp JDExperts FASTR Available Reports DE Select Find Close Row Tools v7 A X B R Favorites Name Group FINANCE v IV Only my reports Row Show Values Records1 1 Export Data Printto PDF Purge Values Report Constants Report Rows Name Description 2 Defined Freq Last Run GLBalances Balances on Bank Accounts Manually M 06 03 20 gt Figure 52 JDExperts FASTR Available Reports Print to PDF UBE is executed and the PDF is sent to screen or printer depending on the system setup SSFASTV Weisse Company 06032011 21 36 45 E0002 Balances og Bark Accouzs Page fear Creek Bank 188553 04 33906 t aratate Bank 147746 95 15000 00 132746 95 Firat Bank of Parla otal
10. Col amp F0902 CO 1 10 e F0902 OBJ 5 20 o l R Figure 27 Revise Sequence Setup The following values need to be defined a Table Name a JDE database table or business view from where the b Data Item a parameter indicating a field in the specified Table Name c Print on LB specifies if the report should export a row on change of the value d Indent chars how many blanks will be added in front of the row description e LindID defines the priority of the fields in the sequencing After populating all required fields click the OK button to save the sequence and return to FASTR Sequence Setup screen JDExperts Sp Z 0 0 ul Migda owa 4 02 796 Warszawa www jdexperts pl Strona 17 z 31 JDFASTR for E1 Users Manual OOEGxperts 4 5 Row definition Row definition influences the number of rows on the report and also the values in the rows The values in each row refer to the key of the row There are two possibilities how to define the rows Either manually which means each row must be defined separately or from report data selection and sequencing rows are automatically generated on each specified level break As mentioned above there are two possibilities how to define rows of the report The differences are listed in Figure 28 Row definition Differences i Manually Rows defined Feature defined by data selection Each row is defined separately Always have the same
11. Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual OUExperts 3 PREFACE JDFASTR is a universal tool to populate and present information in JDE EnterpriseOne environment Using this tool users may set up custom defined sheets of values with unlimited number of columns and rows Based on the setup the tool calculates values of all the cells of the sheet and presents the calculated data to the user Typically this tool may be used for balance sheet or cash flow JDExperts Sp Z 0 0 Strona 37 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual 4 JDFASTR Report Setup Information As a universal tool JDFASTR requires a setup of custom report The setup contains three important parts e row definition e column definition e cell overrides Column definition ae En er 3 100 onal p35 Row 88 443 01 100000 00 11556 99 127800 34 39357 33 definition 23657 42 20000 00 3657 42 17993 73 5 663 69 bs 36904 g dess 10096287 a3 97246 44 Cell overrides Figure 1 JDFASTR Setup of custom report Row definition influences the number of rows and also the values in the rows The values in each row refer to the key of the row which is an account in this example There are two possibilities how to define the rows Either manually which means each row must be defined separately or from report data selection and sequencing
12. number of rows Supports row formula User defined row description first column Figure 28 Row definition Differences 4 5 1 Manual row definition Define rows one by one you may specify row number which is a code of the row row description usually the first column formula supports SELECT function and references to other rows string and numeric parameters to be used by SELECT function and color override The rows will be sorted by SeqID sequence To be able to work with row definition on P59FAST JDExperts FASTR Main Report Setup select a report setup from the grid and use the Row definition from the Row menu D m Grzegorz Sulestrowski JPY900 ORACLE sp eowaros POE xperts BE M JDExperts FASTR Main Report Setup U BI Select Find Add Copy Delete Close Form Row Tools O B Favorites Name Group FINANCE v Row Row Definition Records 1 1 m Column Definition Cell Overrides Customize Grid Report Name Description 1 Rows 2 Defined Freq Group Translation GLBalances Balances on Bank Accounts Manually M FINANCE Figure 29 P59FAST JDExperts FASTR Main Report Setup Row Row definition Revise Row Definition screen is opened JDExperts Sp Z 0 0 Strona 18 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual ORACLE sp eomros POE xperts a sin out Revise Row Definition 0 MI OK Delete Cancel Form Row Tools
13. o Eoo a Cell Overrides m i NG Report Translation Rows Name Description 1 2 Defined Freq Group GLBalances Balances on Bank Accounts Manually M FINANCE Figure 39 P59FAST JDExperts FASTR Main Report Setup Column Definition The Revise Column Definition screen is opened ORACLE b EowaRos POE xperts UE D So szoa amp Revise Column Definition O amp OK Find Delete Cancel Form Row Tools 8 i X EE amp R Name GL Balances Records 1 4 Customize Grid I 8 O E Col Column Column Calculation String String Numeric ID Header 1 Header 2 Formula Parameter 1 Parameter2 Parameter1 Format Color O 10 This Period i ISELECT GLCol E M 0 ema 20 Previous Period SELECT GLCol 1 100 Difference 10 1420 0 Figure 40 Revise Column Definition a ColID is the sequence id of the column b Column Header name of the column header c Calculation formula formula supports SELECT function and references to other rows d Selection Parameters 1 3 a reference value passed to STR1 STR2 STR3 variable in the predefined Selection e Selection Numeric Parameter numeric parameter to be used by SELECT function f Format a type of data selection g Color color override After all details are defined click OK to save the definition Click Cancel to return to P59FAST JDExperts FASTR Main Report Setup screen JDExperts Sp Z 0 0 Strona 23 z 31 ul Migda
14. owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual OOEGxperts 4 7 Cell overrides To be able to work with column definition on P59FAST JDExperts FASTR Main Report Setup select a report setup from the grid and use the Cell Overrides from the Row menu ORACLE up eowaros JC Gxperts JDExperts FASTR Main Report Setup H Select Find Add Copy Delete Close Form Row Tools O Favorites Name Group FINANCE v Row Row Definition Records 1 1 Column Definition j Cell Overrides Customize Gr 4 O Report Name Description 1 Rows 2 Defined Freq Group Translation GLBalances Balances on Bank Accounts Manually M FINANCE Figure 41 P59FAST JDExperts FASTR Main Report Setup Cell Overrides The Revise Cell Overrides screen is opened ORACLE sp eomaros HGOGxperts EE mow Revise Cell Overrides A OK Find Delete Cancel Row Tools Name GL Balances Records1 1 o y ustomzeGr GA a Row Col Calculation String String Numeric i ID ID Formula Parameter1 Parameter2 Parameter1 Format Color o JI Figure 42 Revise Cell Overrides The Row ID and Col ID represent the Row and Column defined in the row and column definition The other parameters are a Calculation formula formula supports SELECT function and references to other rows b Selection Parameters 1 3 a reference value passed to STR1 STR2 STR3 variable in the predefine
15. 00 Sign Out JDExperts FASTR Main Report Setup o M Select Find Add Copy Delete Close Form Row Tools A BB i X BB R Favorites Name 5 Group Select One v Customize Grd 8 O Form Selection Setup Records 1 1 Sequence Setup Tif Row Descriptions Publishing Setup Formula Translations prt Rows Group Definition ription 2 Defined Freq Group Constants Manually M FINANCE Report Name Description 1 GLBalances Balances on Bank Export Setup Import Setup Figure 10 P59FAST JDExperts FASTR Main Report Setup Group Definition FASTR Report Groups application is opened Grzegorz ORACLE sp eowiaros OGxsperts suestrowsk 7 Sign Out FASTR Report Groups i 2 fa OK Find Delete Cancel Tools E amp I X R Records1 3 Customize Grid SJ 0O a Report Sa Group Description O ALL m o FINANCE Finance Figure 11 FASTR Report Groups Report Group Name and Description need to be entered After populating all required fields click the OK button to save the setup and return to P59FAST JDExperts FASTR Main Report Setup screen 4 1 8 User rights To protect the setup of reports allow or disallow usage of selections and sequencings and allow users to execute reports user rights need to be defined If a user creates a new setup he has full rights to it automatically also based on the used group other users may have immediate a
16. 00001 Fiscal Year Period 5 e Date Range 01 06 2005 30 06 2005 Records 1 4 Customize Grid g Row Description This Period Previous Period Difference Bear Creek Bank 188553 04 33906 154647 04 First Interstate Bank 747746 95 15000 00 732746 95 First Bank of Paris 16920 0 16920 00 oe 9 sesos e Figure 45 Browse Values This form can show up to 10 columns only You may go to next previous page of columns using the arrows but only 10 can be shown at the same time After the calculation is processed click Cancel to return to P59FASTV JDExperts FASTR Available Reports 5 1 1 Publishing the data Once the values are calculated users may need to use the data outside JDE To be able to keep the colours of cells and also to export all the calculated columns users may use a special feature that can export the data to a format supported by MS Excel MS Word or Internet Explorer ORACLE so cowarns GOE perts ape Sign Out JDExperts FASTR Main Report Setup i Select Find Add Copy Delete Close Form Row Tools we B i X BB R Favorites Name Group Select One v ustomize Gig OO Form Selection Setup Records1 1 Sequence Setup IT Row Descriptions Publishing Setup Report Formula Translation JP Rows Name Description 1 Group Definition ription 2 Defined Freq Group Constants Manually M FINANCE f GLBalances Balances on Bank Export Setup Import Setup
17. 40906 904314 Figure 53 Printed PDF 5 1 2 Export and import of the report setup In some cases users may need to export or import the setup of reports To do so on the P59FAST JDExperts FASTR Main Report Setup choose Export Setup from the Form menu JDExperts Sp Z 0 0 Strona 28 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual ORACLE JD EDWARDS OOExperts Grzegorz Sulestrowski JPY900 Sign Out I JDExperts FASTR Main Report Setup i Select Find Add Copy Delete Close Form Row Tools v amp 81 XOBR Favorites Name Group Select One _ Form Selection Setup Recordsi 1 Sequence Setup dg dl O Row Descriptions Publishing Setup Report Formula Translations Rows Name Description 1 Group Definition Defined Freq GLBalances Balances on Bank Constants Manually M Import Setup FASTR Export Setup for selected records screen is opened e Grzegorz Sulestrowski JPY900 ORACLE EG PO xperts Sign Out FASTR Export Setup for Selected Reports W ow Select Find Close Tools w Export File Name C IFASTR_Export fex Password Records 1 9 Customize Gric A __ AL u Description Ord Name Description 2 Group Frq I DMA Test DMA FINANCE M 7 GLBalances Balances on Bank Accounts FINANCE M I JDXF0001 Trial Balance by MCU OBJ SUB F0902 FINANCE M I JDXF0002 Trial Balance by Category Cod F0902 FIN
18. ANCE M M Obrotowa 1 Nowa Obrotowa FINANCE M Figure 54 FASTR Export Setup for selected records When exporting choose export file name type passwordand select all the report setups to be exported Import is done by selecting on the P59FAST JDExperts FASTR Main Report Setup the Import Setup from the Form menu ORACLE JD EDWARDS OQxperts Grzegorz Sulestrowski JPY900 Sign Out JDExperts FASTR Main Report Setup D amp Select Find Add Copy Delete Close Form Row Tools v eax 08 R Favorites Name Mo roup Select One v Form Selection Setup Records 1 1 Sequence Setup Row Descriptions Publishing Setup Report Formula Translations prt Rows Name Description 1 Group Definition ription 2 Defined GLBalances Balances on Banka Constants Manually Import Setup Figure 55 P59FAST JDExperts FASTR Main Report Setup Form Import Setup FASTR Import Setup screen is opened JDExperts Sp Z 0 0 ul Migda owa 4 02 796 Warszawa www jdexperts pl Strona 297 31 JDFASTR for E1 Users Manual Grzegorz GD AN Gl CZYNY PO LeNg pak iiai Sign Out FASTR Import setup D C OK Cancel Tools BX RE Import file CNFASTR_Export fex Figure 56 FASTR Import Setup When importing just type the file name and press Ok During the import all duplicates are ignored no records are updated if an Insert fails the message is displayed
19. E m Line Row Row oe ID Nbr Description v 10 CAN Bank of Canada v 20 FRA Bank of France 7 30 VAR Other Banks Figure 35 Row selection to Total After all rows are defined click OK to save the definition Click Cancel to return to P59FAST JDExperts FASTR Main Report Setup screen JDExperts Sp Z 0 0 Strona 207 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual OUExperts 4 5 2 Row definition by data selection In the row definition by data selection the rows are not defined manually but are defined by Report Selection Setup and Sequencing Setup Report selection setup is described in paragraph 4 3 3 and sequencing setup is described in paragraph 4 4 Grzegorz ORACLE w EowaRos LIG 00 te Sign Out Revise Sequence Setup i 2 e OK Delete Cancel Tools B X 2 Sequence Setup seq Group FINANCE ords 1 3 Fusa F0902 CO 1 10 F0902 OBJ 5 20 o JL LL LL Figure 36 Sequence Setup example ORACLE JD EDWARDS OO xperts Grzegorz Sulestrowski JPY900 Sign Out Revise Selection Setup i M OK Delete Cance Tools a Configuration Name ACC_Select Group FINANCE v Table View Name F0902 Column cell Row Description Records r x Data Line Condition Item Operator Value ID AND OBJ RANGE 1110 1222 10 AND LT EQ AA 20 AND MCU EQ 1 30 PD Figure 37 Report Selection example o felfelfe
20. Figure 46 P59FAST JDExperts FASTR Main Report Setup Publishing Setup To setup this feature start use Form Publishing Setup on the P59FAST JDExperts FASTR Main Report Setup Here you can define all possible common or user related paths where the exported files can be stored D G z Sulest ki JPY900 ORACLE up enwarps OOExperts a ign Out amp FASTR Publishing Setup i kg Find Close Modify Form Row Tools X O B R amp R Setup name x User Records 1 1 Customize Grid Setup User Name or blank Directory URL TEST Figure 47 FASTR Publishing Setup All possible common or user related paths where the exported files can be stored can be modified Click the Modify button to revise the Publishing Setup JDExperts Sp z 0 0 Strona 26 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual Grzegorz Sulestrowski JPY900 ORACLE sp eowaros LIC Gxperts os Revise Publishing Setup ooa OK Delete Cancel Tools a Records 1 2 Customize Grig 6 a Setup User Name or blank Directory URL 6 TEsT fca ci Figure 48 Revise Publishing Setup Click the OK button to save the setup As the files are generated on the JDE Enterprise Server the Directory is a folder accessible by Enterprise Server where the file will be stored On the other hand URL is a link to the directory recognizable by Internet Explorer this URL will b
21. JDExperts Sp z o o JDFASTR for E1 User s Manual 6000Experts 2011 03 07 Oracle is registered trademark of Oracle and or its affiliates 3 CERTIFIED CERTIFIED ORACLE PARTNER ORACLE PARTNER JD EDWARDS ENTERPRISEONE JD EDWARDS WORLD JDFASTR for E1 Users Manual 1 TABLE OF CONTENTS TABLE ON IN tet nese cease AG AO OE AAA AA 1 2 yh oe es rk a EN ne en eee ee 2 PENE 3 4 JOFASTR Report Setup normannere 4 4 1 FN NNN 4 4 1 1 TAP 4 4 1 2 Supported global variables vvs 5 4 1 3 Ver TEN NN e E E E E E 5 4 1 4 Referring other rows columns and cells rrrnrranrrrnnnnrrrrnnnnnrrnnnnnrrnnrnnnrrnnnnnersnnnsrnnrnnesennnunsnnnnnnnesene 6 4 1 5 SOOT ACES EEE E E SE CCA 7 4 1 6 FEN 7 4 1 7 UN 7 4 1 8 VL EPS ZEE EEE 8 4 2 Ker E E nia sunesengucnesue 10 4 3 SBIECHONSEUNa GA dO PN EE E 12 4 3 1 RON 12 4 3 2 EN ENN NN 14 4 3 3 FEN UD aha AN AREA A se E E 14 4 4 EGUENCINE SeN e EE 16 4 5 Ne 18 4 5 1 Mangdi row FEN save sd cavanvcaieseusiancnduncdinedtavers 18 4 5 2 ROW definition by data selection ar 21 4 6 COMTI AIO sen A E EA EE EE 23 4 7 EE gt EEE EE EE 24 5 Working with reborts PSOFASTM saa RGG GEJA G RA W O ee 25 Sel RUNNINSLNE FEDON EEE GA EOG 25 5 1 1 PENN 26 5 1 2 Export and IMPOT OT the report SEN 28 ETTE 31 JDExperts Sp z 0 0 Strona 1 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual 2 HISTORY OF CHANGES JDExperts Sp z 0 0 Strona 2 z 31 ul
22. Selection Setup Records 1 1 Sequence Setup II Row Descriptions Publishing Setup Report Formula Translations prt Rows Name Description 1 Group Definition ription 2 Defined Freq Group GLBalances Balances on Bank Constants Manually M FINANCE Export Setup Import Setup Figure 25 P59FAST JDExperts FASTR Main Report Setup Form Sequence setup FASTR Sequence Setup screen is opened ORACLE JD EDWARDS OOExperts Grzegorz Sulestrowski JPY900 Sign Out FASTR Sequence Setup D amp Select Find Add Copy Delete Close Tools A B i X B Sequence Setup I Only my sequencings Group FINANCE Records1 8 Customize Grid Sequence Setup DMA JCI JDXF0001 JDXF0002 Figure 26 FASTR Sequence Setup A list of existing selections is shown in the grid Navigation is done by standard JDE navigation buttons By clicking the Add button on FASTR Selection Setup screen users can create a new selection setup Revise Selection Setup screen is opened JDExperts Sp Z 0 0 Strona 16 7 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual Grzegorz ORACLE sp eowarps POESXPerts zi Sign Out Revise Sequence Setup i 2 kg OK Delete Cancel Tools e I X R Sequence Setup SEQ1 Group FINANCE gt Records1 3 0 Customize Gri 8 EO F Table View Data Print Indent Line Name Item on LB Chars ID
23. TUP ROW ROW DEFINITION cceecceseceecceeeeeeeeeeeces 18 FIGURE 30 REVISE ROW DEFINITION SCREEN Hvaal 19 FIGURE 31 ROW DEFINITION ROW SELECT wiec w HE G GO OOO OOO id Abra 19 FIGURE 32 SEARCH amp SELECT SELECTION SCREEN Gai RAA GK PAGE AREA AE 19 FIGURE 33 R W SELECTION REFERENCE TO STR1J aaa A OSA AAAA A i 20 FIGURE 34 REVISE ROW DEFINITION TOTAL ei GOYA AGORA EOG GAGA 20 FIGURE 35 ROW SELECTION TO TORRE ae EG ai NG 20 FIGURE 30 SEQUENCE SETUP PL SOO 21 FIGURE 37 REPORT SELECTION EXAMPLE aaa OGAR ORAZ KAKAO nanan A KA OKA 21 FIGURE 38 REPORT WITH ROWS DEFINED BY DATA SELECTION s cccssssescssvariccoosanssenssanensensvasavesevseeusnevassoanavcssense esa 21 FIGURE 39 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP COLUMN DEFINITION scceecceseceecceseceeecesaees 23 FIGURE 40 REVISE COLUMN DEFINITION aaa GRO OE OK OGAE O Gad 23 FIGURE 41 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP CELL OVERRIDES scccesccssccesceescceseeeseeeeees 24 FIGURE 42 REVISE CELL OVERRIDES oo GA EG GRO R ANO FONA OSG AC 24 FIGURE 43 P59FASTV JDEXPERTS FASTR AVAILABLE REPORTS sua w AAAA RASA 25 FIGURE 44 FASTR CALCULATE REPORT arne eee kan 25 FIGURE 45 BROWSE VALUES ae 26 FIGURE 46 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP PUBLISHING SETUP cccssccssceesceeecceseessneeeeees 26 FIGURE 47 FASTR PUBLISHING SETUP EE ok 26 FIGURE 48 REVISE PUBLISHING SETUP sasadavwscuasenantsaanpa
24. able is available in data selections sequencings and formulas and can be reffered to by variable namel After populating all required fields click the OK button to save 4 1 4 Referring other rows columns and cells Users may also refer values of other cells JDExperts Sp Z 0 0 Strona 6 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual Row Refers value of the cell in the same column and specified row Column Hcolid Refers value of the cell in the same row and specified column Cell override Hrowid colid Refers value of the specified cell Figure 7 Row column and cell reference 4 1 5 Supported operators When you define any kind of data selection setup the following operators are supported Qf equals 1 gt NE Notequals E GE Greaterorequal 1 er Greater LH tE Jlessorequ 1 12 gt Similar use instead of Figure 8 Supported operators 4 1 6 Formatting of values Although users may define a general formatting of numbers for the whole report by fields Division factor and Suppress Zeros on the revision form of report definition it is also possible to specify formatting on the Cell Column or Row level The supported shortcuts are described in the following table incorrect values or shortcuts not applicable to the appropriate type are ignored Rounds value to specified number of decimals All types Adds zeros on the left to th
25. ccess to it User rights can be defined in a specially dedicated application P59FASTR User Rights JDExperts Sp z 0 0 Strona 8 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual ORACLE 10 EDWARDS Q OOExperts Grzegorz Sulestrowski JPY900 Sign Out FASTR User Rights D e Select Find Add Copy Delete Close Form Row Tools vat BR i X O BR Effective Rights User f Report Records 1 10 gt I ustomize Gr EO JI u Report Report Exec Read Update User Name Group Auth Auth Auth 5 1 1 1 K RIGHTS 1 1 1 M DMA ALL 1 1 1 M DMA FINANCE 1 1 1 M DMA RIGHTS 1 1 1 M DMA DMA 1 1 1 M DMA TEST_XXX 1 1 1 I GSU GL Balances 1 1 1 I GSU GSU 1 1 1 I GSU test 1 1 1 Figure 12 P59FASTR User Rights A list of existing effective user rights is shown in the grid Navigation is done by standard JDE navigation buttons Users can Add new or Revise and Review Copy or Delete an existing User Rights By clicking the Add button on P59FASTR User Rights users can add a new user rights The Revise User Rights screen is opened ORACLE JD EDWARDS O Cxperts Grzegorz Sulestrowski JPY900 Sign Out Revise User Rights Gi e OK Cancel Tools E X k User I Report Name Report Group Authority l Execute I Read M Update Figure 13 Revise User Rights Each user right is defined for a user optionally report nam
26. d Selection Please refer to Figure 33 Row Selection Reference to STR1 c Numeric Parameter numeric parameter to be used by SELECT function d Format a type of data selection e Color row color override After all details are defined click OK to save the definition Click Cancel to return to P59FAST JDExperts FASTR Main Report Setup screen JDExperts Sp Z 0 0 Strona 24 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual OOe perts 5 Working with reports P59FASTV 5 1 Running the report After the setup is finished users can start running the report for a given fiscal year and period This is done in the application P59FASTV JDExperts FASTR Available Reports ORACLE up enwarps POE xperts Name Group Select One 7 IV Only my reports Records 1 1 Customize Grid 2 O Report Report ows Date Time Job Number Name Description 1 Description 2 Defined Freq Last Run Last Run Last Run GLBalances Balances on Bank Accounts Manually M 05 03 2011 205044 241 FINANCE Group Figure 43 P59FASTV JDExperts FASTR Available Reports A list of existing Reports is shown in the grid Select the required setup by clicking the Select button FASTR Calculate Report screen is opened ORACLE JD EDWARDS OOExperts Grzegorz Sulestrowski JPY900 Sign Out FASTR Calculate Report i Cancel Form Tools x O B Name GL Ba
27. e automatically open when the file is generated When the setup is done users can export the file On the P59FASTV JDExperts FASTR Available Reports choose Export Data from the Row menu ORACLE JD EDWARDS QOOExperts Grzegorz Sulestrowski JPY900 gt Sign Out JDExperts FASTR Available Reports i w Select Find Close Row Tools a XBR Favorites Name Group FINANCE v IV Only my reports Row Show Values Records 1 1 Export Data Customize Grid g EG Printto PDF j x Purge Values Report Constants Report Rows Name Description 2 Defined Freq GLBalances Balances on Bank Accounts Manually M KR gt Figure 49 P59FASTV JDExperts FASTR Available Reports Export Data Export calculated values screen is opened e m Grzegorz Sulestrowski JPY900 ORACLE sp eowarns 66 OGE xPerts ABE Export calculated values i tI Cance Tools X B Name IGL Balances Job Number 245 Publishing method TZM Filename c1GL Balances_245 mht URL IcAGL Balances_245 mht Export File Figure 50 Export calculated values Choose publishing method from the list and the system will automatically show the filename incl the full path and also the URL You may notice that the name of the file is built from the name of the report and from the unique job number the extension of the file is mht The Figure 49 shows the generated mht file JDExperts Sp z 0 0 Strona 27 z31 ul Migda owa 4
28. e by Selection M FINANCE RKA0002 Chart Of Accounts by Selection M FINANCE Figure 14 P59FAST JDExperts FASTR Main Report Setup A list of existing reports is shown in the grid Navigation is done by standard JDE navigation buttons JDExperts FASTR Main Report Setup D 2 t Select Find Add Copy Delete Close Form Row Tools ZO R XE B B Figure 15 P59FAST JDExperts FASTR Main Report Setup Navigation buttons Users can Add new or Revise and Review Copy or Delete an existing Report Setup By clicking the Add button on P59FAST JDExperts FASTR Main Report Setup users can add a new report setup The Revise Report Setup screen is opened Grzegorz Sulestrowski JPY900 ORACLE sp eomros O OEGxperts Ag Sign Out Revise Report Setup D OK Cancel Form Tools 8 X Name IGL Balances Report Description 1 Balances on Bank Accounts Report Description 2 Group FINANCE v Finance Report Frequency Yearly Quarterly Monthly Freely Rows defined by Selection Manually Division Factor 4 IV Suppress Zero Lines Figure 16 Revise Report Setup Adding a new setup Now all required fields need to be populated a Name a name of the current report setup b Report Description additionally to the name a description needs to be entered c Group all reports selections sequencings and other features may be sorted to groups Groups improve the accessibility of the definitions
29. e or a group of reports may be filled To grant rights to modify the user rights special keyword RIGHTS is used in field Report Name Types of user rights e read grants access to see the setup and use it e update grants rights to update the setup e execute grants rights to use the setup for the main report definition only no effect for selections and sequencings JDExperts Sp z 0 0 Strona 9 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual OO perts 4 2 Report Setup To be able to use the JDFASTR reports user need to prepare a new Report Setup first This is done in the application P59FAST JDExperts FASTR Main Report Setup ORACLE up eowarps PO xperts a gt ask JDExperts FASTR Main Report Setup Aam Select Find Add Copy Delete Close Form Row Tools BE i X EB R Name I Only my reports Group Selectone H Records 1 9 gt D mem i sa Customize Gr O Report Report Rows Name Description 1 Description 2 Defined Freq Group DMA Test DMA by Selection M FINANCE JDXF0001 Trial Balance by MCU OBJ SUB F0902 by Selection M FINANCE JDXF0002 Trial Balance by Category Codes 20 22 F0902 by Selection M FINANCE JOTEST Balances by Selection M ALL MY FIRST My first report JDFASTR by Selection ALL MY FIRST COPY My first report copy JDFASTR by Selection ALL Obrotowa 1 Nowa Obrotowa by Selection M FINANCE RKA0001 Simple F0911 aggregat
30. e size of nn characters All types Adds blanks on the left to the size of nn characters Dates Formats date where Y 4 digits year M 2 digits month D 2 digits day all other characters are copied so for example YYYY MM DD will be 2011 07 21 DD MM YYYY will be 21 07 2011 example 11000 will present values in thousands Figure 9 Formatting of values It is also possible to combine the shortcuts examples for value 12345 67 RO Z10 gt 0000012345 11000 B5 gt 12 3 blanks 4 1 7 Groups All reports selections sequencings and other features may be sorted to groups Groups improve the accessibility of the definitions fasten work with JDFASTR and also allow definition of user rights see below For example if we JDExperts Sp z 0 0 Strona 7 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual OUExperts define a data selection that makes sense for financial reports only we can put it to a group named FINANCE By default this selection will only be available for those reports that also belong to group FINANCE moreover selections from other groups will be hidden by default A user having rights to group FINANCE can then use work with the selection while users without proper rights can t Groups can be defined using the Group Definition from the Form menu in the application P59FAST JDExperts FASTR Main Report Setup ORACLE JD EDWARDS OOExperts Grzegorz Sulestrowski JPY9
31. er priority than OR b Data Item a parameter indicating a field in the specified Table Name c Operator a parameter that specifies an operand used for Data Item and Value specified Below is a list of valid values EQ Equal GE Greater or Equal GT Greater HNDL Table Handle LE Less Than or Equal LIKE used as wildcard e g VAT LT Less Than NE Not Equal NRANGE Not Between RANGE Between UDC User Defined Code VALUE In a List ZLNGTH Allocated Length VARLEN fids Figure 22 Selection Setup Revision Operator list of values d Value a parameter that specifies the value of the Data Item used in the current line e Line ID unique line number of current record in the grid After populating all required fields click the OK button to save the selection and return to FASTR Selection Setup screen JDExperts Sp z 0 0 Strona 13 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual G Experts 4 3 2 Column selection setup The data selection for columns represent the selection criteria and logic to be used in the columns of the JDFASTR report By clicking the Add button on FASTR Selection Setup screen users can create a new selection setup Revise Selection Setup screen is opened e Grzegorz Sulestrowski JPY900 ORACLE sp EowaRos GO Gxperts z ign Out Revise Selection Setup i k OK Delete Cancel Tools e i X R Configurat
32. igure 4 P59FAST JDExperts FASTR Main Report Setup Constants Use Form exit Constants in P59FAST JDExperts FASTR Main Report Setup FASTR User defined constants screen is opened Navigation is done by standard JDE navigation buttons Users can Add new or Revise and Review or Delete an existing Constants ORACLE JD EDWARDS xperts Grzegorz Sulestrowski JPY900 Sign Out FASTR User Defined Constants D A Select Find Add Delete Close Tools O ff X B Group Select One v User Records1 3 Customize Grid O Variable Data String Numeric Date Name Group User Type Value Value Value OBJFROM FINANCE 2 2000 OBJTHRU FINANCE 2 3000 RKACompany FINANCE 2 00069 Figure 5 FASTR User Defined Constatns By clicking the Add button on FASTR User Defined Constants users can add a new constants The Revise User Defined Constants screen is opened b Grzegorz Sulestrowski JPY900 ORACLE sp ermaros HOEGxperts EE ou Revise User Defined Constant w OK Cancel Tools B Optional parameters Group FINANCE z User gsu ti i is S Variable Name Info Constant Type String z Value Figure 6 Revise User Defined Constants String numeric or date constant for a specified group of reports or for all Constants may be user related or may be valid for all users As users have to define a value to the constant the program calls it a variable This vari
33. ion Nar GLCol Group FINANCE v Table View Name F0911 Selection Type Report Row Calculated Field AA Column Cell Row Description I Period YTD Inception Balanc Records 1 3 Customize Grid 4 R Data Line Condition Item Operator Value ID AND PN EQ IF FPN NUM1 lt 1 PN NUM1 12 PN NUM1 10 C AND FY EQ IF PN NUM1 lt 1 FY 1 FY 20 O Figure 23 Revise Selection Setup screen Column selection definition The Figure 23 shows an example of data selection for rows All required fields are described in the paragraph 4 3 1 Row selection setup Additionally to the row selection there are two additional options a Calculated Field a parameter that specifies which field will be accumulated for numeric fields or picked the first found for string char date b Period YTD Inception Balance this option needs to be checked if the user requires retrieving Account Balances After populating all required fields click the OK button to save the selection and return to FASTR Selection Setup screen 4 3 3 Report selection setup The data selection for reports represent the selection criteria and logic to be used in the row definition by selection of the JDFASTR report This is similar to normal data selection in JDE By clicking the Add button on FASTR Selection Setup screen users can create a new selection setup Revise Selection Setup screen is opened JDEx
34. lance files to obtain period credit x PERIODDEBIT selection period ___ Use for balance files to obtain perioddebit xX YTDCREDIT selection period Use for balance files to obtain year to date credit x YTDDEBIT selection period Use for balance files to obtain year to date debit x UDC system UDCcode key Retrieves the DescriptionlofanyUDC x x HF conditioniiftrue ffalse Conditional expression Excellike TRANSIkey To supporta textin severallanguges x x LANGUAGE key To supporta text in several languages 1 Xx xX VIEW alias Returns value of a field in main sequencing X TrM text Trims blanksonieftandright O Toxo RTRIM text Trimsblanksonrigt PP x LEVEL Returns sequencing level for reports based on main as 1 data selection see sequencing setup starts with 1 J DESCR alias value Retrieves DD description for passed alias and value X Figure 2 JDFASTR Supported functions anaa X X X X X X Below in Italics please find a description of the values in brackets selection reference to a selection setup define data selection to use see examples above period specifies a period number system JDE system code UDCcode User Defined Codes name of the UDC within the system code key value of the UDC condition any evaluable condition for example 100 gt 0 value of 100 would be calculated by another function
35. lances 1 Balances on Bank Accounts Frequency M Monthly Company 100001 Fiscal Year 5 Period No 6 Date From 01 06 200 Date Thru 30 06 200 Calculate Immediately Calculate by Batch Figure 44 FASTR Calculate Report The Company Fiscal Year and Period needs to be entered For reports of type F choose the date range instead Click Calculate immediately to perform the calculation immediately you will have to wait until the calculation is done Choose Calculate by Batch that will perform the calculation using a batch and also it will print a simplified PDF of the result you may continue working while the calculation is being processed Instead of immediate calculation use Calculate by Batch if you expect the calculation will take more than a few seconds This type of calculation will be done offline by a batch so the results will not be available immediately but you don t have to wait until the calculation is finished Additionally users can review results immediately before publishing the data JDExperts Sp z 0 0 Strona 25 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual OMCxperts On P59FASTV JDExperts FASTR Available Reports choose Show Values from the Row menu Browse Values screen will be opened ORACLE sv ermaros HO Gxperts R osp on Browse Values i kg Find Close Tools a X R Name GL Balances Balances on Bank Accounts Job Number 245 pa gt Company
36. nnvrnnernnsvnnsernnsnnnnennnernnvnnsennsennunennene 10 FIGURE 15 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP NAVIGATION BUTTONS ccseccesceeecceseeteeseeees 10 FIGURE 16 REVISE REPORT SETUP ADDING A NEW SETUP aoc EOG AO OO GEE ACK 10 FIGURE 17 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP SCREEN LIMITING RECORDS SHOWN 1122111221 11 FIGURE 18 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP FORM SELECTION SETUP c ssccscceescesseeeeeeaeees 12 FIGURE 19 FASTR SELECTION SETUP ENN 12 FIGURE 20 FASTR SELECTION SETUP NAVIGATION BUTTONS Ge UO A ORA SKA OEG A 12 FIGURE 21 REVISE SELECTION SETUP SCREEN ROW SELECTION ss sssssessssssesrrsrrsrrssrrssrrserseesreersresreseesereresererrnse 13 FIGURE 22 SELECTION SETUP REVISION OPERATOR LIST OF VALUES ee aaee aaa aaa aaa aaa aaa aa aaa aa aaa aaa aaa aaa aaaeaaaea aaa cana 13 FIGURE 23 REVISE SELECTION SETUP SCREEN COLUMN SELECTION DEFINITION scccscccssccescceecceeecseeeenseeseeeeeeceeeees 14 FIGURE 24 REVISE SELECTION SETUP SCREEN REPORT SELECTION DEFINITION ccssccesccesccesccesccnsccesseceeeseeceeesseeens 15 FIGURE 25 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP FORM SEQUENCE SETUP seccesceeesceseeeeeeeeeees 16 FIGURE 26 FASTR SEQUENCE SETUP odciac EO dE EA bk 16 FIGURE 2 7 REVISE SEQUENCE EP 17 FIGURE 28 ROW DEFINITION DIFFERENCES aoi OE SAGA Se dna 18 FIGURE 29 P59FAST JDEXPERTS FASTR MAIN REPORT SE
37. perts Sp Z 0 0 Strona 14 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 Users Manual ORACLE p e0maros POE xperts lei Revise Selection Setup i 2 w OK Delete Cance Tools e i X R Configuration Name ACC Seled Group FINANCE Table View Name F0902 Selection Type Report Row column cell Row Description Records 1 4 o ustomze Gag 2 O a Condition en Operator Value es AND OBJ RANGE 1110 1222 10 AND LT EQ AA 20 C AND MCU EQ 1 30 i O Figure 24 Revise Selection Setup screen Report selection definition In this example Data is selected from the table F0902 the Object Account is in range 1110 1222 the Ledger Type AA and the MCU 1 All required fields are described in the paragraph 4 3 1 After populating all required fields click the OK button to save the selection and return to FASTR Selection Setup screen JDExperts Sp Z 0 0 Strona 15 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual OUOGxperts 4 4 Sequencing setup To be able to work with selections on P59FAST JDExperts FASTR Main Report Setup use the Sequence setup on the Form menu ORACLE ud eomros OGxperts oe m 3 Sign Out JDExperts FASTR Main Report Setup i B Select Find Add Copy Delete Close Form Row Tools BE i X EB R Favorites JR Group FINANCE hd Form
38. r formula manually in the calculation formula filed or use the Select option from the Row menu ORACLE sp eomaros JI Gxperts nakne Revise Row Definition W M OK Delete Cancel Form Row Tools 8 0 X BDB B RR I Favorites Name IGL Bi Row Records 1 5 Total Customize Grid EJ O r ia Seq Row R lt alculation Selection Selection Selection Selection Row ID Nbr D Translation ormula Parameter1 Parameter2 Parameter3 Numeric Par Format Color m 410 BEAR Bear Creek Bank ISELECT GLRow BEAR o 0 M 20 FIB First Interstate Bank SELECT GLRow FIB 00 C 30 FRA First Bank of Paris SELECT GLRow FRANCE 00 Ci 100 TOT Total BEAR FIB F RA 0 R F Figure 31 Row definition Row Select A list of predefined Selections is opened in the Search amp Select Selection screen Grzegorz Sulestrowski JPY900 ORACLE b EbwaRos OOExperts 28 ign Out Search amp Select Selection i he Select Find Close Tools e X Table View Name IV Only my selections Selection Type R Group FINANCE v Records 1 1 um 8 o GustomizeGr Configuration Table View Table View Calculated Sel Name Name Description Field Type Group GLRow F0911 Account Ledger R FINANCE Figure 32 Search amp Select Selection screen JDExperts Sp z 0 0 Strona 19 z 31 ul Migda owa 4 02 796 Warszawa www jdexperts pl JDFASTR for E1 User s Manual OUExperts Choose selection and click Select The
39. s Manual ORACLE sp eo0waros GO Gxperts EG Revise Selection Setup i 2 b OK Delete Cance Tools X amp Configuration Nar GLRow Group FINANCE Table ViewName F0911 Selection Type C Report Row C Column Cell Row Description Records 1 5 Customize Grid 4 EQ 7 i Data Line Condition item Operator Value ID AND co EQ CO 140 AND OBJ EQ 1110 20 AND SUB EQ STR1 30 AND LT EQ AA 40 c Figure 21 Revise Selection Setup screen Row selection The Figure 21 Revise Selection Setup screen Row selection shows an example of data selection for rows Data is selected from the table F0911 the Company provided by the user Object Account equal to 1110 Subledger specified in the row definition by the reference STR1 and Ledger Type AA All values in the header need to be populated first a Configuration Name a name to be used for current selection b Group all reports selections sequencings and other features may be sorted to groups Groups improve the accessibility of the definitions improve work with JDFASTR c Table Name a JDE database table or business view from where the data will be selected d Selection Type a type of data selection When all fields in the header are filled properly the records in the grid need to be populated a Condition this parameter defines the conditions in each line to be met in the selection the first row must have AND AND has high
40. selection will be populated in the Calculation formula field ORACLE sp enwarps GO EGxperts i Kr ZAGR Sign Out Revise Selection Setup A OK Delete Cance Tools e i X RK Configuration Nar GLRow Group FINANCE Table View Name F0911 Selection Type Report Row Column Cell Row Description Records 1 5 Customize Grid EJ O ra a Data Line Condition Item Operator Value ID e jano jlco fea fre ML m AND OBJ EQ 1110 20 AND SUB EQ STR1 30 AND ET EQ AA 40 c Figure 33 Row Selection Reference to STR1 Also simple algebraic functions may be used with reference to other rows Users may also use the Total option from the Row menu to select required rows ORACLE JD EDWARDS O xperts Grzegorz Sulestrowski JPY900 Sign Out Revise Row Definition A OK Delete Cancel Form Row Tools Favorites Name GLB Row Select Records 1 5 m a ad a Translation rmula ae See de es Format cane DO 10 BEAR Bear Creek Bank SELECT GLRow BEAR 00 C 20 FIB First Interstate Bank SELECT GLRow FIB 00 DO 30 FRA First Bank of Paris SELECT GLRow FRANCE 00 M 100 TOT Total FBEAR FIB EFRA ol R a Figure 34 Revise Row Definition Total ORACLE JD EDWARDS O O xperts Grzegorz Sulestrowski JPY900 Sign Out Belect Rows to Total A Select Find Close Tools O X BR Name GL Balances Records1 3 CustomzeGid O OE KZZKKENNNNNEM
41. viuesunnins sea tonwtenssvayaanouansvenanaadiacavandvancnapaaianmaviuannenia timate 27 FIGURE 49 PSOFASTV JDEXPERTS FASTR AVAILABLE REPORTS EXPORT DATA csscccssccsscceeceescceseceeeeenseeeaees 27 FIGURE 90 EXPORT CALCULATED VALUES osi AO GAR ORA GG UO meee anaes 27 FIGURE 51 GENERATED MHT FILE Ludde add 28 FIGURE 52 JDEXPERTS FASTR AVAILABLE REPORTS PRINT TO PDF unauunannnnnnnnnrnnernnnnnnnnrnnnnrnnnrnnnennennnsrnnnvnnnsnnnenn 28 FIGURE SS PRINTED PDP wen E Rial EEE W AO EEEE 28 FIGURE 54 FASTR EXPORT SETUP FOR SELECTED RECORDS aa GAGA GEO A PGA AGGA 29 FIGURE 55 P59FAST JDEXPERTS FASTR MAIN REPORT SETUP FORM IMPORT SETUP cc0sccescceeeceeeceeeeeaeees 29 FIGURE 56 FASTR IMPORT SETUP oie n a iGO AO GA ein 30 JDExperts Sp z 0 0 ul Migda owa 4 02 796 Warszawa www jdexperts pl Strona 31z31
Download Pdf Manuals
Related Search