Home

Axapta Integration - e

Contents

1. Administration Platform e on Generator Solution Center Labels are the names of Entities and members in the XML document and can be defined in this form OTo Increase B V 118 TOINCREASE O ES XML Labels Code BIKE Bike Code Description BIKEANAL Bike amp xapta With Configuration BIKEC Bike with Configuration BIKEGEA BLANKLINE1 Blank line 1 BIaMKLINE2 Blank line 2 Blower Blower Blowerlso Blower isalatian BODY Body Code The code for a Label Choose a short name without spaces This Code is used as an identification code ID when applying the rules in the e Con Studio Description Description of the Label This Description is shown at the Front End Use a meaningful name that will make sense to the end user Example When the price of the bike a field property depends on the color of the bike an additional property you ll need to create two labels Description Choose a color for the bike The price for the bike will be You can then use a rule to give a value to the price Such a rule might look like this if color 1 then price 10 Notice that we use the Code names in the rule not the Descriptions Language O
2. HTML description Value Description cols r i multiline multiline There are 2 options for the multiline style which you can enter in the Value Description column e True Entering true in the Value Description column will activate the multiline options e Text Entering text in the Value Description column will activate the multiline options and display them as a text box The entered lines will be adjusted to fit the size of the field in the Axapta Table and saved in Axapta Tips amp Tricks This multiline style requires a field in Axapta with the capability of storing lines of text Below is the resulting text box which appears in the Front End OTo Increase B V 151 TOINCREASE O EB e Con Frontend 2 I Main Accessories Text Fields Description Unit cc E Bike dema model 470 3 Text Tour Bike bahia ladies Mother af Pearl 1 Frame lady s bicycle steel 1 Saddle standard 1 Socket Front standard 1 Bell 1 Drum brake 2 Handlebars aerawing 6 11 7 Columns cols Both the cols style and the rows style are always used in combination with the multiline style In the previous section we explained the multiline style The cols style will determine the width of the multiline text box In our example the quantity entered in t
3. e Select Query ID HANDLEBARS e At the properties tab of the query details you can see this Query is linked to Axapta InventTable the Items table HANDLEBARS details Table Invent able Dynamic Query Ma Order by Option Option Field Unique ID Field e f you link a Query to an Axapta table you can use the fields which are available in this table to add an additional filter for the query In the Field Name column you select the fields from the table you want to use and in the Option field the filter is added The Query uses the field Itemld and the option 180 Lines Field name Option e Con Label itemld 180 E DU Ex ND OTo Increase B V 141 TOINCREASE O 6 10 How to Define a Dynamic Query A Dynamic Query is not generated in the data structure but will be activated during configuration when triggered by an Query rule In this section we will show how a Dynamic Query is built e Go to the Entity BOM 1 and then go to the Entity Members by clicking on the Entity Members button H Entity Member Member Type Relation FRAME Generic Model BIKE Version Code 1 T ffe Overview Field Method Relation e Lon Label Segu Member Type 5 2 LINENO Field Property LINETYPE Field Property CONSUMPTION n Field Property QUANTITY Field Property UNIT Field Property BOMID E Field Property DIMENSIDNNU rj Field Prop
4. Rohe E tj Modeler Cost accounting E ML Labels Cost purpose calculation amp Model Table Link see E Context Transition Basic EJ Styles Administration EE Platform e Con Generator Solution Center Select every language you want to have available in the Front End here BS e Con Languages Lang Description de German Standard Ean AT sh s AN engb EndisUK nl Duteh Standard Language Language id Pick one of the languages from the list Description Description of the selected language CultureCode OTo Increase B V 112 TOINCREASE Select the corresponding windows culture name for the particular windows language here Clicking the assist edit button will auto pick the corresponding culture code Enabled A check mark in this field indicates this language is activated When the language is enabled in this way it can be selected when generating the data structure or starting the Front End 5 2 36 Parameters The parameters form can be found in the e Con Main Menu under Setup Parameters E Main menu e Con 3 5 Company tst Seles General ledger 1 Solution Center E My alerts Accounts receivable Lg views pours Baeble iam a Projects BLOG ACH AIS UCP E
5. Envy BeforePost not setarg saveas OBIECTID Operators ELSE amp as le Not amp nd Or In If Switch ll To Increase B V 222 TOINCREASE O Chapter 83 e Con Studio For a detailed description of the e Con studio see the document e Con 3 5 e Con studio User manual To Increase B V 223 TOINCREASE O Chapter 9 e Con Tasks For a detailed description of the e Con tasks see the document e Con 3 5 Tasks Description To Increase B V 224 TOINCREASE CE Chapter 10 Troubleshooting This chapter explains how to address error messages First we discuss the quickest ways to address commonly occurring error messages like There are errors in the rules Unfortunately sometimes other sorts of errors also occur like Loop detected or simply a model not performing as you expected In the second section of this chapter we will outline a procedure for addressing these other types of errors 10 1 How to Solve Errors in the Data structure after configuration When there are errors it is shown in the Configured Models list T us Siegel Hop HEFE mhr demo model ME PEE Deena Gae Ho aian bren Vern ere Gens k BIKE Eie sro rida 1 P2203 TIL CRTI Customer R TRE 19417 FRDHT Fhehaal Dara Hati l SE T3 TES BDE hi bee i 125m 147222 WTL Cuzinmar iEn iEn TEST tocco E Configured Models eCon Model ID 60 Version 1 Generic Model BIKE Ss eLan M
6. UE Center The following functionality can be set up here To Increase B V 120 TOINCREASE O e Table environment Information of the Axapta Context can be passed to e Con by means of arguments These arguments can be read in e Con with the function GetArg The Axapta Context can for example be the Sales Line The field custaccount can for example be passed to e Con and known in e Con by using the GetArg function to read this argument e Table link Additional information can be populated in the Axapta Context after e Con has returned to Axapta The Axapta Context can for example be the sales line Fields like quantity and config id can be populated by the e Con model after e Con returns at the sales line 5 2 39 1 Table Context Tab Table Link EE Table Contest Table Environment Table Link Ronee Model sun N s of table SalesLine smm uatatianLine Generic Model Select the Generic e Con model where table link information must be added Version Select the version of the generic e Con model where table link information must be added Name of table Select the table s where table link and table environment information must be added Typically tables in this areas are salesline smmquotationline OTo Increase B V 121 TOINCREASE 5 2 39 2 Table Environment Tab Table Link Table Context Table Environ
7. Frontwheel C 7 16 How to add and change Buttons in the Front End of my model In the e Con front end several buttons are standard available depending on the content of the field Buttons in the e Con Settings UI Settings Buttons PBRE Each letter represents a button in the UI The next letters and corresponding buttons are available How and Why Expand all All Collapse O To Increase B V 206 TOINCREASE O Print Process Save of XML document at file system and process document in Attain Restart Exit Save Save of XML document Save template and exit Post Post and exit As mentioned those buttons are standard available in the Ul However it s possible to change the buttons The ordering can be changed buttons can be skipped extra commands can be added to the buttons and new buttons can be added In this section is explained how buttons can be add and changed e First add a new entity with the label BUTTONS The entity table is not important so just select one Xx Oo unmszscuc H8 Entity e Con Label BUTTONS Generic Model BIKE Version Code 1 mata Table Name Li e Con Label Type Action on Duplicate BOMT able 2 BOMT able Class Abort if found Generate Key Fields BOMYersion 2 BOMVersion Class Abort if found InventT able BUTTONS Class Abort if found InventTable 1 BIKE Class Abort if found InventT able 3 InventT able Object Abort if Found e When e C
8. With update the Initialize property can be opened If the model is not using the optimized launch all the rules are executed during launch startup of the model When optimized only the rules in the Where Used of Initialize will be executed BIKEAXA 17 3A BIKEAXA E Bike amp xapta ig Environment E Arguments Initialize BeforeFost AfterPost User Role Context E E E EN 4 In an optimized model without Optimize launch all rule numbers are in the Where Used Properties n x me j Constant False Default True Enabled True Field Id Id Initialize Label Initialize Mandatory False Fart af interface False Store True Style Type Boolean Visible True OTo Increase B V 197 TOINCREASE O In an optimized model with Optimize Launch only rules with the Env Initialize condition are in the Where Used Properties n x me 24 Constant False Default True Enabled True Field Id Id Initialize Label Initialize Mandatory False Part af interface False Shore True Style Type Boolean Visible True 7 13 How to add a pop up screen Sometimes more information is needed in order to select an option out of a drop down menu in the Front end For example when a customer has to be selected it can be helpful to have more data shown than only the names or search name of this customer The address Zip code City name etc might better facilitate the selection of the r
9. has some invalid compile error arguments Argument 3 cannot convert from This message follows always the former string to bool messages This error indicates that the data type from the argument from the function is not valid Operator gt cannot be applied to Operators can not be applied to a string To Increase B V 234 TOINCREASE O operands of type string and string value Convert the string first to a double or long before comparing can take place Unreachable code detected It s just a warning and it can be ignored Could not write to output file The This mainly happens when the interface process cannot access the file because it model or a sub model is generated The is being used by another process dll from the interface is still used after ending the configuration process Close and reopen the Attain client to solve this problem nterface0 does not contain a The lt property gt as specified in the definition for lt property gt error message is a property from a sub model and used in the current model This property is missing in the interface for that particular model To Increase B V 235 TOINCREASE O Chapter 11 Glossary The main terms used are outlined below Generic Model The highest level of a generic model Label Name of the Version Entity or Entity member that is used in the XML document The description entered for the label is als
10. selecttirst true 200M e Certify and generate the data structure and check the result An extra button is added to the member frame to start up the pop up screen Frame l Q Frontwheel Item Rim Rim standard Number of Spokes 36 A E Select option Backwheel item Item Item Name Price Costs number Chain Item Wrst fe 1930 Frame lady s bicycle 4 600 3860 Http localhost J Local intranet 7 13 1 How to add to show my default former and actual option in the pop up screen Additional information can be shown in the pop up screen Information about Default Option e Actual selected option e Former selected option This information is shown as a colored bullet in front of the option The default options have a yellow bullet the actual selected options a blue one and the former selected option has a green bullet See the example below To Increase B V 201 TOINCREASE O Item Name Searchname Price Costprice Supplier 19n0 0 Frame man s bicycle steel MAN 4920 Frame man s bicycle ALU MAN ETT Option Web Page Dialog To add this functionality is not that difficult It s all controlled by just one style It s the style Optioninfo with value true e Select the member containing the style zoom e Add the style Optioninfo with value true EB Entity Member Style Style zoom 0 Generic Model BIKE Version Code 1 Table f amp amp
11. A product configuration can be used in a number of areas e Engineering e Production e Sales e Etc The end result can be a complete product specification object or a product specification that needs further engineering In both cases all possible end results must be first known and designed in the starting model Example A common car can have different engines and depending on the choice of engine different types of transmissions Depending on the type of transmission manual or automatic a different production robot is needed The costs will also depend on the components used and production methods employed Specially designed cars can be based on a common car but then with some parts engineered to meet customer specifications Like trucks for example The unknown part in the configuration is called a black box It requires further engineering before it is clear The Bike demo model is a typical example of product configuration 2 2 2 Sales Configuration A sales configuration focuses more on sales processes than on product data However product data can be a part of the configuration in addition to the sales order or quote The result of a sales configuration generally includes e A sales order or sales quote e Specific client information To Increase B V 10 TOINCREASE O e Sales prices e Product data A sales configuration can be used in many situations e Sales on line or off line e Telemarket
12. Status Status of the Generic Model selected within the project Table Name Table Name of the main entity of the Generic Model selected within the project Starting Date Starting date of the version of Generic Model selected within the project OQ To Increase B V 56 TOINCREASE O Ending Date Ending date of the version of of the Generic Model selected within the project 5 2 1 3 Fields of the Properties Tab details pane details Properties Description All model versions All model versions Two options yes and no If no is selected automatically the active version of the selected model is added to the project If yes is selected the model version to be added can be manual selected 5 2 1 4 Fields of the Description Tab details pane details Properties Description Description A description can be added here for the model added to the project 5 2 1 5 Project Button Get Model Version A list of models is shown A model can selected here and added to the project Generate XML Before the Generic Model can be used in the Front End and in the e Con Studio the XML document and Net assembly dll has to be created The XML document consists of the data structure and rules that are created in the e Con Studio The data structure is generated This can be done with the Generate XML function When this function is selected both the XML document and Net assembly dll are created for all models within
13. lt 7 Mountainbike Mountain Bike This query is not based on an Axapta table In the Option field the option list is stated When the member type is Additional Property the query is used as an Option field Now the Table Name is empty Use a different line for each option In the Option field the value before the semicolon otherwise known as the Option Description Delimiter is chosen but at the Front End the value following the semicolon will be shown The end user has the choice between Pearl Metallic and Chameleon The default value is Pearl 5 2 35 e Con Languages e Con Languages can be found in the Set up menu OTo Increase B V 111 TOINCREASE CE Ell Main menu e Con 3 5 Company tst Sici l Solution Center ndm E E My alerts Accounts receivable Fe Views EX NUUS E e Con DEUS papable E e caon Projects Inventory management E Models poc ie E Decision Matrices Reports Periodic Setup E Metadata group E Option Query Human Resources BE Cor je Questionnaire amp Parameters Beat w Import settings Master planning Praduetion Product Builder Shop Floor Control
14. 579 1 Configured B14 ET Configured C Configured Configured zu g Configured wer CO Contig 577 Configured be Oooo DIETE 5 2 6 1 Fields of the Overview Tab e Con Model ID e Con will automatically create this value It is a serial number Synchronize If set to Yes before Configure the model will be synchronized during reconfiguration Model Status The status of the model new configured etc Error This field contains an error code if there s a problem with a configuration To Increase B V 67 User ID User ID of the user who configured the object Last Date Modified The last processing date of the configured object Last Time Modified The last processing time of the configured object 5 2 6 2 Fields of the Link Tab z Configured Models No BIKE 1 Ho BIKE r SS 1 Overview Link Details Table Hame Record ID JinventT able la E Item number Bike OO0410 Bike O0 sales order 00034_036 Bike 000410 Table Name TOINCREASE O KES The table linked to the configured model This table is populated by this XML configuration Record Id The link to the actual record of the table Button Go to record Clicking this button will jump to the table and record selected OTo Increase B V 68 TOINCREASE 5 2 6 3 Fields of the Details Tab E Configured Models No BIKE 1 Ho B
15. BOMVersion we a B MVersian Itemid BOMld hee Name Approved ApprovedBy Active Frame Hide Setup Record info Edit node Delete node Copy node 16 Rename the CopyOfFrame relation and its entity to Wheel Also rename the Frame relation and its entity to Wheel 1 Modelling tree P Active LinieNum Hecld Itemld Urithd BOMType BOMConeump BOMO tp entDbuml d The result so far is as follows OQ To Increase B V 28 TOINCREASE O i Modelling tree z mmis Itemid ItemM ame ItemT ype Itemlaraupld DimGroupld Model roupld i Model J BOMYersion 5 4 BOMYersion be lternld BOMId Mame Approved ApprovedBy Active E Frame j E Frame Wheel E Wheel Add the folowing option e FRAME2 to the Frame relation to the InventTable e WHEEL to the Wheel relation to the InventTable To add the option queries to the relations 17 Add the option queries in the Option Query form The Option Field No must be ItemName ES Option Query Query ID New Record Overview Query ID Option Query Line Table Name Query IO D Description Option Field Ma ES m B Invent T able FRAME 2 E ItemName 18 Add the following option query lines ItemName Frame 19 Actually add the option queries to the relations Once the data structure is finished you can certi
16. HTML description Value Description E zoom true aptieninfa optioninfa 7 14 How to add Tabs in the Front End of my model Sometimes when there are too many fields in the Front end it can be useful to present them in a more structured way Classifying these fields into tabs can help us in such situations Within each tab a logical grouping of fields can be displayed This offers a better overview of all fields available in the model The way of creating the tabs is described hereunder e First add a new member with the label TAB The member type is additional property To Increase B V 202 TOINCREASE CIS aB ms HIKE 7 27 1 Entity BIKE sol Khi Stop Proce e Add a query to that new member The options of the query represent the tabs in the Front end In this example three tabs are chosen Main Accessories and Text am O TABBIKE Option Query PES General Table Na Query ID ITABBIKE Description Tab Bike Option Field Ma Order by Option Value Dynamic Query Filter Field Description Option si Main MAIN Acc ACCESSORIES Texti TEST e Certify and generate the data structure e The Last step is to add intelligence that will control which fields are to be displayed on which tab Start the studio and add a new rule See the example hereunder In this example the member Category is only visible within the tab Main OQ To Increase B V 20
17. NOTE the key style is the same as the orderby style e Select the BOM Entity BOM 1 and go to its Entity Members e To select the style for the Entity member labeled FRAME select the Styles button EB Entity Member Style Style key 0 Generic Model BIKE Version Code E E Style HTML description Value Description selectlirst selectfirst OTo Increase B V 146 TOINCREASE This key style is activated for field ItemName In the column labeled Value Description you enter the field you wish the key style to have an effect upon NOTE There is no lookup button in this column with which to find field numbers 6 11 3 Auto expand autoexpand The autoexpand style will automatically expand a relation which has been set by a rule causing it to appear in expanded form in the Front End 6 11 4 Go to the BOM Entity BOM 1 labeled FRONTWHEEL and go to its Entity Members z Entity e Con Label FRONTWHEEL Generic Model BIKE Version Code 1 Seles Table Name Lin Con Label Use Action on Duplicate vi BOM 1 FRAME No Stop Process TUUM FR a nm EL i Class Stop Process BAKWHEEL EES CHAIN Clas No Stop Process SADDLE No Stop Process LIGHT Clas IN Stop Process BELL Cla No Stop Process BRAKE Stop Process J HANDLEBARS Class No Stop Process MUDGUARDFRONT Class No Stop Process MUDGLI
18. TOINCREASE O Axapta I ntegration User Manual Project e Con 3 5 Author To Increase Company To Increase B V Date March 16 2006 TOINCREASE Document Information Document nomber BEEN Last saved 1 1 1601 1 00 Revision history pe 0032006 frea LL a Copyright 2005 To Increase B V All rights reserved The information in this document is subject to change without notice No part of this document may be reproduced stored or transmitted in any form or by any means electronic or mechanical for any purpose without the express written permission of To Increase B V To Increase B V assumes no liability for any damages incurred directly or indirectly from any errors omissions or discrepancies between the software and the information contained in this document OTo Increase B V l TOINCREASE O Table of Contents Chapter 1 Getting Started ERR T T TII 8 1 1 O O METRE TERT TET 8 1 2 IETS Trea NO RETE EUNT 8 ei MI SEQQ m 9 2 1 SCRITTE UT T m UU MTM 9 2 2 Connu radon PrOCO S E m HE 9 21 PIOducr COMMON QUO arrin nE E IE 10 22 2 ECON a O a A aad den rd ues 10 22 3 Customer ConNguUraUO sesser nS EE ENEE a a c a ERR 11 2 3 AONE nse r EE AE G E EE EEE E S AU CIA 11 2 3 1 Important Conceptual Features of e Con ssssseeen me 12 Chapter 3 How to Build Your First Model ssseeenn mmn 15 3 1 Overview of e Con Modeling eeeee mmm 15 3 2
19. Type Controlclass and Labelclass 6 11 30 Format With the aid of this style the format of an e Con Field in the UI can be controlled in a way that texts or signs can be added in front of a field or behind a field This can especially be used when a unit of measure must be displayed behind a field as shown in the figure below G Weight Kg In the value assigned to the style 0 indicated the property That means that when a certain character of text must added behind a field the value must start with 0 followed with the character of text to shown Displaying text in front of a field means that first the text followed by 0 must be keyed in 6 11 31 Copy With the aid of this style it s possible to copy a repeatable entity When an entity is repeatable a button new automatically appears With that button you can add new entities However standard there isn t a button to copy repeatable entity By applying this style with value true to the repeatable entity an extra button is added to that member Clicking this button will copy the particular entity OQ To Increase B V 156 TOINCREASE O iniu DUE Accessory Accessory filter Accessory item w a pg E i 6 11 32 Select Single The style labeled selectsingle will auto select the value when it s the one and only value left In other words When there is just one option left in a list this option will be selected automatically when this style is app
20. cccecec cee ececeee ee ee ee eee eee sees mmm nenne nnn nennen nna 63 5 20 amp ConModelfonn BUON Steve E Eo TT 66 52 0 Configured MOQ IS sssusa iaaa Epin ertia 67 5 2 6 1 Fields of the Overview Tab ccccecscscseseeceeeeeeeeeeaeavaueeeetersretereeaegees 67 Os PICS or the LNK LaDisssvenvaenpiascreteirsintem geras qe tenitiag Vupixride Pd ER E CETES 68 520 3 Fieis Of 35 NE om iea E N 69 2 7 C niNgu red Model BUNS zovscisevatet oxuie oim aetas bcd a Aa or 69 OTo Increase B V 2 TOINCREASE O DAS KOy VAUC eorna r EnaA E EENE REENE 70 5 2 9 Entities button on Generic Model form only available when the version is under development M 70 5 2 10 Entity form Buttons ccccecececsceeseeeeeeeeeeeeeeeeeeeeeeteteeetaeeresarsererstereees 72 52 11 EMUEY Member TOIT iccicivecrsaansoncceverntsalaterehqadnenacadidlneataasiiaanaanmiecantianeis 73 5 2 12 Fields on Overview tab ccececsececececetereretevaueueeeeteeeeeaesuaureretsrsteraneeees 74 5 2 13 PEUS OMF IOT O ree OAT 15 5 2 14 FICIGS on MEMO EaDuiseiavimtesidrepiase bir v EIER ESTES ERI VEO TE VP RPEYR EO PTE YET Ras dan 71 5 2 15 Fields On dROlBHOn LAD oisesissiusevivexi i dank Ve PEVE EEOAE 78 o2 d6 En ty Member BURON cceisaeredkptas neben Rn HERD a EPIBLER Uh E RE pad 81 5 2 16 1 vac M 81 5 2 16 2 did 82 5 2 16 3 TADIS REIGO aussen ne nn e
21. i Rules Front End Configuration o 9 Fill Connectian C3 10 Pass data to Frontwheel Sub Model 11 Generate description C3 12 Max Repeat D 13 Category Model and Type fired 463 14 ConnectionFilled D ve 19 Set options Bike Category 16 Retrieve weight trom Matrix o 17 Set options Bike Model ry yr 13 Accessory D x Routing Bill of Material Reset filters Defaults andatory Pricing Text Images QUEEN TRECE Id Frame choice Label Frame choice Condition TYPE lt gt Implication BomVersion FRAME FRAMEITEM options 2 Gert Oprtions BomVersion FRAME FRAMEITEM True CONNECTION InventTable NameAlias TYPE e This rule activates the function GetOptions This function read records from the InventTable using the filter NameAlias equals TYPE 6 11 How to Add a Style In this section we will show you how to define a style The various kinds of styles will be described 6 11 1 Select First selectfirst The style labeled selectfirst will always select the first value available The Value Description must be set to True in order to activate the selectfirst style This style is OTo Increase B V 144 TOINCREASE often used in combination with the orderby style To demonstrate the functionality of the selectfirst Style we will use the Bike Model e Go to the Entity Members of the BOM Entity BOM 1 EB Entity e Con Label FRAME Gen
22. Bank CRM Accounts receivable Accounts payable e Con Projects id Models Inventory management 2 Decision Matrices Master planning i 9 Reports Periodic a Setup Metadata group inducen Fraduct Builder Shop Floor Control UE eT S AFF TE d Option Query i amp Con Languages id Parameters Sj Import settings s Modeler Human Resources Cost accounting ML Labels Questionnaire Project Cost purpose calculation Model Table Link Piss ij Styles Administration E C Platform E Con Generator E olution Center E Within this menu context transition can be determined A context is a business process context in Axapta Two contexts are supported yet e Quote Context when e Con is launched from a CRM quote e Sales order Context when e Con is launched from a sales order With the context tranisition it is possible to launch e Con in the back ground when a transition takes place from one to another context An example When the context is quote the e Con model will not create a Bill of Material and Routing However when the contex is sales order the Bill of Material and Routing are created By setting up a context transition from quote to sales order the e Con model is recalculated in the back ground when the CRM Quote is converted into a sales order During this recalculation e Co
23. Dices by Ol pica ae BACEHEEL BALPLAME pier Feti Ure ID Field e n the right pane you can see how an Option Query is set up There is no link to a table because the choices given are not available in a table That s why Table Name and Field names are empty In the Option column the choices the end user can pick from are listed The values in this column must be constructed in one of two ways a popular Popular b 1 Popular The first term is used in the Studio popular if you use method a 1 if you use method b the second will be displayed in the Front End Using method b for example means 1 is used as a label in the Studio This carries the advantage of a short name in the Studio but method a can be less confusing since you can see directly what term it will display in the Front End 6 9 How to Define a Query Related to a Axapta Table In this section we will show how a query related to a Axapta table is defined e Go to the Setup menu and select the Option Query option 4 Periodic Setup z Metadata group 2 amp con Languages 2_ Parameters amp Import settings Modeler OTo Increase B V 140 TOINCREASE O ExTILD HR LE MARS HRIDPAITEMS Liner BFIDFRDITM OE Les CHELI Fred re H amp LE MLAS CHERE amp ltewdd Hade Proper be Cigla Ne ocripispn Table reed T able Dpr Diei big Dicks by CPC in Opie Fmid Bortimra Uripo Field
24. InventT able InventT able 2 In this area the entities of the model are shown With Ctrl N new records Entities can be added to the data structure see 5 2 13 When selecting an Entity in this part of the form with the New button new entity members can be added to the entity With the Edit button the entity can be maintained see 5 2 13 To Increase B V 64 TOINCREASE O 1 Modelling tree AUA MYBIEE DESCRIPTION MODEL ITEMTYFE ITEMGAOUPIC y y INVENTDIMID INVENTMODGROUP BOMVERSION E BOMVERSION RECORDID NAME APPROVED APPROVEDBY ITEMID ACTIVE BOMID FROMDATE NS BOMHEADER FRAME WHEEL 33 a a a a a 4 E E E Parts of the data structure can be expanded to select the right Entity or Entity member Selecting an Entity e g BIKE with New Entity members can be added and with Edit the Entity can be changed see 5 2 15 Selecting an Entity member e g MODEL with Edit the Entity member can be changed see 5 2 15 Selecting an Entity or Entity member with Copy the Entity or Entity member is copied The new id of the Entity or Entity member will be Copy of With the Find can be searched for an Entity or Entity Member within the data structure Selecting an Entity or Entity member with Delete it will be deleted from the data structure Selecting an Entity or Entity member with Ctrl T or Ctrl J the sequence in
25. Options that are generated are shown To Increase B V 90 TOINCREASE mia EB Decision Matrix Option e Con Label FRAME Decision Matrix MYBIKE Ver EBJE Overview Option Description Frame man s bicycle steel Frame lady s bicycle ALU Options can be added manually With Hide in Matrix options can be left out the decision matrix Decision Matrix Link The form were the relation between the options can be entered Is opened To Increase B V 91 TOINCREASE E Decision Matrix Decision Matrix BIKE 1 Decision Matrix BIKE e Con Options Con Label Option Option Description CATEGORY k Citpbike City Bike CUSTOMER Mountainbike Mountain Bike Sportbike Sports Bike Tourbike Tour Bike Related Options for CATEGORY Citybike Con Label i Link Values LATEGURT r JE CUSTOMER Link Default Option Option Description E E bahia gt gt B ahia T extreme extreme Eee Extreme am glo Goto X instinct Instinct nm medeo Medea E Hu playa Paya Playa v pa pular Popular torrente trente Torne OOOO Torente E tranza Tama 00000 ultimate imate 5 2 23 6 Link Tab Link The valid option for the upper part selection can be set here In this case popular and tranze are valid options for the Category Citybike Default The default option for the upper part selection can be set here In this case popular is t
26. Properties e Constant False Default Hain Enabled True Field Id Id TAB Label Tab Length 0 Mandatory False Part of interface False Store True Style Type String Member Wizard X Expression Builder Properties There are three fields in the e Con settings that have effect on the optimization of the model o Optimize launch With Optimize launch only rules with the Env Initialize condition will be executed This offers a faster start up of the model See the next chapter o Optimize lowerbound If there are repeatable entities in the Model Arrays the Array Lowerbound must be filled up The value is always O This is the also the default value o Optimize upperbound If there are repeatable entities in the Model Arrays the Array upperbound must be filled up as well The value depends on the highest array index used in the model The default value is 2 but if there are rules with an index higher then 2 this must be changed to that value E g if there is a rule containing the expression Accessory 14 13 the Array upperbound must be 14 O To Increase B V 196 TOINCREASE Modeler Settings Optimize launch C Yes No Non transactional r Yes No Optimize lowerbound f Optimize upperbound 2 MBS metadata URL C Program Files e Con 3 5 Data Datasources NavisionMetadata xml 7 12 Optimize Launch detailed information In the data structure is an Environment relation One of the members is Initialize
27. and can have four values Left Top Right and Bottom With this style the position of the image is set When Left or Right are chosen the image area will be shown at the left or right hand side of the Front end without overlapping the questions and answers fields With Top and Bottom the image area is shown above or under the Front end 6 11 12 Image Left imgleft This style is only used in combination with images After determining where you want to have the image right left bottom or top on the Front end with imgposition style you can go further and determine where exactly you want the image to be positioned in relation to the left margin of the image area 6 11 13 Image Top imgtop This style is only used in combination with images After determining where you want to have the image right left bottom or top on the Front end with imgposition style you can go further and determine where exactly you want the image to be positioned in relation to the top margin of the image area 6 11 14 Image Height imgheight This style is only used in combination with images With this style you can determine the height of the image If you do not specify the Image Width see below this style will scale your image to the proper dimensions 6 11 15 Image Width imgwidth This style is only used in combination with images With this style you can determine the width of the imag
28. button on the Entity form To Increase B V 132 TOINCREASE O A Key Value is a default table record template for the Entity that serves as the model for the Front End The fields which are not entered in the Front End will be copied from the default table record you selected The Key Value you define will also activate the Front End in certain sections of Axapta z Entity Key Value Key Value 1000 Generic Model MYBIKE Version Eme kep Value Field Name For example In the Bike Demo Model the item e Con Bike is defined as a Key Value This means that when you fill in a Sales Order and use the item e Con Bike in the Sales Order Line the Front End of the Bike Demo Model will be activated See also chapter 4 4 6 4 How to Change the Status of a Model The status of a model can be any one of the following New When a new model entered the default Status is New When a model has this Status New it cannot be used for configuration Once the Status has been changed to Certified Under development or Closed the Status cannot be changed back to New Under Development This Status is used when making changes to the model changes cannot be made if the Status is Certified or Closed Certified When the Status is Certified you can generate the data structure or start up the Studio or begin to configure Closed This Status is selected when a
29. functionality Then when you deal with different versions of the same model you can use the description field to highlight any special functionalities which set that specific version apart from other versions 6 2 3 Version Label In the Generic Model Version List you must enter a label for your version The label name you enter for this version will be used when generating an XML document The XML document will be generated and saved under the name of the Version s label For example in our BIKE Demo Model we entered the name BIKE in the Label column Upon generating the data structure the XML document called BIKE XML will be saved to disk This XML document contains the data structure of your model Tips amp Tricks You cannot use the same version label for different active versions 6 2 4 Entities You have to link a model to a specific table in Axapta This linking is accomplished using the Entities In effect you are telling the model which table structure to use with all its fields as well as what it is we are going to configure in e Con be it customers items or To Increase B V 129 TOINCREASE O something else In the Bike Demo Model a link entity has been made to the InventTable of the Axapta database Every Entity has a unique Label which is used in the XML document You can go to the Entities by clicking on the Entities button on the Generic Model form n l k Model Setup Benere Madel version
30. Additional Property TYPE Additional Property 90 SPECIALCOLOR Additional Property COLOR Additional Property IMAGES Additional Property MODEL Relation 40 BUTTONS Field Property Itemld i OOO sO0008 SIE i LCILDILERISTLDILBILBALSILST ET ooog f aoaoga Field Property ltem ame ERISIRISIBIERI RI RI RI gagaaaaaananB Field Property lhern Type 5 2 12 Fields on Overview tab Member Type There are four options Field Property link to a table field Additional Property field that does not exist in the Entity table but is used in the Front End and or in the e Con Studio Relation relation to another Entity Display method link to a table display method foeld Sequence Determines the shown sequence in the Front end during configuration The step size in Setup Parameters in used to determine the steps e Con Label Label of the Entity Member Using this label you can see which Entity member you are working in the e Con Studio The code of the label is used for reference in the rules the description is used in the Front End It makes the Entity Member unique in the XML data structure file Editable Checkbox for whether this member is editable in the Front End Mandatory OTo Increase B V 74 TOINCREASE O Checkbox for whether this member is mandatory in the Fr
31. Entity Arrays make it possible to just create one rule for every member of the Repeatable Entity Solving the above problem with an array requires the following rule Index Zn of REPEAT REPEAT n DEFAULT defaultvalue n the first rule the index is declared In this example the name of the index is n But it can be defined by the user The syntax has always to be Index of entity Enter the user defined name of the array where the dots appear Replace entity with the Repeatable Entity NOTE if you select this Entity with the drag and drop functionality the index 1 is added automatically J ust delete this index 6 14 3 How to Control Arrays It s possible to control an array by setting up how many Entities can be added This effectively means designating the maximum number of members the array can have In the Bike demo model for example the maximum number of different accessories is three After clicking twice on the button for a new one this button simply disappears At that point it s impossible to add another New Accessory This functionality can be added to a rule by using the repeat attribute Take a look at the bike example before reading further Implication index n of BomVersion ACCESSORY 3 BomVersion ACCESSORY n repeat n 3 The first step is to define an array Explained previously Next add the repeat attribute to the Repeatable Entity This attribute
32. Frontwheel Demo Model Overview General Mn Inte Description Active Version Generation Gene BIKE Ma Bike demo model 1 14 10 2004 17 05 33 reve t FRONTWHEEL No Frontwheel Demo Model 1 14 10 2004 17 05 04 Model Setup Version Description e Con Label Status Table f Frontwheel Demo Model FRONT WHEELAMA Under Development e On the Import data form select the to be imported model s xml file the duplicate action and click OK B Import data File name D 4xaptasD atas FRON Tw HEEL O02 mil 3 Abort if found Use existing Replace Create new key Delete Duplicates 7 4 2 Model Export To export a model e nthe Generic Model form select a model e Select a version of the model OTo Increase B V 179 TOINCREASE CE e Click Save as ES Generic Model No FRONTWHEEL Frontwheel Demo Model Mn Inte Description Active Version Generation Gene BIKE No Bike demo mnde 17 06 33 FRONTWHEEL No Frentwheel Demo Model Model Setup Meee Generic Model Version F FRONTWHEELAXA Under Development e Con Modeler Configure Copy Model Version en JT smes Ky eh e Specify the folder in which you want to store the model export file e Enter the file name e Click Save Save in De m My Recent Documents FAON THEEL_OO2 xml v E pee My Network Saveastype XMLETlestmp wj 7 5 How to Copy a Model To
33. How to Create Your Generic Data Structure ssssssserersrrrrrrerrrrnrrrrrrersrrrrne 18 3 3 Add Your Business RUIES 0 mmm nnns 32 Chapter 4 Integrate Your Model into Your Business Process seeeennnn 52 Chapter 5 e Con Axapta OvervieW csisiuces cxiceorea ance medo ria Eu co Re RUE E REPE ea sida ad 55 5 1 Purpose of Axapta e Con Module sseeeennmenm mener 55 5 2 gm 55 oy el FLOM c M c 55 5 2 1 1 Fields of the Overview Tab ccccecscscseseceeeaeeeeeeeeeeavaueuestetersteeeeaegees 55 5 2 1 2 Fields of the Model Version Tab seeennm 56 5 2 1 3 Fields of the Properties Tab details pane seseeneee 57 5 2 1 4 Fields of the Description Tab details pane seen 57 Du 1o PIOIGCEBUECODI usando dtactadihe E HU PEREER LERNEN ED EE PI 57 5 2 1 6 Model Version ButtOn cccccccecscseseseseseeererseseevaeeseetersteeseetseranteress 58 SV MEE delue m m TIU UU TT 58 Ded GRMENIC MNOGO m 58 5 2 2 1 Fields of the Overview Tab ccccecscscseseeeeeaeeeeeeeeeeavaueeeetersrerereeaeaees 59 5 2 2 2 Fields of the General Tab cccccccccsesecseeeseeeeeeeeeeeeseeaeeaeeeeneeeseeetens 59 5 2 3 Overview on version sssssssssse mmm nennen mene ranae 61 5 2 4 Model Setup Button on Generic Model form only available when the version is under development
34. Item for setting up the relationship between the item and the relevant BOM version In Entity BOMVersion BOM version there are a few relations as well to set up the relationships between the BOM version and the BOM Header entity BOMTable and the BOM Lines entities BOM See the figure below for the data structure hierarchy To Increase B V 16 TOINCREASE O Generic Model Card Entity Entity Entity Entity Member Entity Member Entity Member Entity Member Entity Member Entity Member Entity Member Entity Member Entity Member Once the data structure is complete it will be translated into XML by a special function called Generate XML An XML file is then created with the data structure in it All the Entities and the members are available in the XML file and are represented by labels The XML file does not have Entity numbers table numbers or member numbers field numbers Instead everything is based on labels Consequently when you are building the data structure you have to add a label to every Entity and member Always use a descriptive label because this makes it much easier to create business rules later on For example we will add the label NAME to the field property of Entity CustTable Customer that we discussed before So labels are always added to your data structure for these reasons e Labels are used in the XML file to represent the Entities and members e The label descript
35. Item group DimGroupld Dimension group ModelGroupld Inventory model group MODEL Model Moutain Bike Mountain Bike Road Bike Road Bike Folding Bike Folding Bike Hybrid Bike Hybrid Bike Indoor Bike Indoor Bike Kids Bike Kids Bike amp id MODEL amp label Model amp column True amp constant False amp default Moutain Bike amp length 20 amp mandatory False repeat True amp store True style amp visible True amp options eCon Base E ConCallection 9 BOMYVersion BUM Version Env Environment Rules Columns tig Libraries Interfaces 46 TOINCREASE O e Replace the right lt expr gt expression code of the rule with the RoadBike option The options can also be retrieved from the data structure Just click MODEL to expand the list MODEL Model Moutain Bike Mountain Bike Road Bike Road Bike Folding Bike Folding Bike Hybrid Bike Hybrid Bike Indoor Bike Indoor Bike kids Bike Kids Bike E m m F i o Er Er Ee A 8 e IO Condition true Implication MODEL default Road Bike e Check the results by using the Browse function to view your model 4 The rule we will add next will add dependencies between the model and the default for the frame If the model is Kidsbike then the default for the frame should be 1920 Frame man s bicycle ALU for all ot
36. NEEMNEMNM L JGEEPEPEEEEEPEEEEEEEEEEEIHNUERUR e Go to the Versions and add a new version O To Increase B V 188 TOINCREASE CE E Decision Matrix Decision Matrix BIKE Overview Version Lines D ecision Matrix D escription Active Version MYBIKE My bike MTS e Select the new version as Active Version for the Decision Matrix E Decision Matrix Decision Matrix BIKE Overview Version Lines e Con Label Table Name Query ID Generate Op CATEGORY Xem i maaan Query ID Table Name A BIKECOLOR en BIKEMODL o BIKETYPE e e Go to the Version Lines tab and add the Option sets Add a new line with CTRL N Select the e Con Label Table Name if the query is based on a Axapta table and Query ID anges Options E Decision Matris Link e Generate the options with the Generate Options button and view the options To Increase B V 189 TOINCREASE E Decision Matrix Decision Matrix BIKE Overview Version Lines e Con Label Table Mame uere ID CATEGORY CEO k MODEL BIKEEMODEL 3 a AATF PPE SEDAN SP Ta Pe RE DOE POPE RE PE LTE DOPE EE e Add a second option set e g MODEL Generate the options and check them with View Options Go with Decision Matrix Link to the form were the dependency between the options are set EB e Con Decision Matrix Decision Matrix BIKE e Con Options e Lon Label i Opt
37. O 5 2 22 Save as Button With this function an export file for the selected model version can be made to be imported in another Axapta database Save As Save Im 4 My Computer v O m P 5 h 3 DYD RAM Drive F re See Data Dr My Recent Sa Local Disk C Documents Desktop My Documents hy Computer a File name Yo Model m My Network Save astype XML Files xm v 5 2 23 Decision Matrices A Decision Matrix is used to set up interdependencies between member options You can find Decision Matrices in the e Con menu by going to the Decision Matrices OQ To Increase B V 86 TOINCREASE MS Main menu e Con 3 5 Company tst General ledger fi Solution Center CRM E Accounts receivable ES VIEWS pects pare E e Projects Inventor management daz mu z ecision Matrices mea se ES Reports Production n Periodic Product Builder ES Setup PEE Et Platform Master planning Shop Floor Control Human Resources Questionnaire Project Cost accounting Cost purpoge calculation Basic Administration amp DLan Generator Solution Center It is possible to determine more then one decision matrix and every decision matrix can have one or more versions 5 2 23 1 Overview Tab EB Decision Matrix Decision Matric AYAKE T Deecisom Matrix BUY ES IKE Orem Decan bgt arpan Lara BIKE D eciann Mate Bike wesc 1 Ebonn eon Decision Matr
38. Overview Version Description Con Label Status Table Name Foot Starting Date Ending Date My Bike version MYBIKE Dm InventT able e Go to the Generic Model line and select the version as the active version for the Model ES Generic Model No MYBIKE My Bike Inte Description Active Version Generation Gene My Bike 26 10 2004 00 00 00 3 Set up the model e n the Generic Model form click Model Setup Model Setup a Configure Cave a mW BEEN To Increase B V 19 TOINCREASE O e The e Con Model form appears BE con model Ho MTURL Gerrit ok rtk Fate nh oh Fijrrrasazm E acras T Every record in Axapta has one or more fields that are strictly necessary They are called key fields So because we want to insert records into the Axapta database we have to take that into account Those key fields are field properties that we need anyway So the Modeler does not have to find out what the key fields of every table are The root entity s key fields are automatically entered as field properties In our example the Itemid property is the InventTable s key field e Rename the tree To do so in the Modelling tree right click InventTable and click Edit node i Modelling tree Record info Create new node k Delete node k e Change the e Con Label In our example the new e Con label is MYBIKE H8 Ent
39. US 122 5 2 39 4 EO CE NI EE o 122 5 2 40 Context TTaDSIUODuconxexevibtzciater ki du e CREREC OE RE Hot ol ed or virer bei ends 123 DV MEE I em 124 Chapter 6 e Con Axapta Connector Data Structure sssseseenn 127 6 1 econ Eel sie METTE UT 127 6 2 Various Data Structure Components ssssssseeeen mmn 128 Zak US NE 128 MA MER c mE 129 62 3 VERSION aD a O 129 ize 129 D 2 5 Ent MOM OSES uessxdtbetisatitoRp d aka Postera aiit he RERE p ERANT DATROE UE DIOE 130 6 3 How to Define a Key Value usevesuskadosbptxexisn nn utut Cupt iuredus lkiie 132 6 4 How to Change the Status of a Model sss 133 6 5 How to Add a Number Series to Your Data Model sseeeeee 135 6 6 How to Change the Order of the Entity Members seeennnnnnm 136 6 7 How to Define or Add a Query ssssssessenennnem mene nene nennen nnns 137 6 8 How to Define an Option List sss 139 6 9 How to Define a Query Related to a Axapta Table sseseenee 140 6 10 How to Define a Dynamic Query esssseenn mmm 142 D IL BoAuIo40gd 35 P IBerssrcrer UTERE DERE ieee ern orn earnest eee 144 6 11 1 Select First selectfirst cccccecececeeseseeeeeeeesreeseeeavaeeeeueersrereretereregs 144 6 11 2 Key KG aiuauesixazudsutathets rix eProps Mexx tx bardxs RM pENUESI UU
40. can either have the value true or false When the value is true the New button is shown in the Front End when the OQ To Increase B V 166 TOINCREASE O value is false the New button will disappear The expression Zn lt 3 delivers a value of true when the array is smaller then 3 members and false when the array has 3 or more members thus making the button disappear in the Front End Furthermore it is possible to set the number of members of an array that will be automatically displayed in the Front end By adding the length attribute to the repeatable Entity the number of repeatable entities can be set For example Implication Bom ersion AcCcESSORY length 3 Thanks to the rule above three members from the type accessory are automatically displayed in the Front end al Accessary d Accessory gt J Accessory Copying and deleting array elements in the UI is possible as well By adding the style copy and or delete with value true to the repeatable Entity a copy and or delete button is displayed in the UI Clicking this button will make a copy of the entity or delete the entity H8 Entity Member Style Style button 0 Generic Model BIKE Version Code 1 Helk HTML description Value Description The copy and delete button in the UI Accessory gO 22 B Accessory 229 B Accessory gO 22 B 6 14 4 Special array functions There ar
41. enter MODEL lt gt e Select the Implication field Enter the sign and select the Qvisible attribute in the left lt expr gt expression code Select the member that represents the relation of the BOM Version to the BOM Line of the wheel To Increase B V 48 TOINCREASE Object Explorer Aa Objects Se MYBIKE 1 13 My Bike Itemid ltem number ItemName Item Name ItemT ype Item type Itemiaraupld Item group Dim raupld Dimension group ModelGroupld Inventory model group MODEL Model BOMYersion BOM Version BOMYersion BOM Version Itemid ltem number BOMId BUM Name Hame FRAME Frame E E TE NU EU EU E RU BB dee ee Hh E E A e Replace the expr expression code of the attribute with this member e For the rest of the implication ente the visible attribute Implication BOMVersion Wheel visible lt expr gt e When True is assigned to the visible attribute it will cause the relevant member to be visible False will cause it to be invisible The expression MODEL lt gt Hybridbike will also result in a true or false answer so this will work Id Wheel injvisible Label Wheel in visihle Condition MODEL lt gt Implication BOMVersion Wheel visible MODEL Hybrid Bike e Check the results by using the Browse function to view your model 6 The last rule we will add is If the M
42. from the Generic Model Version button Model Setup Genenc Model version FF Entities onc uda Configured Models l Contigure Copy Model Version l 1 ES Model Interface No FRONTWHEEL 1 No FRONTWHEEL Interface Model nterface V Description Frontwheel Demo hM odel OQ To Increase B V 160 TOINCREASE O e Finally generate the data structure for the submodel Frontwheel 6 12 2 Set up the link to the sub model in the data structure of the main model The last step is to set up the link between the main model and the sub model including a sub model in to the main model This is done with the aid of a so called Relation member type e Add a Relation to the entity in the main model where the sub model must be included e Con Model No BIKE Designer Modelling tree i intemal model entities rer Ls Table Hame Ea ide naia Setup Address 2 Record info BOR 13 Additional Property Delete Field Property Delete node Method Mame 5 EE us F S3FELIBLLULUT E COLOR jm Copy m Itemid 4 Entity key Fields E ItemName Entity mandatory Fields ibl ItemType E In our example the Bike m
43. id 1920 label Frame man s bicycle ALU visible True p 3A default False mE 1930 Frame lady s bicycle ALU E PB Frame Frame for shades id FRAME label Frame e Enter in the right lt expr gt expression code MODEL lt gt Foldingbike OQ To Increase B V 50 TOINCREASE e Add the same rule for the other ALU frame The final result should look like this options Frame Le Options Frame SSS Condition MODEL lt gt Implication BOMVersion FRAME FRAME option 1920 QB visible MODEL lt gt Folding Bike 2 BOMVersion FRAME FRAMEBoption 1930 visible MODEL lt gt Folding Bike e Check the results by using the Browse function to view your model 7 The business rules are finished so exit the Studio and save your rules OTo Increase B V 51 TOINCREASE O Chapter 4 Integrate Your Model into Your Business Process It would be very nice if the model could be better integrated into daily business Making it possible to enter configurations starting from Axapta forms provides a better integration To do so you can add buttons to Axapta forms to start the e Con Frontend in which you can enter configurations You can use the dynamic buttons functionality to add buttons to Axapta forms You are advised to only use dynamic buttons on basic data forms like the InventTable and the CustTable So do not use this functionality on for example the SalesTable for
44. member with a read only attribute 10 4 List with most common Net compile errors The most common error descriptions that may appear during compilation of the e Con model to the Net run time assembly are listed in the table below Possible causes are also provided Compile Error Description Possible Cause Cannot implicitly convert type int to A type mismatch between two string properties Probably a comparison or assignment is done between properties from an unequal type This error can of course also happen for other data types Type of conditional expression can t be A type mismatch between a function and determined because there is no implicit property or value Mostly this error conversion between int and bool occurs when the MsgBox lt string gt function is used MsgBox String 1 instead from only MsgBox String will solve this error Cannot implicitly convert type A type mismatch between two eCon Base EConCollection to string properties a string value can not be assigned are compared with a property used to store options lt member gt options string or member both will generated this compiler error The best overloaded method match for The data type from one of the arguments eCon Data Functions GetOptions eCon In of the function isn t correct The number terfaces EConClass string bool string of the argument is shown in the next string params object
45. new item will be configured If the Online Synchronizing field is check marked the already configured object will be merged with the basis model the configuration tool model BIKENM xml before the user can reconfigure the object When the model is merged all the data from the object that was already configured is imported to the newest version of BIKENM xml and saved Now all changes made to the base model are available in the reconfigured object Infolog detail A setting to determine the level of detail to be shown in the Axpata infolog after processing this model into Axapta There are four possibilities e All All the info is shown in the infolog e Errors and warnings Only errors and warnings are shown in the infolog e Errors only Only errors are shown in the infolog e None Nothing is shown in the infolog Limit The maximum number of messages to be shown in the infolog 5 2 3 Overview on version Wo ahr Dens premi ee e Shy T 44 ur Fu aa E F PERE Lends verai l E RECTUS Leida yai ada 1 Version Code Code of the version You can enter a maximum of 20 characters alphanumeric Description Description of the version You can enter a maximum of 50 characters alphanumeric e Con Label To Increase B V 61 TOINCREASE O This label is used as name of this Generic Model in the XML document Choose a short description without spaces Status Status of the active version There are four dif
46. option must be set for to determine the outcome of the query Option This is the actual query You can use the standard Axapta filter signs like 7 12 34 etc to filter the record entered in the Filter Field A query can consist of more than one line e Con label This field is only used for queries which are not applied to an Axapta table In that case the description of the label selected here is used as the description of the option Default Value If you want to propose a default value at the Front End you can enter that default value here In the case of a query based on a table add a line where you type in the value and mark this value as default Button Run Query Clicking this button runs the query and will display the outcome of the query Useful function for testing a query Button Generate Datasource 53 OTo Increase B V 110 TOINCREASE O it is also possible to store the outcome of a query in an external XML Data Source It s even possible to generate an XML Data Source containing the configured objects of a Generic Model with user defined features That makes it possible to check if a certain configuration already exists Activating this button will create such an XML Data Source Example of a query used to create options with Additional Property member types for the Bike color CATEGORY Lines Citybike Lity Bike Field name Option e Con Label Tourbike Tour Bike E Sportbike 5 ports Bike
47. rules are stored in the XML document of the Generic Model Included models Shows included sub models for the selected model in a tree view Makes only sense when sub models are used in the selected model 5 2 1 7 Other buttons Import To import an project Save as To export an project 5 2 2 Generic Model The highest level of the structure is the Generic Model On the Generic Model form the data for the generic model and version is entered and an active version is selected With Models in the e Con menu the Generic Model form is started O To Increase B V 58 TOINCREASE sure Madal Ho HEE Bike deir guru fete arco ammar Lara EFEC Eka dared reodali ith gin LST OER Cinna EDOCR Peden ares rectal ERVad Hpnencbanune PRS EAS Firing 5 ub Motel ere Mode Vern a pr Shue Edge Copp Machel arre 5 2 2 1 Fields of the Overview Tab No Code of the Generic Model You can enter a maximum of 20 characters alphanumeric nterface Model To mark a model as an interface model Interface models are needed when sub models are used A sub model needs an interface to be able to interface with another model Description Description of the Generic Model You can enter a maximum of 50 characters alphanumeric Active Version The active version of the Generic Model A generic model can have different versions For example a bike comes in three colors If you want to add more colors but kee
48. settings Microsoft Axapta 1 The system will generate subfolders needed by e Con in this location continue BECEN OTo Increase B V 177 TOINCREASE O Click Yes This results in the following C Program Fileste Con 3 1 Datake Con_Axapta_Data File Edit View Favorites Tools Help O p P f Search Folders Bee Address C C Program Files e Con 3 1 Datale Con_Axapta Data Mame Tvpe Date Modified File and Folder Tasks C DataSources File Folder 27 10 2004 9 39 Demo File Folder 27 10 2004 9 39 Other Places Models File Folder 27 10 2004 9 39 y Gbjects File Folder 27 10 2004 9 39 I Reports File Falder 27 10 2004 9 39 Detalls Temp File Folder 27 10 2004 9 39 C Templates File Folder 27 10 2004 9 39 7 2 How to Set Up the e Con Application Server For more information on setting up the e Con Application Server reefr to Chapter 11 Setup in the e Con Application Server in the e Con 3 1 Installation Manual for MBS Axapta 7 3 How to Generate Meta Data For more inforamtion on generating the meta data refer to Chapter 10 Generation of Meta Data in the e Con Application Server in the e Con 3 1 Installation Manual for MBS Axapta 7 4 How to Import or Export Models With e Con you can import and export models 7 4 1 Model Import To import a model OTo Increase B V 178 TOINCREASE CE e On the Generic Models form click Import ES Generic Model No FRONTWHEEL
49. stored electronically as XML documents which serve as direct input for the web browser Using the latest Microsoft web technology it is possible to deliver a flexible customizable end user web interface Front End The presentation of e Con to the end user can be customized for example the sequence of questions asked and the dynamic visibility and non visibility of questions To Increase B V 13 TOINCREASE O Another feature is the simplicity of working off line This is mainly based on the fact that e Con is web enabled The models used for e Con are electronic documents XML with all the model information data and rules in them On a local off line computer these electronic documents can be used in a web browser and the configuration can be done off line Of course it is necessary to upload the configured data to the network once the computer is on line again In most cases it is necessary to have some knowledge of computer language in order to design and maintain the model rules A dedicated Studio has been designed for e Con One of the main purposes of this Studio is to add rules to the model The Studio is a user friendly tool with drag and drop functionality It has an adaptive shell around the possible rules and functions so an end user can maintain the model rules OTo Increase B V 14 TOINCREASE O Chapter 3 How to Build Your First Model The purpose of this chapter is to give you a brief overview of how
50. tab page from the settings e Add a new key email from by entering this key name in the field Key on top of the screen Clicking Add will add the key to the settings olor wv ft ri EN EnA Ash P L WF N ners faul Iyk E wakili fh valuc add slala anra d r zad en a ZTO de Fili dat Iu ale 1 DES M ETITRETONT QE nc Z GW AATE t vate c z amp e arlcca 1341 em T e Select the new key and enter the e Mial address to be used as the From address email trom jinfo watermark innovation com host C301 e Save the changed settings by clicking the save button leaf the settings e Finally build the model O To Increase B V 219 TOINCREASE O e Before the result can be checked the settings from the e mail host must be available as well Select the email host field in the e Con settings Fill this field with the name of the e mail SMTP relay host typically the e Con web server that also runs the SMTP server e Now the result can be checked 7 22 How to save my model without leaving the UI posting The general task to save and process a configuration in Axapta is the process task represented by a B in the Button set up However another possibility exists as well to save and process a configuration the so called Post action Posting a configuration means that a configuration is saved at the file system and the XML document is posted to Axapta The UI is still open a
51. the project e Con Studio OTo Increase B V 57 TOINCREASE O Start the e Con Studio for of this Project In the studio amongs other rules can be added to the models within the project Rules can be used to add intelligence to the data structure For example if the type of the bike is a mountain bike no mudguards can be chosen After rules are added to the e Con Studio the rules are stored in the XML document of the Generic Model 5 2 1 6 Model Version Button Models Select and opens the model view for the selected model Designer Opens the e Con model designer for the selected model In this form the data structure of the model can easily be maintained Generate XML Before the Generic Model can be used in the Front End and in the e Con Studio the XML document and Net assembly dll has to be created The XML document consists of the data structure and rules that are created in the e Con Studio The data structure is generated This can be done with the Generate XML function When this function is selected both the XML document and Net assembly dll are created for all models within the project e Con Studio Start the e Con Studio for of this Project In the studio amongs other rules can be added to the models within the project Rules can be used to add intelligence to the data structure For example if the type of the bike is a mountain bike no mudguards can be chosen After rules are added to the e Con Studio the
52. value is calculated You can also understand which rule s the member takes its value from gt LR Cee Cte Ce a How it works When the button Is clicked the cursor changed to a hand This hand can be moved to a field in the front end O Special Color C LJ eigh Kg O Cranks Steel w tj Frame Frame lady s Front Wheel To Increase B V 226 m TOINCREASE Qe A right mouse click at the field in the UI offers you the next screen aon NEM p per pe tae O O Active Rule Retrieve weight from Matrix CATEGORY g gt and MODEL zz implication WEIGHT GetStringMatrixCell CONNECTION BIKE Weight CATEGORY CATEGORY 3 MODEL MODEL BIKE D Context 2 Member Rule Engine Expression Result In this screen the next fields are available Engine Context The parent model running Member Context The sub model the member is located Member The member of the model the How amp Why function Is applied to Actually the member from the UI field selected Label The label from the selected member Value The value from the selected member Type To Increase B V 227 TOINCREASE O Type from the selected member Length Length from the selected member Index Index from the selected member Actually this only make sense when the member is part of an array so called repeatable entity
53. version has to be blocked for use Use this Status for models that are obsolete You can change the Status of a model by changing status on the version line To Increase B V 133 TOINCREASE CE Statue Table Mame m nde SCIEN eem T j ee Hew Under b iwi Closed In the Status column you can click on the arrow to open a drop down menu Then you simply select the status you want and it will appear in the Status column once you jump to another field In the e Con Model form the version can also be certified With the Model Setup button you can go to the e Con Model form that is only possible when the status is Under Development ULELILEUU k Status Table Hame ent InventT able e Con Modeler Langue L anfiaurated Models Ref Count Tee a If there are problems with the data structure some error messages will be shown OTo Increase B V 134 TOINCREASE H Infolog One ar more critical STOP errors have occurred please take suitable action Use the error messages below t guide vou or call your Navision Axapta administrator Message 12 29 35 3 There is no link defined for the tables in Member Relatic e Label ROUTE occurs more than once in entity Route e Label ROUTE occurs more than once in entity Route e Child Entity af Member Relation Hautelpr 1 ROUTE is 3 There is no link defined for the tables in Member Relatic 3 Entity 0 does n
54. 1 TOINCREASE CE E Main menu e Con 3 5 Company tst Generalledoer 00 Solution Center 2 My alerts Accounts receivable E J views ee ET amp gy e con E e Con Projects Accounts payable lnventory management z 2 Decision Matrices NEN ES Reports Waste E Periodic Product Builder Setup Master planning Shop Floor Control papMetadata group Dp 5 i Option Query Human Resources e Con Languages Questionnaire i Parameters ENS i amp amp Import settings Lies m 9 Modeler Cost accounting 9 Platform Cost purpose calculation Basic Administration e Don Generator Following possibilities are available e Adding table to existing Table Group Adding a new Metadata Group with members Adding table to existing Table Group e Select the table group to be extended OTo Increase B V 172 TOINCREAS
55. 19 Zoom With this style it is possible to make additional properties available in a pop up screen in the Front end Using this style will add a button to the option With a simple click on this button a pop up screen including all additional properties will appear The user can then make its choice form this pop up screen For more information see section How to add a pop up screen 6 11 20 ZoomColumn This style is aways used in combination with the former style Zoom The style ZoomColumn has to applied with value true to the properties that must me be visible in the pop up screen Only the properties from a reference with this still style will shown up in the pop up screen For more information see section How to add a pop up screen 6 11 21 Notused With this style the rules of the member are not executed when the input is changed in the Front End If the rules are activated by another input change the rules are executed afterall So with this style the execution of the rules can be delayed This for improve of performance 6 11 22 Option nfo In a pop up screen it s possible to show bullets for the default option E the current selection e the former selection The color of the bullet indicates one the tree possibilities With the style Optionl nfo with value true assigned to a member or reference having options this functionality will be OTo Increase B V 154 TOINCREASE O available H
56. 2 8 Key Values H Key values Generic Model 44 BIKE 000017 Generic Model 44 Field Mame Key Value F EE f Invent able Itemid BIKE O0001 2 Genenc Model Table Mame Generic Model E Con will automatically create this value It is a serial number Table Name The table name where the configured object is stored Field Name Field name of the key field that is used Key Value Key Value of the configured object 5 2 9 Entities button on Generic Model form only available when the version is under development Opens the Entity form To Increase B V 70 TOINCREASE O z Entity Generic Model BIKE 1 Generic Model BIKE Version 1 Selle Mame of table In amp Con Label Action on Duplicate Generate Key Fields BEES m l BUTTONS writeable Abort if found I Address l wiriteable Abort if found BOM writeable Abort if found BOM l writeable Abort if found BOM writeable Abort if found BUM Wiriteable Abort if found BOM writeable Abort if found BOM writeable Abort if found BOM 15 BOM writeable Abort if found BOM writeable Abort if found BOM writeable Abort if found Once configuration is complete records are inserted into the Axapta database The definition of a record is determined by the Entity definitions In the Back End the Generic Model is the name fo
57. 3 TOINCREASE O ld Tab Main Label Tab Main Condition Implication CATEGORY visible TAB Main This will result in a Front end that looks like this Ld HE c Com Frostend F mE rou Bee legged on as user soon Mai Apre Ss Ore Tet aMad FiHds Description Limit fee ie E SS Can Category City Big v Model Popis sw Type Shaded biega L Mang bevel Weight T5 lkp 5pacial Color T Frame Frome lady s birds wu RR Frantwheel Iteni E Rosie Farm istandard o Humibar of Spokes aj Backeuhe enl itani Chain Itera III WCLECLXOLLE Tips amp Tricks With the use of the attribute lt memb gt option lt expr gt visible it is possible to hide or show a tab in the front end Simply fill in TAB as lt memb gt and the option that represents the Tab as lt expr gt 7 15 How to add Radio Buttons It s possible to display options as radio buttons instead as a drop down box in the e Con front end In this section is described how this functionality can be added e First select the member in the data structure used to be shown the radio button options To Increase B V 204 TOINCREASE O Now a style has to be added This can be done in a business rule or in the data structure The latter is described hereunder Select styles in the member Eg Entity Member Styles EES mni Style HTML description Style Lin Value Description RADIO Radio O true menu Fill in the style RA
58. ARDBACK Class Stop Process 2 gt a co as go oi mco Eum 6 11 5 Select the Entity member labeled FRONTWHEEL so that the whole row is highlighted E Entity Member Member Type Relation FRONTWHEEL Generic Model BIKE Version Cod my Overview Field_ Method Relation 0 ARENG Field Property Table Relation LINETYPE EN d Field Property CONSUMPTIONTYPE Field Property QUANTITY ju Field Property UNIT Field Property BOMID Field Property NVENTDIMID if Field Property t FRONTWHEEL c DEE nnn TEAN Rosoesoorm r xc udis is ol o oogoogo Pjarmsaussn r e Goto the Entity Member Styles form by clicking on the Styles button O To Increase B V 147 TOINCREASE O The following screen will open EB Entity Member Style Style autoexpand 0 Generic Model BIKE Versi EBE Style HTML description Value Description ll autoexpand autoepand e Add the desired style by using the lookup button in the Style column The value for an autoexpand style is true or false In this case we enter false The autoexpand style will automatically expand a relation which has been set by a rule causing it to appear in expanded form in the Front End In the case at hand this results in an expansion of the Front Wheel options in the Front End OTo Increase B V 148 TOINCREASE CE EB e Con Frontend Text Accessories l Fields Description Unit
59. After determining where you want to have the image right left bottom or top on the Front end with imgposition style you can go further and determine where exactly you want the image to be positioned in relation to the top margin of the image area e memb QsStyle mgheight With this style you can determine the height of the image If you do not specify the width this value will scale your image to the correct dimensions O To Increase B V 169 TOINCREASE O e lt memb gt Style lmgwidth With this style you can determine the width of the image If you do not specify the height this value will scale your image to the correct dimensions The styles described above are only used for images Tips amp Tricks It s advisable to use logical names for the image files especially when the images are to be displayed for particular members In the Bike demo model the image file names are based on the Category Model and Type of the bike 6 16 How to Set Up Recovery If you enable online recovery e Con will show the errors if something goes wrong when you enter configurations To enable recovery e nthe e Con menu click Models e Onthe Generic Model form on the General tab set the value of the Online Recovery field to Yes z Generic Model Mo BIKE Bike demo model En Overview General Include to Object Online Recovery Online Synchronizing 7 As a result errors are displayed when you save a configurati
60. BikeHelp xml Microsoft Internet Ex Seles File Edit View Favorites Tools Help En gt E A A Search S P Favorites QI Media 4 m ten Address C Program Filesle Con 3 0 DatalDef aultiHelplBikeHelp2 xml Eco us lt xml versian 1 0 7 gt helpz This is the help file for the Bike demo model topic id2 Category help helptype tooltip gt Please select a Category of the bike help help helptype z button Please select a Category of the bike lt help gt lt topic gt help amp Done d My Computer e Adda topic id tag for each field property in the UI where help is needed In above example help is needed for the field Category Important notice In the help To Increase B V 215 TOINCREASE O file the field must be start with a Capitol letter e g Category Production Frame Frame ni e Add at least one help helptypez tag The content of the tag determines if the text following by the tag is for displaying on a tooltip or for displaying under a button However if the help must be shown as tooltip or button is set up in the model e Add the help text it self in between the help helptypez and the lt help gt tags 7 20 How to synchronise my configurations against the latest model During the life cycle of a model many changes upgrades and extensions of a model take place Sometimes it s required to update existing configurations with these latest m
61. DIO with the value description true Leave the screens and go to the Generic Model Certify and generate the data structure and check the result Leave the screens and go to the Generic Model Test the result by configuring the model As you the options will be displays as radio buttons In our example the type of the bike is shown as radio buttons EB e Con Frontend Main Accessories Text Fields Description Unit zi Bike demo model 160 Category v Model E Type Ladies bicycle Mans bicycle Special Color a Frame i v The buttons itself are shown under each other It is also possible to changes this appearance By adding the style Cols too it s possible to set up how to display the radio buttons The value of the style cols a numeric value determines the number of horizontal aligned radio buttons OQ To Increase B V 205 TOINCREASE O As an example below the outcome of the style Radio with value true and the style Cols with value 2 added to the member Type in the demo bike model EB Entity Member Style Style Radio 0 Generic Model BIKE Version E BF HTML description Value Description SHF adio colg B e Con Frontend Main Accessories Text Fields Description Unit Bike demo model 160 Category Model v Type Ladies bicycle Mans bicycle Special Color C b Frame wv
62. Deci ion Matrix Decium Matrix BIKE 1 Dectziar Matrix BIKE D pron Deon iy Eke Mouna Bka opo Dor Tous Bike CATEGORY F MODEL Add a new style to the property representing the Models In this case the property model The style to be added is selectdefault with value true H8 Entity Member Style Style selectdefault 0 Generic Model BIKE Version 1 Ta BE HTML description Value Description selectdefault 7 10 4 Adding Additional Data to a Selected Check Box in the Matrix In this section we describe how additional data can be added to a checked field in the decision matrix This functionality offers you the possibility to add data to options available in the decision matrix As an example It s possible to add the prices for all the monitors in combination with the computer model for That means that the price for monitor vary depending on the computer model the monitor belongs to To Increase B V 192 TOINCREASE e Select the Decision Matrix as set up in the former step And select the Matrix form as shown below ES Decision Matrix Decision Matrix BIKE 1 Decision Matrix BIKE PEE e Con Options e amp Lon Label Option Option Description CATEGORY Citybike City Bike MODEL Mountainbike Mountain Bike EEE EEE ET Sportbike Sports B ike Taurbike Tour Bike Related Options for CATEGORY Sportbike e on Label Link Link Values CATEGORY m t MODEL Link
63. Default Code Mn Series Step Size for Auto Numbering bernld lteriN ame ltemTupe ltemGroupld OinGroupld ModelGroupld Model B MVersian ea B MVersian Itemid BOMId Complete the model in our example as follows First complete the BOMVersion entity and entity members OTo Increase B V 24 TOINCREASE O 6 Check the key fields of the BOMVersion entity on the following settings Itemid Yes mme e a Deom LN NEN The result so far is i Modelling tree e MYBIKE Itemld Iter ame Iter Type Itemaraupld DimGroupld ModelGroupld Model BOMVersion E BOM Version Itemid BOMId Name Approved ApprovedBy Active e ls As the Frame and Wheel relations are almost the same you can for example first build the Frame relation and then copy it After copying you only need to rename the relation copy to Wheel and its Frame relation the relation to the Item table to Wheel So first only add the Frame relation its entity and its entity members To do so 9 Add the mandatory fields to the Frame relation entity 10 Check the Frame relation entity s key fields and mandatory fields on the following settings BOMId Yes O To Increase B V 25 TOINCREASE O mu Y Dems 0 Ya 11 Add the following field properties to the Frame relation entity BOMType 12 Add the following
64. Default Option Option Description 3 t i ISSUES C bahia Bahia a errr EBEN rede a MG 12 extreme Extreme LI golfo Medea Playa Hr 7 Fopular do O oee Torente E tranza ultimate Ultimate e Select a link for which a check box is selected e Open the Link Values tab e On the link values tab enter a label and a value This data is unique linked to the checked field in the matrix The label of the value is important because that label is used in the business rules to get this value in eCon Related Options for CATEGORY e on Label Link Link alues CATEGORY z e on Label Value Link Values SPY PEPE PTET k MODEL Tips amp Tricks To assure that always the same labels are used for the additional data in a decision matrix use the Link Values Defaults The Defaults function can be found under the Link Values button on the Link Values tab of the e Con Decision Matrix form When additional data is entered those defaults always appear There is an overview form available where additional data can be very easily entered To open this form on the Link values tab click Link Values Overview To Increase B V 193 TOINCREASE O H8 Decision Matrix MYBlke 1 CATEGORY MODEL E 5o Tourbike Sportbike extreme 7 10 5 Add the Relevan
65. E menisk Bareheet necari Bou Ea raag Du gru IneeeniLIinemng Irreertcry clocing reci rd alea Coders Inani DostLig akidai bet InveniLast isl rans Lei leved adimen rarer ennt rop bunte ques Hei Coran out Count eun al IneeeniD um Irreeriory dameranng Ieri m amahina tam raroa I reir Dam op Iririnibon career groups Imeni D monu Inventory dameriann setup nri Tam its ren Mina giraron raa d aere aar rarae d ueri a haa owiehe e Select the tables area of the group and press Ctrl N to insert a new record and select the table of your interest PRODUCT T ables T able D escription Invent atch Batches lnventbuyeraroup lnventllosing InventColar Address AddressFormatH eading AddressFormatLines i AddressMap A lacateKevM ap AllacateTransMap App ctian App ctonFlow App ctionFlowltem App ctonFlowT ransition B uyer groups li Inventory closing b journal ventory dimensions Em dimensions venton dimension groups ventory dimension setup Jew dimensions em bar code em groups arehouse Items Invent aurnalT able M T a Inwenkl aurnalT rans Inventory journal lines gU E Another possibility is the uses of the A query mechanism to add a range of table at once to the meta data group OTo Increase B V 173 TOINCREASE I NITE elit rump Ose used eT A Tone gj Teb metadata Flange Sorting e Generate the Meta Dat
66. E Decision Matrices ie Reports Production mu i m Periodic Product Builder 3 Setup E E Metadata group Master planning Sha l Floor Control cent ee E Option Query Human Resources E e Con Languages Questionnaire pegeatameters T Import settings i Q Modeler Cost accounting i ML Labels Cost purpose calculation Model Table Link 2 E Context Transition Z Styles Project e on Generator Solution Center Before we can use e Con the setup data has to be entered The location of files and user preferences are stored in the Setup form Administration rg Platform OTo Increase B V 113 TOINCREASE O E e Con Setup eCon Server Madeler Configure e Lon Server localhost Edit environment Environment default Data Folders Tips amp Tricks Default values can be entered in the e Con Setup form click on the Initialize button in the e Con Setup form For a more detailed explanation of the e Con Setup see the Installation Manual on the product CD ROM 5 2 36 1 Fields of the eCon Server Tab e Con Server Enter the name of the server on which e Con is running Environment The environment used Per e Con environment a set with settings are available 5 2 36 2 Fields of the Modeler Tab BS e Con Setup eCon Server Modeler Configure Default Madel Masimum Number
67. E Display Method SalesPcsPrice To let those properties appear in the pop up screen a style has to be added to all of them Adding a style can be done in a business rule or in the data structure The latter is described hereunder Select the member for which the style has to apply Select styles in the member menu Fill in the style Zoomcolumn with the value true O To Increase B V 199 TOINCREASE CE EB Entity Member Style Style zoomcolumn 0 Generic Model BIKE Versi amp amp HTML description Value Description eOOmMco Lr e Last step is to add the style zoom with value true This can be done in a business rule or in the data structure The latter is described hereunder Select the member for which the style has to apply in our case the relation on the BOM 1 FRAME entity to the InventTable 2 entity EB Entity Member Member Type Relation FRAME Generic Model MYBIKE Version Code 1 EEF Overview Field Method Relation Field Property TablsErelatibn LIMEN 20 Field Property RECORDID A FRAME LINETYPE EDNSLIMPTIDIN BUANTITY Field Property Field Property DIMENSIONND e Select styles in the member menu e Fill in the style zoom with the value true OQ To Increase B V 200 TOINCREASE O E Entity Member Style Style zoom 0 Generic Model MYBIKE Version Selig Style HTML description Value Description selecttirst
68. F Eoo Con Model Model Interface rcd Configured Models Copy Model Version H 6 2 5 Entity Members The Entity members are the same as the fields of a table and make up what we call the data structure Entity members are used to define the characteristics of the Entity We distinguish among the following Member Types Field Property a link to a field of a Axapta table Additional Property a field that is not present in a Axapta database but is nonetheless needed in the Studio or the Front End Relation used to designate a relationship to another Entity in the model or other model With relations the data structure is made Item BOMVersion BOM lines Display Method a link to a display method of a Axapta table Tips amp Tricks The Relation read only is often used with a Dynamic Query This provides a functionality for which you would normally have to use a connector to the database To go to the Entity form and from the Entities form click on the Entity Members button O To Increase B V 130 TOINCREASE CIS ai Generate Kev Fields EB Entity Member Member Type Field Property MYBIKE Generic Model MYBIKE Version EBE od Relation Segu Member Type PA AT Daas d Field Property ON i Field Property fa l Additional Property ITEMTYPE Field Property TEMGROUPID 50 Field Property INVENTDIMID Field Praperty INVENTMODGROUP 70 Field Property BOMVERSION 80 Re
69. Generic Model Card Certify and generate the data structure and check the result Leave the screens and go to the Generic Model Card To Increase B V 210 TOINCREASE O Test the result by configuring the model As you will notice an assist button is added to the member By clicking this assist button the calendar calculator or text editor will appear Example the rich text editor By clicking the post button the editor is closed and the text is added to the e Con member 43 Edit Text Web Page Dialog dzlPost X Em A E em 2 gM 4 Bij Use SSS L ti Style Hamal E Font Size melange Ts a chy 2 This is the RICH Text Editor Isn t it great Example the calendar By clicking the OK button the calendar is closed and the selected date is taken over to the e Con member OTo Increase B V 211 TOINCREASE O A Web Page Dialog May2003 May z003 Sun Mon Tue Wed Thu Fri Sat E SENS NN ERNEEEDEBEEQS S ees a E SS TES ELE EERE Cancel Example the calculator By clicking the OK button the calculator is closed and the calculated value is taken over to the e Con member A Web Page Dialog OK Cancel 7 18 How to change the style of the questions and fields in the Front End Normally the questions and answers of e Con appear in a certain standard font and style in the Front End Only the mand
70. IKE E i TEE pna Overview Link Details Operations Statistics Recor Records processed E Records updated Processing time s 0 47 04 Records replaced Blocks per second D 036 Records deleted Records buffered jj Records kept Records failed ye L Records skipped n Information about number of records inserted updated delete etc are displayed here Performance indicators like processing time is here available as well 5 2 7 Configured Model Buttons Process An erroneous configuration can be reprocessed Only enabled when the error flag is set for the particular configuration Configure This activates the Configure option for the selected model Update current configuration C3 Copy to new configuration Key values Shows the Key Value s of the configured object Included Object To Increase B V 69 TOINCREASE O Displays the included objects of this configured object Inlcuded objects does only exist when sub models are used in the configuration model and when the flag include to objects is set for the particular sub model If so a separate configured object xml file is created for the sub model part of the configuration Report To print an e Con report both html or MS Word from the selected configurations Shows a list of reports available for the model After selecting the report the document is printed 5
71. Increase B V 5 TOINCREASE O 6 15 How to Add Images to Your Model ssseeeenm 168 6 16 How to Set Up Recovery cccccccccceceee cent sees esse et ee tesa ee nemen nnn nnns 170 6 17 How to extend the Table Metadata Groups sessseeenm mH 171 Chapter 7 e Con Axapta Connector Functions and Set up sssesesennn 176 7 1 How to Set Up e Con for Axapta ccccececscseseeeeeeueueeeeeeeeueueerereeseataeaeeeanegs 176 7 2 How to Set Up the e Con Application Server seseeenm 178 7 3 How to Generate Meta Dal sseceoscecdiiscesene suem utere Pod QFrie du cupa etal o Cea va ded cd 178 7 4 How to Import or EXport MOGBIS uieii vite ib eb FE t dace 178 FE UNESCO TIT TU E E E 178 Lo Model EXDOlDossxsmsridisiertivideabbtvemtiapemdpdada tried peice Rexcepn AME 179 7 5 OW TO CODY Eas cDL 180 7 6 How to View Your Configurations ceseeeen mmm 181 7 1 How to Start Up feiiiidelei MERE T TT 183 7 8 HOW tO Generate XAML 184 7 9 How to Start Up the e Con Stu G0 usc euenit ated or re rc re creer 185 7 10 How to Set Up Decision Matrices sssseseenn mm 186 MEUM Uus 186 7 10 2 Setting up the Matrix ccececcesecececeeeeeeeeeeeueueeeeeeeeeeeaeeeseeereneneraearanees 187 7 10 3 Checking the default option in the matrix sesennm 191 7 10 4 A Adding Additional Data to a Selected Che
72. KE3 1 gi MYBIKE3 Label J Li i z pia A4 Copy CErI C e As result a rule is added in the folder and shown in the edit pane of the studio To Increase B V 34 TOINCREASE O b ficial Copiers T E Lat Pal id Harl Condor rod bras cree EL F siri kapare CEG F A ead ne Yaa E Ax We can enter the rule in this pane Besides the rule id and label there is a Condition section and an Implication section The Condition section is for when the rule is to occur and the Implication section is for what is to occur The first rule we want to create will be explained step by step In this rule we will enter the name of the item and the BOM version of the chosen model o Enter a descriptive id and label like Enter descriptions o Move the cursor to the Condition section o Select the Expression Builder OQ To Increase B V 35 TOINCREASE GINE toate Ll gaia Riad Aa aA S Bore n menm p iet i IFTE Li la d i dram Gime Le deL Cena ka k Hgiel olla bred bas rrr tard i airi mra tr I mban dam uhm le m lik om TE agi ee ee HI d 7 1 cx n98nU37g o Select the Comparison category followed by the Left Right function and click copy OQ To Increase B V 36 TOINCREASE Expression Builder n x Select a category Comparison Select an expression Left gt Right Left gt Aight
73. Left is not equal ta Right Copy hM Expression Builder Properties o The following will appear in the Condition section To Increase B V 37 Id L abet Condition TOINCREASE Enter descriptions Enter descriptions lt 3DI gt lt gt expr o Browse to the Object Explorer expand the model structure and select the model Object Explorer 478 Objects a MYBIKE 1 E 13 My Bike rey Itemld Item number 9 ltemMame Iter Mame therm Type Iter type F Itemaraupld Item group DiriGroupld Dimension gi Madelaroupld Inventory i D BO Yersion BUM Versio Jg Env Environment Rules fg Columns Libraries D Interfaces property o Use the mouse to drag this member to the left lt expr gt expression code in the Condition section and drop it there You will see that this member will replace the expression Id Label Condition Enter descriptions Enter descriptions 1 MODEL lt gt lt expr gt OTo Increase B V 38 TOINCREASE O o Replace the right lt expr gt expression code with 2 double quotation marks Now the condition tells us This rule should be executed when a bike model is selected when MODEL is not equal to that is when MODEL is not empty Labet Enter descriptions SS Condition 1 MODEL lt gt o Place the cursor in the Implication sectio
74. Matrices Reports E Periodic E Setup i Metadata group e Con Languages 4 Parameters Import settings Modeler Platform e Add a new query by selecting New Item from the context menu and give it an ID and description In our example add the query MODEL z Option Query Hide Setup ON Record info EEP I T Move a Toke SS Conn n0 E Properties Datasource ae Delete rm ra aT To Increase B V 23 i TOINCREASE Go to the Option Query Lines area and add the options In our example add options like this MODEL Lines Field name Option e Lon Label L T Citybike Citybike m N A SA r m SES pd Spartsbike 5 portsbike p Pu hauntainbike M nuntainbike Exit this form and link the option query to the property you want To do so double click the property and enter the option query in the Query ID field on the Fields tab In our example link the option query to the additional property MODEL go back to the entity member MODEL to select the query EB Entity Member Member Type Additional Property MODEL Generic Model MYBIKE Vers TBE Overview Field Method Relation Member Type Additional Property hd Entity Field Name Table Relation Description Property Type T est ye Length 3 Child T able Query ID MODEL
75. Model BIKEAxA ERRORTEST Version n oJ Cancel 3 Now that we have made a copy of our model and its rules we can use this copy to search for the rule causing the error message 4 Delete the first rule group in your model To do this select the group in our example the Configuration group and select Delete from the context menu E e Con Studio File Edit View Tools Help Bia 6s 5 AB BIKEAXA_ERRORTEST 1 cag BIKEAXA ERRORTEST 1 e Objects TI lement mae BIKEAMA_ERRORTI S 03 Rules Lg Frontend El P p oe E ra Mew Rule E E Mew Group d cut Ctrl aA Copy Ctri c X Delete Del UEEUEUOOOOQ To Increase B V 231 5 TOINCREASE O Check the results by using the Browse function to view your model You will find the Browse button in the tool bar of the e Con Sudio ent Labe ee ac Now there are two possible scenarios i 10 11 12 13 14 a The error message still occurs Now you can be certain that the rule causing the error is not located in the deleted group here the Configuration group Continue with step 6 b There are no errors found Now you can be certain that the rule causing the error is indeed located in the deleted group here the Configuration group Proceed to step 7 Delete the next group of rules Again check the results by using the Browse function to view your model Continue wit
76. O vesssctebsitunennearbtSrsv eta p A E E POI dU 154 6 11 23 nN oT gt 10 6 8 emen meme mener seran nean nans 155 6111 24 RECO m 155 M1125 RESOL 155 AB LUNET E E orrea EE R A EE AEE AE 155 DOLI Z 7 PUNG gerrea E E A EK Dui 155 NN DAL a E ee eer 156 0 11 29 Controlcla5s Labe laS Seseme a aiaa 156 CELU Fa SONO Em 156 CALL 010 cn 156 D L1 32 SOlect SINS eset re A CbStEXT Ad EET UP SERRA IRUIU A Hk D EVER KT VR URP ME DA MUN 157 CLL COVA WICC eects each snordieran vite ahetabend tdm Id AA ud ara Rd ca ont etre deae 157 CLSA DUBIO DUPEOPusesdstiatimerdbtbstx shine viator kde Id A e uia pad tbi rX ELT Vera dM 157 SINON Ee oed MT 157 CALL V UED eeen ot snare tutes ven agence Er cd dvpd ETIN UTI eR R URP TIMOR USES 158 6 12 How to Include Another Data Structure eseseennn 158 6 12 1 Setup of an interface model sssseeennmm menn 158 6 12 2 Setup the link to the sub model in the data structure of the main model 161 6 13 How to Make Your Model Multilanguage Compatible esses 163 6 14 How to Work with Arrays esssesenn Hmmm 164 6 14 1 How to Make Entities Repeatable sssssenn m 164 6 142 HOW tO Set UD ATTIOVSsatsqurti osx PUR aa UR MP UD CUPIS 165 6 14 3 HOW tO Control Arrays sosxserciexpotcu ius E FEXPAFTRPDECEFERER E balbda s ae PRebaeDEKEC PRA 166 0 L44 Special array TUNCUONS ssmscereseivazuiieVenzc risu FPE RETE enameled 167 OTo
77. SIE qU HA n ERpUE 146 6 11 3 A Auto expand autoexpand sssssssssessen memes 147 6 11 4 Goto the BOM Entity BOM 1 labeled FRONTWHEEL and go to its Entity Members 147 6 11 5 Select the Entity member labeled FRONTWHEEL so that the whole row is MMIC HEC TE T UU UU Erinn E A E 147 OTo Increase B V 4 TOINCREASE O 6 11 6 Multi line multiline evecta d ERR a HEAR Vau ir acera a e dota 150 6 11 7 Columns cols voce cece mmm nennen 152 6 11 8 Rows rows isssssssssseeennmemeemenenn nennen nennen nennen nnn nn nnns 152 6 11 9 Image Source imgsrc sesessen dite tiges RET Loses vb nU esI M d Vd M drEEGa 152 6 11 10 Image Visible imgvisible seen 152 6 11 11 mage Position imgposition sssseseeennm Hmmm 153 0 1L17 Image Leni IMIE sceseceedexsavenascvunteptaceseuedew or ied e vbt av wc SV E RP Ried 153 llls Image TOD I8 LOB iocsstscesedi uec denteiuieRede ese EDt aUi roma Ud DP EES dp NODE 153 6 11 14 Image Height imgheight sssseeenn mmm 153 6 11 15 Image Width imgwidth scsccdenxidexvuead d vr Race rcc dd acd b ac cbe 153 OMNCM 0m T Temm 153 DILI We AW csbin d ROETFEEROKIHS E PEDR RIIHEBBUR RORIS AU TIR tatiana 153 OL UR c 154 STEM NES oo o c 154 D LTIZ0 ZOO CONTAIN arene a rar Rd cd deed Tap C Mad ERROR Drei NUN TRU 154 DILZIL NOU O iisimmeeppIdenmn eodein PU TO e vba pid Eb RV MEO PIECE MEI 154 DELZ ODDIORLPIT
78. This field is needed to insert the records in Axapta in the right order There are two options Reference Reference between two Entities Example item and BOM version both records can exist without each other Master Detail to N relation between Entities 1 to N such as BOM version and BOM line first the BOM version exists and then the BOM line is linked to the BOM version The primary key of the detail is an extension of the key of the master Description Description of the member In the case of a field property the description entered is the description of the field chosen as the Field No If the member type is Additional Property or Relation the description can be entered for information purposes It will not be used in the XML document Child Table amp Child Line No If the member type is Relation These two fields combined refer to an Entity If the Child Model differs from the current model the Root Entity will be selected If the member type is Field or Additional Property When the Child Gen Model is left blank and the child table is filled a direct relation to a table is created Repeat Checkbox for whether this member should be repeated in the Front End It can only be marked if the member type is Relation and the relation type is Master Detail If the new reference is mandatory and there is only one visible option available then the reference will be expanded automatically onc
79. To Increase B V 119 TOINCREASE In this part translations can be entered for the Labels in the languages needed Descriptions of the Labels are displayed in the Front End in whichever language is selected when starting the configuration For more information see the section on Multilanguage Capabilities section 6 12 e Con supports multiple languages For practical purposes this means that the end user who answers the questions in the Front End can see the questions options and descriptions in the languages defined in the Generic Model Description Translated description of the label 5 2 39 Model Table Link Model table link can be found in the Set up Modeler menu EM Main menu e Con 3 5 Company tst oaeiae T T General ledger Bank Solution Genter CRM m OEjMyaets 0000000000000 My alerts Accounts receivable amp rg Views B Ly e Con E e Can Projects Inventory management Models Accounts payable amp Decision Matrices i Master planning 2 Reports Pindutin 9 Periodic 73 Setup Z Metadata group 1 E Ed Product Builder Shop Floor Control l Option Query Human Resources e Con Languages Questionnaire E Parameters 7 amp Import settings Modeler Cost accounting SE ML Labels Project Cost purpose calculation 3 OERE Transito Basic Styles e Con Generator Administration amp rj Platform pu ll
80. Value The key field names and key values if filled are shown About Key Values e A Key Value can be added to each Entity and is a pre existing record of the table that is represented by the Entity This Key Value will act as a kind of template All the fields that are not entered by e Con fields that are not represented by a field property in the Entity will be entered with the value of the relevant fields from the Key Value e The Key Value that is added to the Root Entity has another special function too When this Key Value is entered in the Sales Order line the appropriate e Con Model will be called up automatically when the Configure button is activated See also chapter 4 4 Copy entity When using this function the selected Entity will be copied with all the members and key values Only the e Con Label will not be filled because it has to be unique 5 2 11 Entity Member form Once the Generic Model and the Entities are filled in the details of each Entity have to be entered When used in reference to a data model the members of an Entity are the same as fields in a table To Increase B V 73 TOINCREASE O BS Entity Member Type Additional Property TAB Generic Model BIKE Version 1 Name of tab PEE eme ret Hed Resin Se e LCon Label om TTPPPPFPPPPPPPPPET SPREE reer ree reer reer rrr rrr PITPEPEEIEM rere _ dditional Propert CATEGORY
81. When the member is not part of an array the value is always T Default The default value from the selected member When there is no default value set for the member this field is empty Previous The previous value from the selected member Filter The Filter applied to the member Attributes The attributes applied to the member Style The styles applied to the selected member Table id The table id from the related table from Axapta Only applicable for field properties Field Id The eventually field id from the related field from Axapta Only applicable for field properties Rules Where used from the member The where used are the rule numbers where the member is used in Active Rule The rule s description involved in the calculation from this field Condition The condition from the active rule To Increase B V 228 TOINCREASE O Implication The implication from the active rule Rule Context The sub model in which the rule is executed Select member The member analyzed It s possible to key in a member from the model to be analyzed as well Context Three possibilities to select from e Member e Rule e Engine Expression A rule expression can be entered here Result The result from the above typed expression This is calculated after clicking the activate button Button Go To analyze the member entered in the Select Member field Button Evaluate To cal
82. a Generic Model is built in e Con It outlines the main steps of creating a model However you will have to study this manual more closely to get more detailed information about all the aspects and possibilities of the Studio In order to gain more experience with modeling we recommend consulting our training manual This manual presents a lot of exercises from simple models to the more complex An expanded version of the training manual is also available It provides a complete step by step explanation of all the exercises The first section of this chapter provides an overview of modeling with e Con The various aspects of modeling are discussed The second section explains how to build the data structure step by step The result will be a finished data structure for a simple bike The third section will describe how to create business rules in the e Con Studio This will result in the addition of some simple rules to the bike Finally how to integrate this model into the business process is described 3 1 Overview of e Con Modeling An e Con configuration model consists of two parts the data structure and the business rules See the diagram below The gray arrow in this figure represents interaction with the end user The end user Data uct 1 Configured Object Rule Configurator Model selects the options and answers the questions of the configuration model which results in a configured object The data structure is built
83. a by clicking the save and generate button sE This will create the XML file to be used for the rule wizard Adding new Table Group with members e Insert a new g NEW by selecting New Item from the context menu k idnventBatcl InventB Uye Hide nventClasi Setup InventColor Record info InventCostl InventDim e Select the Tables area of the new group There are two ways of adding tables o Adding table one by one press Ctrl N to insert a new record and select the table of your interest OTo Increase B V 174 TOINCREASE mia EE ie deia proup Vad previa Te 98 Wend moaca ran ered edga Windedacironays Ven aching ip mas Veri acl ing ipPuichl ink Vera scking5 ipl rene Verde ni reb in unde o Adding tables by using a query Click x to activate the query mechanism to add a range of table at once to the metadata group T MITIS Dairi rgo Cry ured aur thang eh Table gj Fab mnda Ranae saing Table e Generate the Meta Data by clicking the save and generate button sE This will create the XML file to be used for the rule wizard OTo Increase B V 175 TOINCREASE O Chapter 7 e Con Axapta Connector Functions and Set up The purpose of this chapter is to provide you with information on general options and settings in e Con For a full description of all fields found on the e Con Setup form consult Chapter 5 or installation
84. able after configuration the code is retrieved from this No Series When no number series is entered the code of the record that is inserted into Axapta such as Item has to be generated by the rules When both the number is generated from the rules and a number series is entered the two fields are To Increase B V 76 TOINCREASE O combined For example if H0001 is the number created by the number series and MENSBIKE is created by the rules the item number will be MENSBIKEHOO001 Step Size for Auto numbering When Auto numbering as part of the primary key is needed the step size can be filled in here The step size will be added when the next record is added to the database 5 2 14 Fields on Method tab H8 Entity Member Type Field Property Overview Field Method Relation Type Field Proper Method Mame Description Item number Property Type T Length Member Type There are four options Field Property link to a table field Additional Property field that does not exist in the Entity table but is used in the Front End and or in the e Con Studio Relation relation to another Entity Method name link to a table display method field Method name This is only entered if the member type is Display Method Here the display method of the table is sel
85. ained there 1 2 Installation See the Installation Manual on the Product CD To Increase B V 8 TOINCREASE O Chapter 2 The e Con Product This chapter describes the e Con product and its architecture First a general overview is provided followed by a more detailed description of the architecture 2 1 General Overview e Con inserts records at the Back End in this case the Axapta SQL database In Axapta the Generic Model is built the records and fields that are to be part of the data structure and how that structure is to be configured Modeler intelligence is added to the model in the form of rules such as IF THEN or ELSE Actual configuration takes place at the Front End The choices made by the end user influence the value of the configured records and fields The concept of e Con is based on the following e Component based e A generic solution both functionally and technologically e State of the art technology e g use of XML Internet technology This means that e Con is not a solution built exclusively for Axapta e Con will also work with other ERP packages databases and even stand alone systems Integration of Internet technology as the basis of e Con s functionality demonstrates that e Con is a true state of the art business solution The objective of e Con is to make all required configuration functionality available in any situation Within the scope of technological possibilities total flexibility i
86. alue for the frame Some dependencies between the chosen model and the visibility of the wheel Some dependencies between the chosen model and the options possible for the frame O To Increase B V 32 TOINCREASE CE 1 The business rules are added in the e Con Studio To do this start the e Con Studio with the button Lontigure Configured Models Generate model interface 2 Add a new rule e Select the rules view from the model by selecting the Rules Tab hah an 1 ee eeeeee e Mi adm hi lh om DET gum gg c ek ee zi sy ut rti a il dn ow DI OQ To Increase B V 33 TOINCREASE O e Activate the Object Explorer and Expression Builder The Object Explorer is needed to drag and drop model properties in to a rule The Expression Builder is a great tool that s helping us in the creation of rules o Select the Object Explorer from the toolbar e Con Studio File Edit View Tools Help MYBIKE 1 Sey MYBIKE Element Label Id o Select the Expression builder from the toolbar B e Con Studio File Edit view Tools Help E52 ied Ga 08 4h MYBIKE 1 t ae Pression pulider 34 MYBIKE TEEN Label id e Select the Rules Map from the tree right mouse click and select New Rule from the menu B e Con Studio File Edit View Tools Help E Ll ica fa S lad E 5a d x ah E MYBI
87. amp ldiscosxi5tul amp umexiun sje Object Explorer A X MYBIKE 1 MYBIKE 1 Browse eS Objects 3A MYBIKE ld Enter des cg MNBIKE 1 Tg Rules PEE ES Label Enter rez ra BE danin o Now it s possible for you to test your model but it isn t possible to save the configuration in Axapta This Browse functionality is for testing purposes only Notice that the model is compiled before the browse is performed The results from the compile or build is logged in the output window at the bottom of the studio E ILD XCEL HELE L Te d UTI Pegi T ext 70no ee yee Tee hrde hee he n gererard laurer dal zri agrum c mi a ubl on dE o Halrznes rr onmia ci bu crc cma c Il n 2 ND y bey zc lec T ee Den Ase 2 1 7 lu b c ete redone ded o Select a model of bike You will see that the description is entered OTo Increase B V 42 Member Item Name Model Frame Wheel OTo Increase B V TOINCREASE O J J Ja ts ta ft J Now we will expand the rule To do this switch back to the model and select the rule Select the Implication section with the mouse and add a semicolon after the rule that already exists Press lt Enter gt and copy the LeftHandSide Expression function from the Expression Builder Siply entering is possible as well Replace the left lt expr gt expression code with the BOMVERSION NAME member Click the BOMVersion me
88. ased Business Intelligence Tool It navigates the user through a number of questions while automatically carrying out other processes unseen And provides you with a customer specific product that can be manufactured In this manual e Con for Axapta is explained in detail The manual consists of a few main parts In Chapter 1 you will find an overview of our product Read this section to gain a good understanding of the different possibilities of e Con New features are also listed and the help procedures are described Chapter 2 describes installation Read Chapter 3 to understand the architecture of e Con For a brief overview of how a model is built in e Con read Chapter 4 This chapter provides a step by step explanation of how to set up your first easy model Chapters 5 through 8 completely explain Axapta integration All the tables and fields are described in detail in Chapter 5 Chapters 6 and 7 provide a lot of how to information how to set up enter and use the different e Con functionalities step by step Consult these chapters while modeling Chapter 8 tells you how to set up a product model Chapter 9 describes the e Con Studio how to set up rules which functions and attributes are available how to use them etc Chapter 10 provides you with information about troubleshooting If errors occur while modeling or running the model just read this chapter In Chapter 11 you will find a Glossary The main terms used are listed and expl
89. ation and click Create new node Entity As a result the entity as specifeid in the relation is added and the relation s settings are completed Also the relatione entity s key fields are added a field properties If required you can check and edit the relation s settings To do so double click the relation Only check and edit the settings on the Overview and the Relation tab You can also add the mandatory fields and extra properties to this entity In our example to be able to e Enter the bike s description add a field property Pick field ItemName Select the Editable and Visible check boxes e Enter the item type add a field property Pick field ItemType Select the Constant check box The field property s Default Code must be BOM e Enter the bike s model add an additional property Model with a field length of 30 Also select the Editable Mandatory and Visible check boxes e Relate to the BOM version in your model add a relation Pick relation BOMVersion Select the Editable Visible and Constant check boxes To Increase B V 22 TOINCREASE 5 Add option queries to entity members if required To offer the end user the possibility to select options from an option box you can add option queries to properties To add option queries e Goto the e Con main menu and select Option Query from Setup Solution Genter PRES E e Con i amp con Projects 2 Decision
90. atory fields appear in bold To Increase B V 212 TOINCREASE O However it is also possible to use your own font s and styles and add to the labels and fields appearing in the front end Other fonts and styles can be added to the style sheet of e Con e Con css and can be applied to a member due to a style Use the style controlclass and labelclass to apply styles to both the label and the field Question and Answer A few styles are standard available in the e Con css e eConMemberltalic Font style italic is applied e eConMemberBold Font weight bold is applied e eConMemberSmall Font size extra small is applied e eConMemberLarge Font size large is applies e eConMemberStrikeThrough The text decoration line trough is applies e eConMemberhight The alignment of the text is right e eConMemberCenter The alignment of the text is center e eConHighPriority The background color red the font colour yellow e and the font weight bold are all applied e eConMediumPriority The background color forest green and the font colour yellow is applied e eConLowPriority The background colour light grey and the font colour yellow is applied If more styles are needed or your own style you have to define them in the style sheet from e Con e Con css 7 19 How to add help text to fields in your model Within e Con it s possible to add help text for your model This help texts can be added for each field in the Ul There are two possibilit
91. ber Type Segu Con Label HELPSRE Additional Property O HELPTYPE Additional Property 0 HELPICON D D mi Additional Property HELPURL Itemid Additional Property HAREK onoono poda EEEE a Field Property e What s left is to link this new entity to the root entity InventTable 1 Add a new property from the type Relation Set up the relation between the entity InventTable 1 and InventTable 7 The label of this new relational property must be HELP Here as well e Con is searching for a reference Help to determine help settings Check the field constant for this relation don t check visible BE Letty Member Member Pepe Kelston HELIA Kee verc Model DIL Version nde 3 Lable Hame inerat abe Lathy Line pie 1 2 Denke CAMP weed Schon Henle se SELLEDLE zur La H Xd lintel roperty mn eF H7 E 0E H A Briveer s j All Mys er as Tele egn J OL M E Ie aja e Generate the data structure and open the studio e nthe studio add a rule to assign values to the properties of the help entity These values determines the settings and behavior of the help functionality The next values must be applied to these properties o HELPURL Determines the name of the help file The location of the help file is the folder Help as available in the e Con data folder The file as specified here must be available here The set up of this help file wil
92. chronize for that particular configuration is true This Synchronize field is located in the Configured Models table This table can be displayed by the function Configurations from the Functions menu available at the Generic Model Card E Generic Model No BIKE Bike demo model Seles Overview General Inte Description Active Version 1 Bike demo model i Ho Frontwheel Demo Model rm 1 gt Overview Model Setup Generic Model Version F Entities Model Interface Version Description Con Label Con Modeler Bike demo model version 1 Configured Models Copy Model Version Impart O Save a e The field Synchronize can be checked here for each configuration needed to update UserID Last Da Last E Admin 310 2004 15 18 13 Admin O 1310 2004 16 07 29 Admin 13 10 2004 16 42 25 Admin 13 10 2004 17 05 18 Admin 14 10 2004 09 43 28 Admin 14 10 2004 10 40 12 Admin 14 10 2004 11 40 06 Admin 14 10 2004 15 21 33 Admin 14 10 2004 15 22 15 Admin 15 10 2004 09 47 17 Model Status Configured uh Configured Heconfigured Configured Mew Hecoanfiqured Mew Mew Configured J E ST LISTL E IST ET ET IST P L P P Hecanfigured On Confirmation Each time when e Con detects a difference between the configuration version and active version of the model is asked if the configuration must be synchronized wi
93. cified in the e Con environment settings e Client the language of your computer e Document the customer s language as used in a spscific document e Selected in this case you get the option to select a language when you enter a configuration If you generate the model the label translations are added to the generated model 6 14 How to Work with Arrays In this section we explain how you can make Entities Repeatable and how you can define arrays for these Repeatable Entities A Repeatable Entity can be very useful when you want to offer the end user the possibility of selecting from among an undetermined number of members For example take the Bike demo model you can configure a Bike using this demo model but you add as much accessories as necassery To deal with this the Entity Accessory can be set up as a Repeatable Entity That means that a button labeled New will be displayed in the Front End so the end user can simply click this button for each new accessory needed Line Mew Line 6 14 1 How to Make Entities Repeatable As explained above e Con allows you to designate some Entities as Repeatable Entities This can be extremely useful when you do not know in advance how many Entities the end user will need The example given above was that of Sales Lines in the Sales demo model but we can also look at the example of Accessories in the Bike demo model OTo Increase B V 164 TOINCREASE O An Entity alway
94. ck Box in the Matrix 192 7 10 5 Add the Relevant Business Rules eeeeeennmmmmnnn 194 7 11 HOW to optimize a model ssesesennnn mmm 195 7 12 Optimize Launch detailed information eee 197 7 03 How 10 G00 a DOD UD SCIEN scie crsaset oesctincaeanrecenionne iodi rud uo bina ioni a Ob pa E Rien 198 7 13 1 How to add to show my default former and actual option in the pop up screen 201 7 14 How to add Tabs in the Front End of my model sseeeenme 202 7 15 HOW toada Radio BUONS cuc ortnm ruivtr motu ERE pEE FomunLU Eod ufu t Soa mEdaEE UE RIT i Imt 204 7 16 How to add and change Buttons in the Front End of my model 206 7 16 1 Adding an image at a button eo aue deercstdtonuictatdnes iita a Pa mii Pc RO pasa anc 209 zc OMOFO ON PEUT m m m Tm TM 209 7 17 How to add a Calendar Calculator or Rich Text editor to a member 210 7 18 How to change the style of the questions and fields in the Front End 212 7 19 How to add help text to fields in your MOCEl ecececeeceeeeeteeeeereeareeeeserens 213 7 20 How to synchronise my configurations against the latest model 216 7 21 How to add e Mail functionality to my model sesseenn HH 218 7 22 How to save my model without leaving the UI posting eseeeess 220 Ciaran CG CoC OM SCG IO P ERREA 223 Suo E26 UMEL 0 m 224 Chapter 10 Tro
95. copy a model e Inthe Generic Model form select a model O To Increase B V 180 TOINCREASE e Select a version of the model Click Copy Model Version H Generic Model No BIKE Bike demo model Overview General SEEN Model Setup ati Generic Model Version k Under Development P e Con Modeler J d Copy Model Version ND Enter new name and version Generne Model BIKE COPY e Fill in the Generic Model and Version for the new copied model version In the example shown the BIKE model version 1 will be copied to a new model with the name BIKE COPY and Version Code 1 The contents of this new model will be an exact copy of the BIKE model 7 6 How to View Your Configurations You can view the configurations that you created with e Con e To view your configurations e n the Generic Model form select a model e Select a version of the model OTo Increase B V 181 TOINCREASE e Click Generic Model version Configured Models BE Generic Mandel Mo UNE Llc domo model fol EDEN ED ET lil l Jiss dec redy 14 1 C CC4 Model Sebo TTT ma lhicnen 277 cine F P sendi F kr rem madi eina 1 ad xAmMuMs 4 ala u EE Fani Meech risa User ID Last Da Last EN b 13 10 2004 15 18 13 Admin 13 10 2004 15 07 23 Admin 13 10 2004 15 42 25 Ad
96. cost Unit price Bike demo model 100 00 160 00 Category v Model Type v Special Color F Frame Frontwheel E Backwheel 100 00 160 00 Chain E When the Front Wheel box is check marked the fields Rim and Number of spokes will also be shown OTo Inmease B V ggg EB e Con Frontend TOINCREASE mia Accessories Text Fields Bike demo model Category Model Type Special Color Frame Ii Frontwheel Rim Number of Spokes Backwheel Chain 6 11 6 Description 137 00 4 100 00 Multi line multiline Unit cost Unit price 224 00 64 00 160 00 The multiline style option enables you to display an Entity member as a text box with several lines e Go to the Entity Card of the InventText Entit Lm LLLA moo ahne ier ner te Mocel P Be epi tigse in snb BEE ITEM e 1 4 2 OTo Increase B V ROMTABLE B MVERSION ITEMLDCATION DDSTPRICE SALESFRMCE ea cai WHEE LAS SEMEL DHAIMASSEMELY FIHALASSEMBLY INSPECT PAINTINGDEP CHAINAS SEMBLYOPH InventText 1 labeled TEXT 150 TOINCREASE O e Go to the Entity members e Select the Entity member labeled TEXT so that the whole row is highlighted and then click on the Styles button The following screen will appear EB Entity Member Style Style 0 Generic Model BIKE Version Code 1 amp
97. cttirst selectsingle alasource uicontrals Ligraups Description 4 delete button is shown to delete array members To Increase B V 125 TOINCREASE O With styles special behavior can be added to properties Special behavior added by styles are for examples e Copy and delete buttons for arrays e Radio buttons e Buttons e Styles and colors for labels and fields e Etc e Con Styles pane Overview of all styles Styles are grouped in a folder structure here Description Explanation of the style Options Options available for the selected style Buttons m Save current record si Save all changes 7 Initialize styles All available styles and values are up loaded in Axapta when clicking the initialize button To Increase B V 126 TOINCREASE O Chapter 6 e Con Axapta Connector Data Structure In this chapter we explain the elements needed for setting up a model and we explain the functionality of certain options 6 1 e Con Project e Con Projects are helping in the management and maintenance of the models All e Con Configuration Models within a project can be Build compiled in one simple action The inbuilt project explorer offers a tree view of the project Different tasks and actions can be started from here e Con Projects are specially helpful in complex model structures build out of different sub models All models can be tight together in a project Add a project by right mouse click
98. culate the expression as keyed in the Expression field Button Clear To clear the how and why content All fields will be blanked Member Model Path The path in the data structure to the selected member Rule Model Path The location of the rule where the value derives from This is especially useful when there are sub models This path locate in which model the rule is available To Increase B V 229 TOINCREASE O Condition The condition of the rule where the value derives from Implication The implication of the rule where the value derives from Below we provide step by step instructions for the quickest way to find the cause of error messages The Bike demo model is used in our example 1 Start the e Con Studio in the relevant model 2 Save your model to another file For example a file called BIKEAXA ERRORTEST To do this go to the File menu at the top of the Studio and select the Save As function E e Con Studio Edit View Tools Help Mew Open Close lg Save BIKES Ctrl 5 Save BIKEAXA 1 As Save All Ctrl Shifk 5 k Tab Images Connection Buttons Category Model Type Weight Special Color Color Exit TEC E EE NES E E EB RES EB Bk OQ To Increase B V 230 TOINCREASE CE E Save Model As 3 4 BIKEAXA 1 3 BIKEAXAC 1 3 4 FRONTWHEEL 1 3 3 FR NTWHEELAXA 1 3 4 FRONTWHEEL 1 3 4 FRONTWHEELAXSA 1 3H MN BIKE 1 3 T MNBIKE3 1
99. d Yellow These options are stored in a query see section 3 3 In the Option field the value displayed before the Option Description Delimiter is chosen whereas the value after the Option Description Delimiter is shown in the Front End Example the Option Description Delimiter is a semicolon 1 blue 2 red 3 yellow Now the end user has the choice between Blue Red and Yellow but in a rule you can say If option is 1 then price is 10 OTo Increase B V 115 TOINCREASE O E e Con Setup eCon Server Modeler Configure li Multi Language IN o User Language IE elected Context Driven Mo 5 2 36 4 Fields of the Configure Tab Multi Language To activate the multilingual functionality When yes is selected the label translations of the e Con labels will be added to the model during the XML file generation User Language Setting concerning the language selection for an e Con model There are four options Default The default model language is always the model language Client The Axapta client language is the model language Document The language of the customer of for example the quote or order e Con is started from is the language of the model Selected The model language is manual selected each time the model is started Context Driven To activate the context driven functionality 5 2 36 5 Button Edit Environment To open and edit the environment settings The environm
100. d to a BOM Bill of Materials Master Detail A relationship of one to many 1 n A BOM line can be related to just one BOM Header Relation Link Primary key fields that are linked in both related tables Entities These are required in order to establish a relationship in a relational database Key Field Unique field of a record that is always required when a new record is inserted in a table Key Value A Key Value can be assigned to an Entity and will act as a template for the Entity All the fields that aren t automatically entered by the Entity will be retrieved from the Key Value Using the Key Value of the Root Entity the model can be started up from different processes in Axapta Root Entity Highest Entity that is linked to the generic model Query There are two types of queries e Selection from a Axapta table e Option list for an additional property To Increase B V 237 TOINCREASE O Style Styles can be added to a member influencing what it does Context The business context or department from which e Con is activated e g Production Decision matrix Matrix to set up interdependencies between member options To Increase B V 238
101. e memb QsStyle mgsrc With this style the source of the images can be designated This source consists of the name of the image and the path where the image is stored There are two ways to designate the source o Notate the complete path as follows C My Images Bike jpg o Notate the relative path the first part of the path always being the path where e Con is installed For example images bike jpg The complete path in this case would be C eCon images bike jpg e memb QsStyle l mgvisible With this style it s possible to make an image visible or invisible An image is always visible by default To make the image invisible assign a string with value false to this style To make the image visible again assign true e lt memb gt Style mgposition This style can have four values Left Top Right and Bottom With the style the position of the image is set When Left or Right are chosen the image area will be shown at the left or right hand side of the Front end without overlapping the questions and answers fields With Top and Bottom the image area is shown above or under the Front end e memb QsStyle I mgleft After determining where you want to have the image right left bottom or top on the Front end with imgposition style you can go further and determine where exactly you want the image to be positioned in relation to the left margin of the image area e memb QsStyle mgtop
102. e If you do not specify the Image Height see above this style will scale your image to the proper dimensions 6 11 16 Template With this style a key value of an entity can be changed For instance the key value of the Bike Model is item e Con Bike Item fields that are not changed by configuration like Posting groups will be used from the key value item With the Template style the item to be used as the key value can be changed so the configured item will be based on another item with for instance other Posting groups 6 11 17 Default With this style the behavior of the default attribute can be changed When the value init is assigned to this style and this style is applied to a member with the attribute default the default value is only used when the member does not have a value In other words The default is only set when the member is empty O To Increase B V 153 TOINCREASE O 6 11 18 URL When this style with the value true is applied to a member the label of this member will act as a hyperlink Simple clicking this label will activate the hyperlink When this style is applied to a member displayed in a column the content of the column will also act as a hyperlink For example Applying the style URL to the member supplier where supplier has the value http wwwto increase com Will act in a hyperlink to the web site of To Increase Website www tO INCrease com Website www to increase com 6 11
103. e Overview pe Methods ok BH TabPage Geregal OBH TabPage Setup If the buttons are added to the form you can test the buttons To test the newly added buttons on the Dynamic Forms form click the Open form button at the upper right side of the form The form to which the buttons are added is opened In our example this is the InventTable item form OQ To Increase B V 53 TOINCREASE ES tem Item number WL 2500 Wall Lamp 2500 Color Overview General Setup References Price Discount Quantity Other Dimension Transactions Item number g B A14 B RB BIFE O00027 BIFE O00028 Item name g Battery Baby RH14vv Battery Penlight Ab BIKE ODD 27 BIFE O00028 Search name J BatteryB abyH 14 BatteryPenlightH E BIFE OO0027 BIFE OO00028 ltem group eCon Bike Parts Parts eCon Bike eCon Bike Item type BOM Item Item BOM BOM On hand Setup Trade agrmt Functions Inquiries e Con Bike Energy S avingBulb5w at Bulbs Item Energy avingBulbzwW at Bulbs Item BOM EnergyS avingBulbSwat Bulbs Item EnerguS avingBulbllw a Bulbs Item Energy S5 avingBulblawa Bulbs Item Con Bike e Con Bike Template eCon Bike Item E5B 005 Energy Saving Bulb 5 watt ESB DU Energy Saving Bulb 7 watt ESB 009 Energy Saving Bulb S watt ESB 011 Energy Saving Bulb 11 watt ESB 013 Energy Saving Bulb 13 watt Forecasting k Route Configure new If you want to e Con
104. e menu and select the Open function Select the original model in our example this would be the file named BIKE XML and NOT the copy we made for testing purposes called BIKE ERRORTEST XML The final step is to select the rule you now know contains the error and figure out what the problem is Tips amp Tricks Sometimes it s impossible to select an option for a member You can select an option but the field will be cleared once you leave the field of the member This is almost always caused by using a double equal sign in a rule instead of a single equal sign In effect you To Increase B V 232 TOINCREASE O have made an assignment or a default assignment for the member The single equal sign should be used to indicate an assignment while the double one indicates a comparison 10 3 List with most common syntax errors The most common error descriptions that may appear during compilation of the e Con rules are listed in the table below Possible causes are also provided after the last implication in the rule example an assignment You forgot an open parenthesis You forgo a closed parenthesis expected You forgot to add a semicolon after an implication in spite of the fact that there is another implication in the rule Undefined member the member You made a typo in the member name concerned is noted instead of the dots or the member has been changed or the member is no longer available in th
105. e Entity Member form appears E Entity Member Member Type Field Property Overview Field Method Relation Member Type Sequence e Lon Label E hi i C I ooo oe hal e You can enter the Default Code and the No Series on the Field tab Check the properties on the following settings pwms 0 Ye a pe TmGmug Yes econ ke ingroupd es Bum 1 7 wxsGmgd qe pr 1 e You can add extra properties to the entity You can add e Field properties which are used to enter data in or to retrieve data from table fields in Axapta To add a field property right click the entity and click Create new node Field Property Pick the field for which you want to add a property If required you can check and edit the field property s settings To do so double click the field property Only check the settings on the Overview tab and the Field tab e Additional properties which are used to enter additional data which will not be entered in or retrieved from an Axapta table To add an additional property right click the entity and click Create new node Additional Property Enter the aditional property s settings as required e Relations which are used to relate the entity to another Axapta table To add a relation right click the entity and click Create new node Relation Pick the relation that you want to add Add the relation s entity To do so right click on the rel
106. e data structure Undefined attribute the attribute You made a typo in the attribute name concerned is noted instead of the dots Member of attribute is undefined the You made a typp in the member of the attribute concerned is noted instead of relevant attribute or the member is the dots changed or no longer available in the data structure Undefined function the function You made a type mistake in the function concerned is noted instead of the dots Unexpected symbol You made a typo in the rule else expected The if then else structure isn t set up correctly you most likely forgot the else statement then expected The if then else structure isn t set up correctly you most likely forgot the then statement end expected The if then else structure isn t set up correctly you most likely forgot the end if at the end if expected The if then else structure isn t set up correctly you most likely forgot the end if at the end To Increase B V 233 TOINCREASE O expected You forgot the number sign in the declaration of the array Index variable not declared the You used an array in an implication but variable concerned is noted instead of forgot to define this array in the the dots implication concerned Attribute is read only the attribute Some attributes are read only In a rule concerned is noted instead of the dots an assignment is applied to a
107. e special functions available for arrays The following functions are available e Sort Array Key Sort a dynamic array OTo Increase B V 167 TOINCREASE O e ApplyFunction Array Function Field Condition Apply a function to all members of an array and return the result Functions supported are Sum Average Concat Min and Max Conditions supported are and lt gt In the following example the array items is sorted by the field price The outcome is a list of items sorted by price Condition 1 S50rtitems Implication 1 Items Sort ITEM Price 2 Sortitems false In the following example the sum of all properties Price of the array ITEM is calculated where the value from Quantity is not 0 Implicatian 1 Total ApplyFunction ITEM Sum Price Quantity lt gt 0 6 15 How to Add Images to Your Model With e Con it s possible to show images in the Front End Run the Bike demo model for a thorough understanding of the possibilities e Con offers You can set up this functionality in a flexible way and designate that different images be shown depending on certain members It s even possible to show more than one image in the Front End In this section we will go through the steps of adding images to your model e Add a member at the highest level of your model and name it IMAGES This member will serve as the trigger for e Con to show image
108. e the New button is clicked Read Only Relation The related entity will only be used to deliver data to the model No record based on the related entity will be inserted in the database after configuration External Link The relation is not referring to a child model and child table in Axapta The relation is used to refer to an external model stand alone model Only an empty reference is created during the generation of the XML document Details like the interface and sub model must be added in the e Con studio With the external link stand alone e Con models can be integrated in Axapta e Con models Child Model Can only be filled in if member type is Relation Here you can use the lookup button to select the Generic Model to which the relation refers When another model than the To Increase B V 79 TOINCREASE O current one is selected this will result in inclusion of that model Now the Root Entity is automatically chosen as the Child Table and Child Entity Child Version Active version of the selected Generic Model Interface Model The interface model to be used for the relation Interfaces are only required when the relation refers to a sub model child models differs from the current model Interface Version The interface model version to be used Query ID ID of the Query used The usage of the query depends on the selected member type Field property Selection of the records chosen in the Child
109. ected Description Description of the member In the case of a display method OTo Increase B V 71 TOINCREASE O Property Type Type of the display method not editable Length Length of Property Type has to be defined only if the member type is Additional Property Choose normal values like 12 for decimal and 30 for text 5 2 15 Fields on Relation tab B Entity Member Type Relation Overview Field Method Relation Child Model MYBIKE1 Table Relation EJ Child Version 1 Relation Type M aster D etai Interface Model Mo eme eee ee es ee ee Description BDMVersion Interface Version Child Table BOMersion Child Line No 1 Repeat C Guer ID Read Only Relation External Link Member Type There are four options Field Property link to a table field Additional Property field that does not exist in the Entity table but is used in the Front End and or in the e Con Studio Relation relation to another Entity Method link to a table display method table field Table Relation This is the table relation from the platform used in this relation Table relation information is required during the processing of the XML document Relation Type To Increase B V 78 TOINCREASE O The Relation Type is derived from the table relation
110. ed during the configuration process trigger the execution of rules OTo Increase B V 12 TOINCREASE O The configuration tool is generic which means that it is not a dedicated product configuration tool or sales configuration tool All kinds of models are possible for instance all the data of the Axapta database can be used to build a model and can therefore serve as an object for configuration Rules can be imperative which means that the sequence of the questions determines the end result This is the true of most configuration tools In e Con the rules are declarative which means that the sequence of the questions has no influence on the end result of the configuration This is a distinct advantage of e Con which makes the maintenance of data structures and rules much easier Example Starting position Engine 2 0 l Number of gears 4 AC No Rules If Gears 5 then AC Yes If Engine 2 0 then Gears 5 Imperative result Engine 2 0 l Number of gears 5 AC No Declarative result Engine 2 0 l Number of gears 5 AC Yes When a value is changed only the applicable rules are re triggered In this example the first rule will be executed again because the number of gears has been changed by the second rule e Con is web enabled Web technology is one of the architectural components of e Con The configuration takes place in a web browser Microsoft Internet Explorer 5 5 The models are
111. emo model Active Version Generation Gene 3 3 2003 10 46 33 144 2003 15 40 27 FRONT e Unc j 252008 41000 MYBIKE My bike I psan 2 5 2003 11 14 56 MYCUS Customer 00 00 00 TEST i 00 00 00 To Increase B V 128 TOINCREASE O 6 2 2 Version You can insert a version name for the new model by going to the version lines a Overview Version Description amp Lan Label Status Table Name E Bike demo model BIKE Under Development InventT able You can make multiple versions from the same model You can expand or change the structure of the model in the different versions The changes will only visible in the Front End for the active version To make a new version of a model you must copy a model version and select the new version as the Active Version number NOTE Do this WITHOUT changing the number of the model itself The description however can be changed in your new version This feature is very practical if you have a perfect working model for example and you want to test something in this model Naturally you don t want to risk messing up your perfect working model Instead you can copy this model to another version and then do your testing on this newer version If anything goes wrong your original perfect working model remains unaffected Tips amp Tricks Always provide a clear description of the model indicating the model s
112. ent specified at the field Environment will be opened Show license The XML license is shown The XML license is available in the e Con Web folder Data folders To create the sub folder structure as required for e Con in the data store as set up in the environment settings OTo Increase B V 116 TOINCREASE O 5 2 37 Import settings The Import settings form can be found by clicking on Setup in e Con and then selecting Import Settings z Import data File name C Documents and Settingsse Con setup xml lez Duplicates Update Validation Data and or settings can be imported here 5 2 38 XML Labels The XML Labels form can be found by clicking on Setup followed by Modeler in e Con and then selecting XML Labels OTo Increase B V 117 TOINCREASE CE Main menu e Con 3 5 Company tst Miaa General ledger Accounts receivable 1 views E e Con e Con Projects i Models Master planning E Decision Matrices RET e Reports Production Periodic Product Builder z Setup Shop Floor Control Metadata droen JRE Ee mL i Option Query l Human Resources il Z e Con Languages Questionnaire Parameters muU M EE 4 Import settings Bak Modeler ML Labels Model Table Link Context Transition Styles Accounts payable
113. eric Model BIKE Version Code 1 Eel Table Mame Lin e on Label Type Use Action on Duplicate Entity Members i NNNM 9p AES IB Generate Key Fields FR NTWHEEL Class Stop Process BACKWHEEL Class Stop Process Ke vaue j CHAIN hil Class No Stop Process Copy Entity Entity SADDLE Class Stop Process LIGHT Class Stop Process BELL Class Mo Stop Process BRAKE Class Stop Process HANDLEBARS Class Mo Stop Process MUDGUARDFRONT Class No Stop Process Class Stop Process e Select the line for the Entity member FRAME so that it becomes highlighted and then click on the Styles button The following screen will appear ES Entity Member Style Style 0 Generic Model BIKE Veikion Code 1 MES Value Description Add the style with CTRL N OTo Increase B V 145 TOINCREASE O EB Entity Member Style Style 0 Generic Model BIKE Version Code 1 EE Style HTML description Value Description selecttirst selecttirst The selectfirst style is activated in the column Value Description by setting it to true The result of this style choice is that the first frame is selected 6 11 2 Key key The key style displays the information requested in a previously defined order To demonstrate the functionality of the key style we will use the Bike Model once again
114. erty Relation DIEDEED Sdoaogaadaada s s DdOEDEDDOS r esr 5 om ERonanann z Field Property e Select the Entity member labeled FRAME e On the Relation tab the query is added In this case the FRAME query OTo Increase B V 142 TOINCREASE CIS ai EB Entity Member Member Type Relation FRAME Generic Model BIKE Version Code 1 T MBE Oveniew Fei Menoa Rasion ooo Member Type PERH GS UM Relation Type IR eference v Table Relation Repeat Description Child Model BIKE Child Version 1 Child T able InventT able e Child Line Ma P Query ID FRAME D Read Only Relation e To see the FRAME query go to Setup Option Query and select the query to look for e Dynamic Query is set to Yes So this is a dynamic query All the filters are set the Same as for not dynamic queries IE Cetin Ower File Fral razuntk Friii FLYWHEEL pxnFrd LLL as I reza iL rad e All items with Itemid starts with 19 and ItemName starts with Frame are the result of this query This query looks like a standard Option Query The only difference is that the field labeled Dynamic Query is yes The rest of the dynamic section is provided for in the Studio rules e Go to the e Con Studio e Select Rules go to Configuration and select the rule Frame choice OTo Increase B V 143 TOINCREASE BIKEAXA 1 3A BIKEAXA
115. es E e Con Languages Parameters Import settings 9 Modeler Cost accounting E Platform Questionnaire Project Administration e Con Generator Solution Center OTo Increase B V 137 TOINCREASE Using this form a query can be created Queries are used to select information from Axapta Tables or to provide selectable options which are not present in a Axapta Table You can insert a query by selecting New item or New subitem from the context menu in the queries tree Te tl a ACCESS ACT OF ACTLIATOF ALTA OF TAS ADD DHHS Aidan g Properties Daana Descipiion Table ior T abl Dynamic Demy ies Onder by Option Wa Option Feld Keine Urie 1D Feed You can select an existing query by selecting the preferred query for the entity member Go to the Entity Member form and select the query EB Entity Member Member Type Relation FRAME Generic Model MYBIKE Version Code 1 EBE Styles Member Type Relation V Entity Relation Type Reference yt Table Relation Repeat Description Child Model MYBIKE E Child Version 1 4 Child T able Invent able mi Child Line Ma 2 E Query ID FRAME EA Read Only Relation To Increase B V 138 TOINCREASE O By selecting Go to the maintable from the context menu of the Query ID field the query table is selected 6 8 How to Define an Option List In this section we take you t
116. extreme WEIGHT 58 Mountainbike instinct WEIGHT Mountainbike ult ultimate WEIGHT Sportbike golfo glo WEIGHT Sportbike sotik 000 plava WEIGHT ID 4900 d Spartbike torrente torente WEIGHT 4 1 Tourbike i baha WEIGHT dB Ba Tourbike Bo meden 0 WEIRHT amp bh An overview of all linked values added in the decision matrix 5 2 24 Application Server Application server can be found in the Periodic menu The application server is the server that handles the request of e Con for the real time data access to Axapta OQ To Increase B V 95 TOINCREASE CE Main menu e Con 3 5 Company tst Accounts recevable Accounts payable lnventory management Master planning Production Product Builder Shop Floor Canta Human Resources Questionnaire Project Cos secounting Cost purpose E Basic Administration e Lon Generator Solution Center 5 2 24 1 H e Con Application Server Application Server My alerts Views B ES Reports Periodic Em BApplication Server W Generate models Export Ee Offline Setup Platform Overview tab Name of the application server Default name is eCon Server and eCop Server Any name is allowed here OTo Increase B V 96 TOINCREASE O Processing This field indicates if the Application Server is used for Document Processing The Application Server can eithe
117. ferent statuses New Whenever a new version is inserted the default status is New A new version can be inserted by selecting the Copy Model option or by inserting a new line in the Version form When the status is New the data structure can be changed When a version has this status it cannot be used for configuration Change the status to Certified when you need it for configuration Once the status of a version has changed from New to Under Development Certified or Closed the Status can t be changed to New Under Development This status is used to modify the data structure When you want to change the data structure of a version this status has to be chosen Change the status to Certified when you want to use the version for maintenance of rules or for use in the Front End Certified Only when the status is Certified can it be used for the Front End or for maintenance of rules This means when the Key Value of the Root Entity is selected in the Sales Order the Front End is started but only if the status is Certified When the status is changed to Certified a number of checks are performed to ensure the data structure Is correct If the Member Type is Relation has the link if needed been made Do the relations defined refer to existing Entities If the Member Type is Field Property is a Table field selected Etc Closed This status is selected when a version has to be blocked for use Use this
118. figure or copy an existing configuration click the Configure button If you do so the following form appears Update curent configuration Copy to new configuration Choose whether you want to update the current configurations or copy it to a new configuration e Enter a new configuration click the Configure new button If only one model has an active certified version with as root entity the concerned table this model will directly started In our example this root entity is the InventTable If however several certified models with the same root entity exist a list is shown from which you can select the model that you want to configure ES Select model Description My Bike version 1 My Scooter version 1 After the configuration is processed the form from which the configuration is opened appears displaying the just configured record OTo Increase B V 54 TOINCREASE O Chapter 5 e Con Axapta Overview 5 1 Purpose of Axapta e Con Module The purpose of the e Con Axapta connector is e To make the data structure of the model e To translate the configured XML object into objects that can be imported into the Axapta database In fact the e Con Axapta Connector is the Back End of e Con 5 2 Tables This section describes all the tables and forms that are used in the e Con Axapta Connector 5 2 1 e Con Project e Con Projects can be used to manage your models Models and sub mode
119. fter this action leave without exit This can be especially useful when multiple configurations must be made with almost the same specifications After posting a configuration the change can be done posting changing posting etc To set up the post functionality few actions must take place e Installation from another eCon Application Server Since the posted configurations are picked up by the eCon Application Server and afterwards processed a separate eCon Application Server is needed here e Adding from the additional eCon Application Server to the eCon Application Server Handling table from the e Con Set Up menu e Adding a post button to the UI e Adding a few rules to control the assignment of the right object id s Installation from another eCon Application Server For information concerning installation of a second eCon Application Server see the installation manual from MBS Axapta Setting up the eCon Application Server Handling table e Inthe e Con menu click Periodic e Con Application Server e Enter a new line and fill up a name for this Application Server Check the field Document Processing This indicates that this Server is used for the processing of posted XML documents To Increase B V 220 TOINCREASE Overview General Start Server e Con Application Se Processing Status Batch group Stop Stop Server Apnpl5erve E Stopped eLon Hor em c topped Adding a Post button to the Ul e Inthe e C
120. fy the structure and generate the model OTo Increase B V 29 TOINCREASE CI ai 20 Certify the structure To do so in the e Con Model form click Certify L a Generate Model e Con Modeler Configured Models 21 Generate the model To do so in the e Con Model form click Generate Model Generate Model F Configured Models E Infolog Information Model has been generated 23 View the result To do so in the e Con Model form click Configure The result will look as follows H e Con Frontend Sees ENTE m mm Model Frame wheel O To Increase B V 30 TOINCREASE CE Finally configure your first bike process the configuration and view the result in Axapta To do so 24 In the e Con Model form click Configure and enter the configuration in the e Con Frontend E e Con Frontend Seles You are logged on as user econ Member Value _ Item Name My first Bike a re a 85 Frame Frame man s bicycle steel w wheel C 25 Click Process to actually enter the configuration in Axapta 26 To view the result in the e Con Model form click Configured Models V nenu eL 5 Model Status E UserID Last Da Last re
121. ge Compatible You can setup e Con and your models in such a way that you can use several languages To make you e Con models mulitlanguage compatible In the e Con menu click Setup e Con Languages In the e Con Languages form enter the languages that you want to use You can enter label translations for all languages that you specify as e Con languages However only the e Con languages for which you set the value of the Enabled field to Yes are used when the model is generated H8 e Con Languages Lang Description English Llnited States I3erman Standard D uteh 5tandard Add label translations for the languages that you have specified as e Con languages To do so in the e Con menu click Setup XML Labels In the XML Labels form in the upper pane select the label for to which you want to add translations In the lower pane enter the translations You only need to add translations for the self defined labels ES XML Labels Code BIKE Bike 2 Lang Description To enable the use of the created translations click Settings Parameters To Increase B V 163 TOINCREASE O e n the e Con Setup form change the value of the Multi Language field to Yes e Con Setup E Lx IE eCon Server Modeler Configure Multi Language User Language Selected A Default Client Document e nthe User Language field specify which language will be used if you enter configurations e Default the language as spe
122. h subsequent groups until the error message no longer appears At that point you can be certain that the rule causing the error is located in the last group you deleted Go to the File menu and select the Open function Select the original BIKEAXA model and repeat steps 1 and 2 This ends up in a BIKEAXA ERRORTEST model which is an exact copy of the BIKEAXA model Now that we know in which Group the rule causing the error is found the next step is to identify which particular Rule is causing the error This is done in much the same way as identifying the group Click on the relevant group in the folder tree to expand it Delete the first rule in the group and check the results by using the Browse function to view your model Again there are two possible scenarios a The error message still occurs Now you can be certain that the rule causing the error cannot be the rule you have deleted Continue with step 13 b There are no errors found Now you can be certain that the rule causing the error is indeed the one you just deleted Proceed to step 14 Delete the next rule Again check the results by using the Browse function to view your model Continue with subsequent rules until the error message no longer appears At that point you can be certain that the rule causing the error is the last rule you deleted Now that we know which Rule is causing the error we can return to our original model not the copy To do so go to the Fil
123. he Value Description field is 50 which indicates our text box is 50 characters wide so in effect you have 50 little columns 6 11 8 Rows rows As described above the rows style is used in combination with the multiline and cols styles The rows style determines the height of the text box In our example the quantity entered in the Value Description field is 5 which indicates our text box is 5 rows or lines high 6 11 9 Image Source imgsrc This style is only used in combination with images With this style the source of the images can be recorded This source is the name of the image and the path to where the image file can be found There are two ways to do this o By notating the complete path like C My I mages Bike jpg o By notating the path relative to e Con yvo the first part of the path then is always the path where e Con is installed For example Jimages bike jpg The complete path in that case would be C eCon images bike jpg 6 11 10 Image Visible imgvisible This style is only used in combination with images With this style it is possible to make an image visible or invisible An image is always visible by default To make the image invisible assign a string with value false to this style To make the image visible again assign true To Increase B V 152 TOINCREASE O 6 11 11 Image Position imgposition This style is only used in combination with images
124. he default option for the Category Citybike OQ To Increase B V 92 TOINCREASE 5 2 23 7 Link Values E Decision Matrix Decision Matrix BIKE 1 Decision Matrix BIKE e Con Options Con Label i Option Description t Citybike City Bike CUSTOMER Mountainbike Mountain Bike MODEL Sportbike Sports Bike Tourbike Tour Bike Related Options for CATEGORY Citybike e Con Label Lirik Values CATEGORY aoe CUSTOMER amp Lon Label Style Va t Link Values UVUSRCSSPUCTCVLPVUSERCUULICUUUVUVCTUTUFVWVTUVUTTUPRUUT b MODEL WEIGHT e Con label The label identifier of the linked value This value ts linked to the option checked at the link tab Style Value Linked value itself To Increase B V 93 TOINCREASE O 5 2 23 8 Link Values button Defaults z Decision Matrix Link Addition m m Eg Iv ervieuw e Lon Label Style Va a EIGHT Default label and value can be set up here These labels and values will be defaulted in for every checked option of the decision matrix e Con Label The default label identifier of the linked value Style Value Default value itself 5 2 23 9 Link Values button Overview To Increase B V 94 L TOINCREASE CE t Decision Matrix Link Additional Data Decision Matrix BIKE 1 Overview CATEGORY e Con Label Citybike popular PRICE Citybike Ps 77 Citybike tranza WEIGHT 6 3 Mountainbike
125. her models the default frame should be 1900 Frame man s bicycle Steel e Add a new rule and enter the following in the Id and Label fields Default for Frame e For the condition enter MODEL lt gt e For the implication enter BOMVersion FRAME FRAMEGdefault 2ir MODEL Kids Bike then 1920 4 else 1900 Bend if e With this if then else structure we accomplish that the default code for the frame is 1920 when the MODEL is equal to Kidsbike and in all other cases the default is 1900 The if then else can be copied from the Expression Builder and is located in the Conditional categorie OTo Increase B V 47 TOINCREASE O Id Default from Frame Label Default from Frame Condition MODEL lt gt Implicatian BOMVersion FRAME FRAMEGdefault 2if MODEL Kids Bike 3 then 1920 4 else 1900 Bend if e Check the results by using the Browse function to view your model Tips amp Tricks An if then else structure always consists of three elements If then else Such a structure also always ends with end if As much end if as if exists 5 In the next rule we will configure a rule so that when the model is Hybridbike the wheel can t be selected Making the wheel member invisible will do this e Add a new rule and enter the following in the Id and Label fields Wheel in visible e For the condition
126. hrough the process of defining an Option List Query In the Bike demo model there are several different bicycle models for the end user to choose from Let s take a closer look at how this set of options or Option List is built e First select the InventTable 1 Entity on the Entities form and then go to its Entity Members by clicking on the Entity Members button Once in the Entity Member form find the member labeled MODEL of type Additional Property SPFELIALCOLUR 40 Additional Property F COLOR AU Additional Property IMAGES d H LITEVERSIOM Relation TEXT Relation e On the Field tab you find the Query ID field with BIKEMODEL as query EB Entity Member Member Type Additional Property MODEL Generic Model BIKE Version E amp Overview Field Method Relation Styles Field Name Description Property Type Text Length 20 r Child T able L Quer ID BIKEMODEL L Default Code Ma Series Step Size for Auto Numbering e To see the options of the BIKEMODEL query go to Setup Option Query and select the query to look for O To Increase B V 139 TOINCREASE O Option peice dew Propels ieee Lars Bitre E areas L dcm II ESI TT Fiperer Dabei Beccripison mile irra basal abus Tate q medenbiejen D presso Dues Ho pola b olo
127. ies to display those help texts e As tool tips Moving the cursor over the field in the e Con UI will display the help text as a tool tip This kind of help text is added to the demo model BIKE e Asa separate button displayed at the right side of the field The user has to click on this button the have the help text popped up To add these help texts the next steps should be performed e First add a new entity with the label HELP The entity table is not important so just select one E Entity e Con Label Generic Model BIKE Version Code 1 New Record BEP Table Mame Li e Con Label Type Action on Duplicate BOMYersion 2 BUM Version Class Abort if found Generate Key Fields InventT able b BUTTONS Class Abort if found PTT Class Abort if found InventTable 1 BIKE Class Abort if found lnventT able 3 InventT able Object Abort if Found e Generate key fields for this entity and add the next members To Increase B V 213 TOINCREASE O o HELPURL o HELPICON o HELPTYPE o HELPSRC Those members are required to set up the help texts Later on values are assigned to those members by means of the e Con rules e The names of the labels comes very precise since e Con search for properties with these names to determine the settings for the help functionality H8 Entity Member Member Type Field Property Generic Model BIKE Version Code 1 Seles Overview Field Method Relation Mem
128. ight customer In e Con this additional information can be shown in a pop up screen In this pop up screen columns with additional information are displayed An option can be selected by simply clicking it The option s value will automatically take over the member field The section below describes how to add this functionality e First make sure that the additional information that has to be available in the pop up screen is a property of the option member For example the item name item cost price and item sales price have to be properties of the option member item To have more selection data e Before continuing a short description is given how to add such properties to a member The frame selection will be used as an example o Add new entity members to the InventTable 2 entity of the example of chapter 4 These are the properties to be shown in the pop up screen O To Increase B V 198 TOINCREASE mia Labeij FH ERU UII LL TERES EM Version Code 1 I Lin e Lon Label Entity Hanba dil Generate tiny iih WHEEL BOMHEADER Kern BOMVERSIUM Egy ITEM 1 Duet ji 58 Daaba Marma EB Entity Member Member Type Field Property NAME Generic Model MYBIKE Version Co EEF verview Field Method Relation e Con Label Sequ Member Type s sess Entity ATEMID E Field Property ALI ll Table Relation SALESPRILE NAME Field Name ItemName COSTPRICE Display Method CostPcsPrice SALESPRIC
129. in Axapta and the business rules are built in the e Con Studio The data structure in Axapta consists of a few elements listed hierarchically e Con Project optional Generic Model Version Entity Entity Member OTo Increase B V 15 TOINCREASE O The highest mandatory level is the Generic Model It consists of a name and a description An e Con project is actually the top level but it s not mandatory to use a project Projects are useful and actually highly recommended when there is more then one model involved the so called sub models The second level is the Version Just like the BOM and Routings in Axapta a generic model can have versions The next level is the Entity Using Entities you determine into which table e Con is to insert records For example if you want to create an e Con model for the configuration of customers an Entity for CustTable is required because Axapta stores customers in the CustTable The lowest level is that of the Entity Member Using members you can specify an Entity in more detail It is not enough to just tell e Con into which table records must be inserted because a record has many fields that probably have to be configured in a certain way That kind of information is set up in the members of an Entity There are three types of Entities members e Field Property e Additional Property e Relation An Entity member of the Field Property type is used when you want to enter information in a fie
130. in the e Con Projects pane and select new e Con Projects FRONTWHEEL E IFRONTWHEEL e LTEM Hide Setup Record info memes Refresh cmm Properties Description h l lLl E mM l Enter a name and version and press OK E New Item Description Engine Version 1 The project is added Next step is to add e Con models to this project This can be done by simply selecting models in the right pange first create a new record and afterwards select a model OTo Increase B V 127 TOINCREASE HE Can Pra jects eram Hoda i TH D escnplinn Enna Hon Door Advanced Tinig Modi V CUBTOMER Properties Deseripiion AB mew varmeant Hn Models can be added as well by selecting them with the Get model version function available under the project button E S ek model version h Generate xML e Con Studio Model version gt Model version gt a Saveas Saveas 6 2 Various Data Structure Components The foundation of a model lies within the data structure In this section we will explain the various components of the data structure that you will encounter while working with e Con 6 2 1 Model Using the Generic Model form you can lay the foundation for a new model To do so simply add a record with CTRL N EB Generic Model No BIKE Bike d
131. ing and telesales e Etc The end result is a sales document order or quote with all the necessary commercial information needed for the sales processes It may also contain customer requirements for additional engineering or product configuration Example Sales prices and discounts depend on specific customer details like their order history and contracts The commercial price is not based solely on the products sold but also on the services rendered 2 2 3 Customer Configuration As indicated above a configuration tool like e Con can be used to configure many other things besides products and orders In some cases for example the positioning of a prospective customer or current customer is based on a complex set of issues such as the customer s relationship to other customers in the case of multinationals These interrelationships can present a very complicated picture But e Con can support the process of dealing with this interrelated information In many situations the e Con end user will be entirely unaware of the complexity of it all because they only have to deal with e Con s simple clear questions 2 3 Architecture Architecture of e Con OTo Increase B V ll TOINCREASE O LE LE J mnsan f Expertise ai gue ai MAL Configuration Suite Wu sel HTML Modeler Business Information InfoPath m y m P XForms Cl E DI Teal End Users Na LLLA E 92eJJ9 u Jesf Modeli
132. ing queries in the tree OTo Increase B V 107 Lon Lebe m TOINCREASE O E Inventlduernes ALLESSUHRIESBIKE WHEELS 5 2 31 Properties tab of Query details ACCESSORIES details Properties Datasource Description Table Invent able Dynamic Query Yes Order by Option Na v v Option Field Iter ame Unique ID Field Table Name of the table to which the query refers If you want to make a selection based on for example the items select InventTable here If options does not exist in any Axapta table just leaf this field empty Dynamic Query When this box is check marked the records that fit the result of the query will not be added to the XML document The values are taken from the database only by means of rules See section 6 6 3 for further information Order by Option Value Only applicable for queries based on Axapta tables When this box is check marked the order of the option list as shown in the drop down box of the Front end is based on the Option Field No Without this box check marked the order of the option list is based on the primary key of the table Option Field No This field is added to the XML document It is used in the drop down boxes of the Front End In general it is easier for the end user to choose between various descriptions than to make a selection from among item codes The name entered here refers to the table field of the Table indicated af
133. ion Description r gt Citybike Ciy Bike Mountainbike Mountain Bike Spartbike Sports Bike Con Label Option Description CATEGORY Bahia k MODEL extreme Extreme galfa Golfo m instinct Instinct je Medeo Playa L popular Popular Ol torrente IT arrente z tanza Tranza he e With check mark in the Boolean fields the relation between the options can be set For instance Only models popular and tranza are possible for Citybike OQ To Increase B V 190 TOINCREASE ES Decision Matrix Decision Matrix BIKE 1 Decision Matrix BIKE e Con Options Lon Label i Option Description k Citybike Mountainbike Mountain Bike Sportbike Sports Bike Tourbike Tour Bike Link Default Option Option Description L O i Bahia extreme Extreme 3 Playa Popular torrente Torrente tranza Tranza re Ja isis ultimate Ultimate e Fill the Decision Matrix for all the Categories 7 10 3 Checking the default option in the matrix In the Decision Matrix valid options can be checked Besides that the default option for a particular row can be checked as well Two steps are required to add this default behavior to the matrix functionality Select the matrix link and check for each row the default option In this example popular is check marked as the default option for Category Citybike OTo Increase B V 191 TOINCREASE O Dm
134. ion of the label is used as a description at the Front End e The version label has another special purpose the label ID will be used as the filename for the XML file created from your Generic Model Within the e Con Studio business rules can be added to this data structure The data structure represented by the labels is also available in the Studio Drag and drop functionality makes it very easy to use members from the data structure in your rules Furthermore there are a lot of attributes and functions available to meet special requirements like price calculation member in visibility member defaults consulting the Back End Axapta Database etc OTo Increase B V 17 TOINCREASE O After completing the rules you have to exit the Studio and save the rules Now the model is ready to use The last step is to integrate the model into your business processes if desired This makes it possible to start up the model from a certain form in Axapta like a Sales Order 3 2 How to Create Your Generic Data Structure This section provides step by step instructions on how to build a generic data structure The most elemental steps are described In order to get a more complete idea of all the possibilities you may need to study the manual and perhaps the training manual in detail This section will serve as a good starting point to introduce you to modeling e n this section we will build a simple data structure for a bike This bike consis
135. ionnaire E Parameters amp Import settings E Ly Modeler Project Cost accounting ML Labels Inm Model Table Link Context Transition Styles Basic Administration 5j Platform e Con Generator Solution Center In the form that pops up a query can be created Queries are used to select information from Axapta tables The end user will then be able to choose from the values selected at the Front End There are several types of queries e Query static this query is executed upon generating the data structure e Option Query this query is used to display options for additional properties that are not included in the Axapta table e Dynamic Query this query is activated during configuration by an add query rule in the e Con Studio OQ To Increase B V 106 TOINCREASE T NET ERIT Te E Ton iniy ACCESSORIES am Lire iier S Field eme Option ACT Lea TOF hemi 1400 1835 ALCTUATOURTAE ADD DSHS aien Typa TL od Properties Damus Dercnpimi wr Table Ivi T able Dynamic uap ye hei Order by Ophor Ho piron Farid Herria E Urep BD Field E 5 2 30 Query tree Hide Setup Record info Em Delete Refresh H AllCurrency AllCustamers AllGroups AllGroups2 ALLHYDRAULICITEMS Tree displaying all queries New Item Creates a new query New Subiltem Creates a sub item for the selected item Useful for group
136. ity e Con Label Table Mame i pe Action on Duplicate Entity Members k Invent able B 7 A nf SIE Generate Kep Fields Key Value Tips amp Tricks If you change the e Con Label make sure that the new e Con label s Description is also specified The descriptions are used in the final model To specify a description browse in the e Con Label field of the Entity form and add a description to the e Con label s Code O To Increase B V 20 TOINCREASE Code k bY BEE HAME 4 Add the entity members e To beale to create a valid record in the entity s table in Axapta you must add the mandatory field properties to the entity in modelling tree To do so right click the entity and click Create new node Entity mandatory fields In our example add the mandatory fields to the MYBIKE entity ES e Con Model No MYBIKE Designer i Internal model entities Table Mame a k Invent able 1 Record info Create new node k Additional Property Edit node Field Property Delete node Method Mame Relation Copy Entity key Fields Entity mandatory Fields Move up This results in the following i Modelling tree E InventT able Itemid d ltemGroupld Dim amp roupld i ModelGroupld OTo Increase B V 21 TOINCREASE O e Check the key fields and mandatory fields property settings To do so right click the property and click Edit node Th
137. ix OTo Inmease BV gg TOINCREASE O Unique alpha numeric code for the decision matrix Description Description of the decision matrix Active version One of the determined versions is the active version of the decision matrix 5 2 23 2 Version lines Versions Sa Version Description Starting Date Ending Date ki first version Add versions to the decision matrix Version Code of the version You can enter a maximum of 20 characters alphanumeric Description Description of the version You can enter a maximum of 50 characters alphanumeric Starting Date The starting date of the period in which the version is valid Ending Date The ending date of the period in which the version is valid A version can only be used for the decision matrix while it is valid To Increase B V 88 TOINCREASE O 5 2 23 3 Decision Matrix Tab E Decision Matrix Decision Matrix MYBIKE 1 Decision Matrix MYBIKE E Bangs aFGF DR a ry Overview Decision Matris version Lines Decision Matrix MEEI Active Version 1 Description My bike Use ML Datasource No Generation Date Generation Time 00 00 00 Decision Matrix Id of the decision matrix Active Version The version that is active Description Description of the decision matrix Use XML Datasource Field for whether this decision matri
138. king a button has to be assigned as a string value to the particular member that represents the button There are several standard tasks available to be executed Besides that java scripts can be added to buttons as well For detailed information about tasks available see the document e Con 3 5 Tasks Description 7 16 1 Adding an image at a button Instead of the labels of the button properties displayed at as button images can be shown up as well To display an image at an button instead of the label add the following style to the button property e Image with as value the location and name of the image E Entity Member Style Style image 0 Generic Model BIKE Version 1 Table Ad Style HTML description Value Description buttan button cols cols Image Image In above example the image help gif is displayed at the button This image is located in the folder image available in the web folder of e Con The web folder is default C Program Files e Con 3 5 Web 7 16 2 Other buttons Two other type of buttons exists as well These buttons can be added by using the following styles To Increase B V 209 TOINCREASE O e nlinebutton with value true The property is shown in the UI as a button This button is shown in the UI inbetween the other fields e Valuebutton This style can only be applied to Boolean fields The Boolean field with this style is displayed as a button Clicking the button wil
139. l be described later on in this section o HELPICON The icon and location oft this file to be displayed as help button The standard installed icon is help gif and is located in the images folder from the e Con 3 0 Web folder OTo Increase B V 214 TOINCREASE O o HELPTYPE Two values are allowed here tooltip and button By choosing tooltip the help will be displayed as tool tips from the particular fields in the e Con Ul The value button will add a help button at the right site of the fields in the e Con UI o HELPSRC The value of this member must always be external This means that the help must be retrieved from an external source ld Help Text Label Help Text Condition true Implication HELP HELPURL BikeHelp xml 2 HELP HELPICON images help gif 3 HELP HELETYPE tooltip 4 HELP HELPSRC external Tips amp Tricks It s also possible to assign the values in the data structure Simply enter the values in the default code fields from the properties of the help entity The final required step is to set up the help file itself Advised it to use the help file from the bike demo model as an example This file can be found in the e Con 3 0 Data Default Help folder The help file is a XML file itself with a certain predicted structured Let s use the next help file as an example to explain how to build up this file d C Program Files e Con 3 0 Data Detfault Help
140. l be generated from the Number Series we defined for the Field Property and this will be saved in the Item table 6 6 How to Change the Order of the Entity Members e Con allows you to change the order of Entity members for a particular Entity e Go to the e Con Model form with the Model Setup button on the Generic Model form Go to the Modeling tree i Modelling tree rm ES MY BIKE DESCRIPTION MODEL ITEM TYPE ITEMGAROUPID IHVENTDBIMID INWENTMODGROUP BOMYVERSION i i i i i i a i e Select the entity member of which the order must be changed e g MODEL must be before DESCRIPTION i Modelling tree E BIKE MYBIKE DESCRIPTION L ITEMYYPE a ITEMGR LIPID INVENTOIMID INVENTMOOGROUP a BOMVERSION To Increase B V 136 TOINCREASE e With Ctrl T place MODEL above DESCRIPTION i Modelling tree E BIKE MYBIKE o Inr 1 DESCRIPTION coo ITEMTYPE 1 ITEMGROUPID d INVENTDIMID amp INVENTMDDGROUP a BOMVERSION 6 7 How to Define or Add a Query e Select Option Query in the e Con Setup menu E Main menu e Con 3 5 Company tst Sele General ledger E e E z My alerts Accounts receivable H Views En e Con e Con Projects Models E Decision Matrices Reports i Periodic Product Builder Setup Shop Floor Control Ei Metadata group Accounts payable Production Option Query Human Resourc
141. lation IRI ganan Every Entity member has also a unique Label This Label is used in the e Con Studio for compiling rules End users however will see the Description in the Front End which appears as a sort of question they must answer For example Label DESCRIPTION Description Category ML Labels Paste selected label Code Labels P DEFAULT Default IE DIMENSIDNN Dimension No E EDITABLE Editable El EMAIL E mail ol END End m As you can see it is the Description of the Label that appears in the Front End as a sort of question to which the end user must provide an answer OTo Increase B V 131 TOINCREASE O E8 e Con Frontend You are logged on as user Admin Remai i Bike J Description oo CJ Model b T L Frame LJ Wheel If you use the label DESCRIPTION in the rule engine the Description of the label Description will be displayed under the model structure in section 1 below but the Label name DESCRIPTION below is used in the rule Label EE 06 Condition MODEL lt gt IDESCRIPTION MODEL BOMVERSION BOMHEADER MAME MODEL Implication 6 3 How to Define a Key Value You can find the Key Values
142. ld or change a field in the table concerned For example if you want to enter the name of the customer in your configuration model you have to add a field property that is linked to the Name field assigned to names in Entity CustTable assigned to customers An Entity member of the Additional Property type is used when you want to request or store information that isn t related to any Axapta table field For example in the Bike demo model we ask the user for the model and type That information isn t available as a field in Axapta So those are additional properties or actually they are a type of variable The last type Relation is used to set up the relationship between different Entities Here we will use the bike model as an example too The bike model consists of a lot of Entities including an Entity for inserting an Item a BOM version a BOM Header and several BOM Lines All those Entities have a certain relation because there is a relation in Axapta between those records as well The BOM version corresponds with an Item and is linked to the item via the Item no in the BOM version record The same goes for the BOM Header and BOM Lines which of course all have a relation to the BOM version The relations that exist in the Axapta Database have to be translated for the Entities To do this we use the Relation member type In the example of the bike there is a member relation in Entity InventTable
143. lied 6 11 33 Columnwidth With the aid of the style columnwidth the width of a column in the e Con front end can be set up This style will overwrite the width set up at the column With this style the columnwidth can be dynamically set up in a rule Make sure that properties exists at the top level of the model representing equal to the column id In the example the width of the column QUESTI ONS has a width of 200 at tab General and 100 at all other tabs Implicatian 1 QUESTIONS style columnwidth 2 i TAB General 3 then 300 4 else 200 5 end if 6 11 34 Inlinebutton The style labeled inlinebutton will present a property as a button in the e Con front end In e Con rules a tasks like print or email can be assigned to such a button Subject is Send 6 11 35 Labelposition With the aid of the style labelposition the position of the label of an e Con UI field can be determined The applicable values are right the label is shown right from the field Default behavior left the label is shown left from the field bottom the label is shown underneath the field top the label is shown above the field none the label is not shown at all OTo Increase B V 157 TOINCREASE O Main Fields Description Category wt Model Tvpe Ladies bic rm 6 11 36 Valuebutton The style labeled valuebutton will present a Boolean property as a button in the e Con front end Clicking the bu
144. llowing rule we will set up a default value for the Model member e Select the Rules folder e Right mouse click and select New Rule Enter an id and label for the rule such as Default for Model e De default condition is true which is fine for this rule This rule should always be executed so the condition is true e Copy the LeftHandSide Expression function from the Expression Builder Siply entering is possible as well e No we will use the default attribute to assign a default value for the model field The default attribute can be copied from the Expression Builder It s located in the category attributes Another possibility is to drag and drop the model property including the default attribute from the Object Explorer OTo Increase B V 45 Expression Builder Select a category Attribute Select an expression Member Column Member Constant Member Enabled Member Fieldfilter Member Fieldno Member Filter Member Filteron Member td Member Label Member Length Member Mandatory Member Options Attribute Default of a member Ten X Expression Builder Properties Replace the lt expr gt expression code of the attribute with MODEL OTo Increase B V TOINCREASE Object Explorer Objects 3A MY BIKE 1 13 My Bike Itemid ltem number ltem ame Item Name Item T ype Item type ltemGroupld
145. ls V eet ee tae J Decision Matrices Reports Production i Periodic Product Builder g Application Server E Generate models i Master planning Shop Floor Control i Human Resources E a Offline Questionnaire Setup ft 3 Platform Project Cost accounting Cost purpose calculation Basic Administration Con Generator Solution Center OTo Increase B V 101 1 TOINCREASE Export data m Export setup Check this field when the set up queries styles etc must be exported Export data Check this field when the data e Con models must be exported 5 2 27 Import XML Documents Import XML Documents can be found in the Periodic Offline menu Main menu e Con 3 5 Company tst Seles LE My alerts Accounts receivable ad Views amp ey e Con e Con Projects Models Decision Matrices L Accounts payable L Master planning Production Sa Periodic Product Builder E Application Server amp amp Ge
146. ls can be tight together in a project Convenient tools are available in the projects like e Generate XML files from all models within the project e Open de e Con studio for a project to maintain the models within the project Version is available as well gj FROMTWHEEL H RROMT WHEEL BIKE Bike demo node FFROBMTSWHEEL Fsanierherl Demo Hode IFAT HEEL Faorterhee hemes Model Properties Ceacripainns Ml maga venan Nn w 5 2 1 1 Fields of the Overview Tab No Code of the Generic Model You can select a model to be added to the project Version To Increase B V 55 TOINCREASE O The version of the Generic Model added to the project Description Description of the Generic Model added to the project Interface Model Indicator if the model added to the project is an interface model Checked when the particular model is an interface model 5 2 1 2 Fields of the Model Version Tab Overview Model version Identification Mode IKEE Staus Cetfied Version Code al Table Mame InventTable Description Bike demo model version 1 Starting Date e Con Label BIKEAXAC E Ending Date No Code of the Generic Model selected within the project Version The version of the Generic Model selected within the project Description Description of the Generic Model selected within the project e Con label Label of the version of the Generic Model selected within the project
147. m In our example a Configure and a Configure new button is added to the InventTable form To add a button to a form 1 In the Solution Center select Platform Dynamic Forms Dynamic Forms Du Iz E3 B Dynamic Form Setup SysTableBrowser form Buttons Acton Parent Control F m isi Button Properties 2 In the Dynamic Forms pane enter the form to which you want to add the button In our example enter the InventTable form Dynamic Forms Form Cae Tivent able SusT ableB rowser B e nthe upper right pane create a new action e nthe Action field enter the action that you want to add to the form The following actions are possible e EConConfigure this action only opens existing configurations So if no configuration exists for an item the e Con Frontend is not started e EConConfigureNew this action starts the e Con Fronten in which you can create a new configuration O To Increase B V 52 TOINCREASE O e n the Parent Control field specify the button s place on the form Buttons Acton Parent Control uil E ConCanfigureM ew EConCanfigure e n the Datasource Control field enter the grid To do so browse on this field and select the grid Usually you can find the grid under Tab Tab Methods TabPage Overview Button Properties security Key a Tab T ab p Methods SH TabPag
148. manual 7 1 How to Set Up e Con for Axapta By going to Setup in e Con s Main Menu and clicking on Parameters option you can alter or check the default installation settings e Goto Setup in e Con s Main Menu and click on the Prameters option The following form will open H8 e Con Setup eLon Server Modeler Configure e Lon Server localhost Edit Environment Data Folders OTo Increase B V 176 TOINCREASE e Edit environment Opens the e Con Environment settings For more nformation refer to the e Con 3 1 Settings document A Default Microsoft Internet Explorer provided by Watermark Nederland B V File Edit View Favorites Tools Help sack hi o ix F AF Y Search S Favorites e e d LJ 3 Address TT https localhostfeconadmin default aspx fenvironment axapta e Con Environments axanta Data BM eene MDs Data store e Con Axapta Data E ivor Navision seremlocahost Connection BE criver Xmi FILE D Temp eConData Datacources Products xml Connection Bs suDATABASE NorhwindTrusted Connection Yes o Connection J Local intranet e Show License shows the XML license Important is the name of the e Con server machine It must be in the e Con Server field and equal to the name in the license e Data Folders creates the folder structure that is needed by e Con The folder structure is created in the Data store folder as specified in the e Con Environment
149. mber to expand the menu and retrieve this member Use the drag and drop functionality to place this member in the rule 43 Messages TOINCREASE Object Explorer Objects M Y BIKE 1 13 My Bike Itemid Item number ltem ame ltem Name ItemT ype Item type lteriGroupld Item group Dimaroupld Dimension group ModelGroupld Inventory model group MODEL Model ig BOMVersion BOM Version BOMYersion BOM Version Itemid ltem number BOMId BOM M ame M ame FRAME Frame Wheel wheel id BOM ersion label BOM Version visible True default False id BOM Yersion label BOM Version column True constant True default BUMYersiorn length mandatory False repeat True store True style visible T rue amp options eCon Base E ConCallection 49 Env Environment t Rules ig Columns Libraries Interfaces EE e s s E E E E i o Replace the right lt expr gt expression code with the ItemName member Now the name of the BOM Version is set up to be the same as the name of the item OTo Increase B V 44 TOINCREASE O d Enter descriptions Label Enter descriptions Condition MODEL lt gt Implication ItemName MODEL 2 BOMVersion Name ItemName Tips amp Tricks When you enter more than one implication you have to separate them with a semicolon 3 Now we will add more rules In the fo
150. ment Table Link Field name Environment arable BSE Customer 5 2 39 3 Field name The field of the table which must be passed over to e Con Environment Variable The name of the variable argument used to store the value of the field This variable can be read in e Con with the GetArg function GetArg Customer will deliver the customer account of the sales line where e Con is started 5 2 39 4 Table Link Tab E Table Link Table Contest Table Environment Table Link Field name XML Path InventDimid CONFIGTABLE INVENTDIM INVENTDIMID temBOMId BOMVERSION BOMID ltemFiouteld RBUTEVERSION RDUTEID Name NAME SalesPrice PRICE Field Name The field of the Axapta context sales line in this case to be populated by e Con after processing of the e Con model To Increase B V 122 TOINCREASE O XML Path The property or property path of the model which value must be stored in the field specified in Field Name The value of property COSTS will be stored in the Axapta field CostPrice of the Sales line 5 2 40 Context Transition Context Transition can be found in the Set up Modeler menu MM Main menu e Con 3 5 Company tst Sime Solution Center My alerts views m ecen General ledger
151. min 13 10 2004 17 05 18 Admin 14 10 2004 03 43 28 Admin 14 10 2004 10 40 12 Admin 14 10 2004 11 40 06 Admin 14 10 2004 15 21 33 Admin 14 10 2004 15 22 15 Admin 15 10 2004 09 47 17 Configured Configured Hecanfigured Configured Mew Hecanfigured Mew Mew Configured rins mgam ag r P LI LI LI P Hecanfiqured e Con Model ID Automatically generated ID Synchronize If set to Yes before Configure the model will be synchronized during reconfiguration Model Status Status of the model Error Error messages will be displayed here To Increase B V 182 TOINCREASE O User ID User who generated the configuration Last Date Modified Date when the latest changes were made to the model Last Time Modified Time when the latest changes were made to the model Note it is also possible to view the configurations from the e Con Model form Go there with the Setup Model button 7 7 How to Start Up Your Model e Select the desired model on the Generic Model form the active version must be certified mg Date eConModeer eConModeer Modeler a Configurated Models Copy Model wersion Copy Model wersion Version e Click the Configure button on the Generic Model The e Con Front End will be activated To Increase B V 183 TOINCREASE O You are logged on as user Admin Remaining required fields 1 e Con Frontend Bike 3 M
152. modified The last date of stopping or starting the application server Last Time modified The last time of stopping or starting the application server Start Server button To start the selected application server Stop Server button To Increase B V 97 TOINCREASE O To stop the selected application server 5 2 24 2 General tab H e Con Application Server Overview General shart server General Stop server Application Server feConServer Stop No Processing Ma Status Started v Run as Startup command Last Date Modified 13 03 2006 Custom Reader Class n Last Time Modified 134542 Trace Trace Yes v Directory CATemp Long queries n Hc Application Server Name of the application server Default name is eCon Server and eCop Server Any name is allowed here Processing This field indicates if the Application Server is used for Document Processing The Application Server can either be used to consult the Axapta database during the configuration process or to process the XML document after saving The last option is only used when the Post functionality is used Post functionality allows to save and process a configured document without exiting the e Con UI Run as This field has two options batch and client e Client The client is used as an Application Server Clicking the start button runs the current client as the e Con application server e Start up command An A
153. mport XML Documents sssessseseennm mmm nennen nia 102 5 2 28 Metadata group ssssssssssseseen mmm nemen nnn nn nan nenas 103 5 2 29 Option Query enemies nnn nena nnn 105 SV MESURES Ce 107 5 2 31 Properties tab of Query details sseseeseeennm mme 108 5 2 32 Datasource tab of Query details sese 109 5 2 33 Description tab of Query details eee 109 To Increase B V 3 TOINCREASE O 5 2 34 Option Query Line Tab ssssssssenssrsrsrnsrsrrrrrrsrsrrrrsrsrrrrsrnrnsrsrrnrerernre 110 5 2 35 e Con Languages nn 111 5 2 36 TParatiiBl el S usuensestemxiuaua recs nau Edu MIR UNIES eM Uia u MR D 113 5 2 36 1 Fields of the eCon Server Tab ccccecececseseseeeeeueeeeeeeeaeeeseeetens 114 5 2 36 2 Fields of the Modeler Tab cccccsceceeseseeeseeeetereteeeeaeeuaueereretess 114 5 2 36 3 Brem C 115 5 2 36 4 Fields of the Configure Tab seeenm mH 116 5 2 36 5 sitire e 116 Du 3I MON SOLOS imabitikanM ena ene Dunn faphtbdrai diar IS FPE fcEvE M PIET RE EIUm RON 117 DNUS MEDI TNE I Imm 117 9 2439 Model Tape BID indeed pit as ERE pla a bM CES EE 120 5 2 39 1 Table CODI XE T aD Meee erent etre A EPI an EA nnn ERE ebbe att 121 5 2 39 2 Table Environment TaD aascxmtunoEVRDONU BO ERE HM XIII RIP abe RUNGRR 122 5 2 39 3 FIGLIO TIBTEIB aerositanon E E FUR EUR hare vM qr FILE FUPF Eae eR E
154. n The style init line triggers the auto split key functionality from Axapta The value of the style is the initial line number from where with the aid of the auto split key functionality the first free sales line number is found To Increase B V 155 TOINCREASE O 6 11 28 Delete With the aid of this style it s possible to delete a repeatable entity When an entity is repeatable a button new automatically appears With that button you can add new entities However standard there isn t a button to delete a repeatable entity By applying this style with value true to the repeatable entity an extra button is added to that member Clicking this button will delete the particular entity Mudguard Back lv Accessory y zx Accessory filter Accessory item v a 6 11 29 Controlclass Labelclass With the aid of those styles it s possible to change the style of the questions and answers in the e Con Front End With the style Controlclass the style of the answer can be changed the style Labelclass is needed to change the style of the question Several styles are standard available however it is also possible to add your own custom style to the e Con style sheet The name of the style has to be applied as value of the style Controlclass or Labelclass to have that particular style applies to the member In the figure above various styles are applied to several members by means of the style Category Citybike v ETTR
155. n ee ee Rc Er da 82 5 2 17 Generic Model Version Button on Generic Model Form sse 82 5 2 18 e Con Studio Button on Generic Model fOrM ccccececeeeeeeeeeeeveeeeteeeees 84 5 2 19 Configure Button only available when the version is certified 84 5 2 20 Copy Model Version button cccceccececeeseeeeeeeeeeeeeeeeeseteeaeaeeeeteegeas 84 5 2 21 Import Model Button oes veitavaadukirrekida der Pur TETUR FqUU Da Ec tones anion 84 322A SAVE aS BUON m TE 86 5 2 23 Decision Matrices ssssssssrsrsrrrrrrrnrrnrrrrnrrrenrnrrrnrrrrtrrnrnrrrrrerrrnrrernrnt 86 5 2 23 1 OVErVIEW T aDerussssuisiisisnis ni anaE Aa E a Da a Ea 87 5 2 23 2 VETSION INOG orinis a AE E aeea 88 5 2 23 3 Decision Matrix Tabisssaverertebsi rd kndsikebFirtexvi taiv bts bekres Viae On br pL DRE T 89 5 2 23 4 Version LINES T aD cassos parena a Edda WRV CA uio PIE vera n eda 90 922 2 3 9 FICTIONS B ULTON carantcerety ere teneri VERUTER EN 90 5 2 2 316 Ei WE EU UU m 92 5 2 23 7 Ng dh I II T TT nner ree rer rete 93 5 2 23 8 Link Values button Defaults sseseeennnn m 94 512 2319 Link Values button Overview sesseenn mmm 94 5 2 24 Application SETVET wanaatens canine as nii miae ante AE EBEN d 95 5 2 24 1 Sub 96 5 2 24 2 C5 98 5 2 25 Generate Todes sctesteeeudi ypatuseevsbrutr EPI rpRrEEL ERO EUM RB PPEP EUM CERE Les epeUP RR 99 oM ME doom 101 5 2 27 I
156. n of the rule select the LeftHandSide Expression function from the Expression Builder and click Copy This function is available in the category Assignment To Increase B V 39 TOINCREASE Expression Builder LettH andSide Expression o This will result in expr lt expr gt To Increase B V 40 TOINCREASE o Select ItemName from the data structure Object Explorer Objects 3A MY BIKE 1 E 13 My Bike EE Itemid Iter number Item ame ltem M ame Item Type Item type ltemGroupld Item group DimGroupld Dimension group ModelGroupld Inventory model group MODEL Model BOMYVersion BOM Version Env Environment Rules E Columns Libraries _j Interfaces E b E E E EU EU RU FEl ee ETE EET FEET UEUE o Drag and drop this member into the left lt expr gt expression code in the Implication section Implication ItemName lt expr gt o Select Model from the data structure and drag and drop it into the right expr expression code Implication 1 ItemName MODEL OTo Increase B V 41 TOINCREASE Labet Enter descriptions Condition 1 MODEL lt gt Implicatior ItemName MODEL o Before we continue the rule by entering the name of the BOM Version let s test this rule o Click Browse in toolbar E e Con Studio File Edit View Tools Help agmg
157. n will notice a change of context from quote to sales order and will create the Bill of Material and Routing To Increase B V 123 TOINCREASE O E Context Transition Context From Context Ta Description k ENG sales order Quote to Order JRERARARRREARRRARERARIRARERURESEAERASESESERERESESEREARESAEIAAAEAEAS AR ORARAR MAAA PRAAJ ES EE DET Context From The original context Context To The new context Description A description of the context transition Automatic Processing This box must be check marked if you want to recalculater your e Con model automatically during the context transition 5 2 41 Styles The Styles form can be found by going to Setup Modeler in the e Con menu and selecting the Styles option OTo Increase B V 124 TOINCREASE MS Main menu e Con 3 5 Company tst views E ka 3 amp e Con Projects Inventory management Models QE E Decision Matrices iM Reports Production Periodic Setup Metadata group m Z Option Query Human Resources e Con Languages Questionnaire Z Parameters oS Import settings Modeler Cost accounting 8ML Labels Master planning Project Cost purpose calculation Context Transition Basic Administration PlatForm e Con Generator Solution Center BS Style Style delete delete Style delete e Con styles delete delete Option copy copyfieldsonly reset sele
158. nerate models x Export L Human Resources m e Offline Questionnaire S Generate Datasource Bm 0 7 E Bimp art XML Doc cuments Projec gu sen M Ez Setup Cost accounting xi PlatForm Cost purpose calculation Basic Administration g Conf Generator Solution Center To Increase B V 102 TOINCREASE O Offline created e Con configurations XML files can be imported and processed within this menu The tab Batch is the standard Batch functionality of Axapta and enabled the possibility to attach a batch process to the XML documents processing E Select off line XML document directory ere i General Batch Current options G Frinter Mare adNHP Lasenlet 4 Directory LO Print medium E creen v Directory Directory containing the XML configuration files to be processed All files within this location will be processed and deleted from this location After processing a document will be generated with information about status created records and more Printer Selected printer Pri
159. ng Environment CAD A ah Database Database AutoDesk xapta Tamino XML DE n eem SolidWorks Navision Webservice tc Baan Possible Datasources The figure above shows the architecture of the total e Con concept The design of e Con is so flexible because of its use of XML documents with which it can be integrated regardless of ERP system or database Back End used The Back End needs to have a dedicated XML generator in order to generate model data in the XML language The Connector and Generator supply the XML generator Rules are added to the XML data model in the Studio Configuration takes place in the Front End and the result is saved as an XML document and downloaded to the Back End by means of the Generator and Connector Besides the basic functional building blocks there are also optional components One example is the Report Generator which can be used to print documents such as product specifications of configurations 2 3 1 Important Conceptual Features of e Con The concept of a configuration tool is based on the existence of a generic model and the possibility to extract a realistically configured object from that model The model itself is a collection of all the possible combinations of features and options and in addition to data it also contains rules The rules enable the user to extract the correct data in order for the model to become a realistically configured object Answers to questions provid
160. nt End or to test the model Once the Front End is saved or Cancel clicked Axapta returns to the Generic Model Card However if the Front End is started from the sales order line the system returns to the sales order line Configured Models OQ To Increase B V 66 TOINCREASE This form displays the objects that have been configured from the Front End Once the Save button is clicked in the Front End this list will be updated Generate Model Interface This function will generate an interface model Interfaces are used for sub models and needs to be created in order to interface with other models All members with the To interface field checked will be added to the interface model when the Generate Model Interface function is executed The user will be asked for the interface model id version and label 5 2 6 Configured Models EE Configured Models No BIKE 1 No BIKE Sele Overview Link Details d L EE c Model Status User ID Last Date Last E Configured Model 534 C Configured Admin 31 05 2005 22 30 31 555 Configured Admin 05 07 2005 072342 557 Configured Admin 05 07 2005 10 29 57 575 IET Configured Admin 14 07 2005 08 31 38 Con Admin 1440772005 1315 34 Admin 14 07 2005 1X51 28 lecon 05 08 2005 10 05 13 econ 05 08 2005 101927 lecon D5 08 2005 11 34 05 ECCO
161. nt medium Selected output medium Default Button Clicking this button will change the printer and print medium to the defaults Options Button With this button printer and print medium can be set up and selected 5 2 28 Metadata group The metadata groups can be found by going to the e Con listing on the Main Menu clicking Setup and then selecting Metadata group from the drop down menu that appears O To Increase B V 103 TOINCREASE Main menu e Con 3 5 Company tst General ledger uo SOICION Center n My alerts Accounts receivable Views pu EET e Con e Con Projects Models Decision Matrices Accounts payable Masher planning i pI ET TEE a 5 Reports Production Periodic Product Builder Human Resources E e Con Languages Questionnaire Parameters Project o o Modeler Cost accounting Z ML Labels Cost purpose calculation amp Model Table Link e Context Transition Styles Administration Platform e Con Generator Solution Center Metadata groups are used in the external data wizard of the e Con studio Groups and tables defined here will be shown up in the wizard and can be used in the e Con data functions B Metadata group Metadata group PRODUCT CRM Tables Ur S PRODUCT PROJECT Description T 3 BOM lines BOMT able Bille of material BUM Version B OM versions L ommission Calc C
162. o displayed in the Front End The label entered for the version is used as the filename of the XML model file that is created Entity Generic section of the data structure of the model Entities are used to indicate in which Axapta table e Con is to insert records An Entity consists of a table number and a line number Entity Type The type of Entity e Class e Object e Both Class Generic section of model Records are created for this type of Entity Object The lowest level of the model Records are retrieved from the database for this type of Entity Entity Member Member types of an Entity e Field property e Additional property e Relation Field Property This type of member is linked to a field in the Axapta table This type is used if you want to change or type data into a Axapta table field Additional Property To Increase B V 236 TOINCREASE O This type of member is not linked to any field in Axapta This type is used frequently for additional questions and variables Relation Link between two Entities This type of member is required in order to create a relationship between two Entities Additional Relation Special link between two Entities The linked Entity is not stored in Axapta when the configured object is saved Relation Type Type of relation between two Entities e Reference e Master Detail Reference A relationship of many to one n 1 For example many items can be relate
163. odel i Description L Frame 1 Wheel L JL JL JL see J Bem J Pe J tw J Note it is also possible to start the model from the e Con Model form Go there with the Setup Model button 7 8 How to Generate XML In order to view the last changes made to your model XML must be generated based on the active version e Select the model on the Generic Model form for which you want to generate the XML The active version must be Under Development Select the Model Setup button to go to the e Con Model form wc nding Date eConModeler eConModeler Modeler beraie rated M ndals OTo Increase B V 184 TOINCREASE O e Use the Certify and Generate XML buttons to certify the version and generate the XML based on the version eel a Generate XML ount e Con Modeler Contigurated Models 7 9 How to Start Up the e Con Studio With the e Con Studio you can add rules among other things to the data structure e Select the desired model on the Generic Model form bd J Cc ae MOJE aetpr Genenc Model Version F e Con Studio i Copy Model Version Save as il iding 5 e Click the e Con Studio button on the Generic Model form The e Con Studio will then be started To Increase B V 185 TOINCREASE FT c We dde Due llgaini Riad donus s NL IER TEE 1l 5 e
164. odel changes sometimes it s not Such an update is called Synchronization in e Con terms There are different ways how synchronisation can take place The section explains the different possibilities in this area A controlled synchronisation can only take place when changes are done in a controlled way via versions Changes made to a model without adding a new version are always synchronized during reconfiguration In other words changes made to the active version are always applied to an existing configuration during the reconfigure process When changes are done via a versioning procedure each change or set of changes is a new model version a certain set up of synchronization can be done This set up can primarily be done on the generic model card At the tab page XML a field online synchronization exists This field determines how the model will act when the version of the configuration differ from the active version of the model E Generic Model Ho BIKE Bike demo model Miata G Overview General Include to Object Online Recovery Online Synchronizing On Confirmation Automatically Overview Model Setup Version Description e Con Label Generic Model Version BIKE AA e Con Modeler Copy Model Version Import Save as Three possibilities exists here To Increase B V 216 TOINCREASE e Manual The configuration is only synchronized with the active version of the model when the field Syn
165. odel you must pick the relation BOM Pick relation AltltenLontig Altlbernld Batch umGroupld BOM BOMCalcT able BOMCalcT rans B CanfigRule e Right click the BOM entity and click Edit node Change the e Con Label to FRONTWHEEL and select the Editable Mandatory Visible and Constant check OTo Increase B V 161 TOINCREASE CE boxes as required E Entity Member Member Type Relation Sele Overview Field Method Relation Member Type Sequence e Lon Label P Meleti 310 FRONTWHEEL m Table Relation e On the Relation tab select the cild model and the interface model In our example these are respectively the FRONTWHEEL model and the IFRONTWHEEL model H8 Entity Member Member Type Relation Overview Field Method Relation Member Type Relation Table Relation BOM Relation Type Reference Description BOM Child Table lnvertT able Repeat Read Only Relation External Link e To generate the model in the Generic Model form click Model Setup e Inthe e Con Model form click Generate Model Tips amp Tricks Always generate the Interface Model prior to the Sub Model and Main Model When the main model is generated prior to the interface or sub model generation will fail There is also a SetI nclude function to Include Another Model with a rule See chapter 9 for more details To Increase B V 162 TOINCREASE O 6 13 How to Make Your Model Multilangua
166. odel ID Synchronize Model Status Error Instance Set UserID Last Da Last 18 No Configured No 30 Admin 1822003 163255 Lg Configaed No 88 Admin 1352003 110738 53 No Configured No j 8i Admin 135 2003 13 57 22 km E Configured 38 Admin 13 5 2003 143313 To Increase B V 225 TOINCREASE O If there is a error Yes will be in the Error column 10 2 Common Procedure for Resolving Errors In this section we will outline a procedure for addressing errors Sometimes the error message Loop detected appears or a model simply does not perform as you expected It s often difficult to determine what s causing the problem especially when you re dealing with a large or detailed model Tips amp Tricks The error message Loop detected occurs when e Con finds a loop in the rules For example The implication A A 1 will cause this error message to appear The rules engine is declarative which means that every time A is changed this rule will be executed But executing this rule causes A to be changed causing the rule to be executed causing a change in A and so on e Con detects this loop in the rules and provides the error message Loop detected There is a helpful function to understand what happens in the model Sometimes your model does not give an expected outcome or behavior With the aid of the button How and Why in the Front end you can check how a certain
167. odel is equal to Foldingbike it will be impossible to choose ALU frames To Increase B V 49 TOINCREASE e Add a new rule and enter the following in the Id and Label fields Options Frame e For the condition enter MODEL lt gt e Select the implication field Enter the sign and select the option visib le attribute from the Expression Builder at the left site of the asssignment This attribute is located in the Option Attribute category This attribute makes it possible to make an option of a certain member in visible Another possibility is to directly drag the property option including the visible attribute from the Object Exporer Object Explorer 4 Objects Se MYBIKE 1 H E 13 My Bike TEES Itemid ltem number ltem ame Item Name Item T ype Item type ltemGroupld Item group DimGroupld Dimension group ModelGroupld Inventory model group MODEL Model BOMYersion BOM Version E BOMVersion BOM Version vos EIS EISE 0 E E NE EH EE D D Hug ltemid Item number m BOMId BOM E B Hame Name FRAME Frame H E FRAME Frame Rig BOMId BOM H LineMum Line No Recld Record ID H Itemid Item number Unithd Unit BOMT ype Line type BOMOty Quantity FRAME Frame 1900 Frame man s bicycle steel l 1910 Frame lady s bicycle steel 1820 Frame man s bicycle ALL Itemid Item number Iter ame Item M ame
168. of Levels 38 Sequence Interval 20 re D Option Description Delimiter e OTo Increase B V 114 TOINCREASE O 5 2 36 3 Default Model The Entities of the model selected here are used as a template for new Entities For example when the default model has an Inventtable Entity with 5 members and the first InventTable Entity is created in a new model the whole InventTable Entity is copied from the default model If the entity already exist in the model the entity is copied within the model Filling this setup field will activate the copy function Maximum Number of Levels To limit a loop in the model you can define a maximum number of levels When Axapta generates a data structure it will stop if the number of levels in the document exceeds this value and then it will generate an error Sequence Interval The sequence of the entity members shown in the Front End can be determined and changed Based on the Sequence Interval the sequence will be numbered The sequence can be changed by filling manually the Sequence field with a number in the Entity Member form or by changing the sequence with Ctrl T or Ctrl 4 in the Model Setup Modeling tree Option Description Delimiter Options are linked to the additional properties of Entities via queries The symbol entered here is used as a separator An additional property can have multiple options For example the Color additional property has the options Red Blue an
169. of the member In the case of a field property the description entered is the description of the field chosen as the Field No If the member type is Additional Property or Relation the description can be entered for information purposes It will not be used in the XML document Property Type The Property Type has to be entered if the member type is Additional Property The following options are available Text For text fields like color Integer For numeric fields like length Decimal For prices like Special price Boolean For true false checkboxes Date For data fields Time For time fields Length Length of Property Type has to be defined only if the member type is Additional Property Choose normal values like 12 for decimal and 30 for text Child Table If the member type is Field or Additional Property When the Child Model is left blank and the child table is filled a direct relation to a table is created Using a query records can be selected from the chosen table Query ID ID of the Query used The usage of the query depends on the selected member type Field property Selection of the records chosen in the Child table Add Property A query can be made in table no 0 This means a set of options can be filled in Default Code The default option code can be specified in the Default Code field for field properties and additional properties No Series When an object is inserted in an Axapta t
170. ommission rates et Commission teniGroup Commission item group ConfigCheice Configuration selection PRODUCT details ConfigGroup Configuration groups Description Config able Configuration table Cush endE stermalltem IE s ternal item descriptions Product Configuration D ocuRef Dacument references IrvventBuyerGroup ImisanH lar OTo Increase B V 104 TOINCREASE O Product details Description Description of the metadata group Tables Table Table name being part of the metadata group Tables Description Description of the table being part of the metadata group Button Query A Start query to select multiple table at once Button Save amp Generate Bl Save and Generate the metadata XML source used by the external data wizard of the studio 5 2 29 Option Query The query form can be found by going to the e Con listing on the Main Menu clicking Setup and then selecting Option Query from the drop down menu that appears OQ To Increase B V 105 TOINCREASE Main menu e Con 3 5 Company tst General ledger Bank CRM Accounts receivable i Views Accounts payable E Ga B Inventor management E Models Master planning Decision Matrices Reports 7 Periodic Setup d Hei group El Production Product Builder F I Shop Floor Control Human Resources E Con pem Quest
171. on and something is wrong in the configuration If you again enter a configuration first the Configured Model for Recovery form appears displaying all configurations for which the following apply The status is New The Error check box is selected The user who entered the configuration is the current user The configuration s model is the current model OTo Increase B V 170 TOINCREASE O Overviews el Generic Model Version Last Da Last 213 BIKE 12 10 2004 15 05 32 214 BIKE 12 10 2004 15 55 11 215 BIKE 13 10 2004 10 24 57 216 BIKE 13 10 2004 10 41 38 eee BIKE 14 10 2004 09 43 28 zd BIKE 14 10 2004 11 40 06 226 BIKE 14 10 2004 15 21 33 BIKE 26 10 2004 10 10 09 BIKE 26 10 2004 10 53 23 BIKE ss 26 10 2004 E Configured Model for Recovery L I l ee ee Lo IL L For each displayed configuration you can decide whether you want to carry out one of the following actions e Re configure e Delete e Ignore 6 17 How to extend the Table Metadata Groups In the Table Metadata Groups the tables to be available for the rule wizard are determined The Metadata Groups are filled by default during the initialization of the e Con setup The most commonly used tables are available with the default Metadata If other tables are needed the Table Metadata Groups should be extended e Goto Table Metadata Group in the e Con setup OTo Increase B V 17
172. on find a entity with label buttons it knows that custom buttons will be available and therefore the standard buttons will not be shown Just add those buttons as properties from the new entity buttons Also add a property with the label SHOW This is a new button used later on H8 Entity Member Member Type Field Property Generic Model BIKE Version Code 1 Sele Overview Field Method Relation The description of the label is the label shown at the button The print button is in this case not added To view the label s description browse in the e Con Label field Make the properties visible when you want them to display this button Tips amp Tricks To Increase B V 207 TOINCREASE O The sequence of the properties of the member button determines the order of the buttons in the front end The property on top appears left the one at the bottom appears right Instead of checking the visible field up here it is also possible to make rules to let buttons appear In that way you can let up appear under condtions e To let e Con that those properties are buttons and not normal fields add the style button with value true to each member that has to be displayed as a button The styles can be found under the Styles button E Entity Member Style Style 0 Generic Model BIKE Version Code 1 Table Seles Style HTML description Value Description e What s left is to link this new entity to the ro
173. on menu click Setup Parameters The e Con Setup form appears e Click Edit Environment e Add the letter Q or X to the buttons field Every character here represents a button The Q represents the Post button the X represents the Post and Exit button UI Settmzs Buttons PBREG Adding rules to control the object ID The object ID is the number which the configuration and XML file becomes after the save or post action There are some special functions to control the number object id to assign to the posted configuration Furthermore two environment variable exist Env BeforePost and Env AfterPost The BeforePost becomes true just before the post action the AfterPost becomes true after the post action These environment variables allows to trigger and execute rules just before and or after the posting from a configuration e Enter a rule to retrieve an new object number This can be done with the function CallStringFunction CONNECTI ON GetObjectl d e Enter a rule to assign this Object number to the document to be saved This can be done with the function SetArg saveas OBJ ECTI D Example from the Sales Order Demo model To Increase B V 221 TOINCREASE CI aB Rule 5 Label Get Mew Object ID after post action Description eee Mew Object ID after post action Condition Enmv BeforePost Cancel Help rt Implication OBIECTID CallStringFunction CONNECTION GetoObjectiId
174. ont End Visible Checkbox for whether this member is visible in the Front End Constant Checkbox for whether this member is constant in the Front End If the member type is Relation and there only is one option the level is skipped in the Front End To Interace Checkbox for whether this member must be part of the interface Interfaces are used for sub models and needs to be created in order to interface with other models All members with the To interface field checked will be added to the interface model when the Generate Model Interface function is executed 5 2 13 Fields on Field tab EB Entity Member Member Type Field Property MYBIKE Generic Model MYBIKE Version EBE Overview Field Method Relation Member Type Field Propert 1 nitty Field Mame Itemid Description Item number Property Type T Length f Child T able Quer ID Default Code No Series bike Step Size for Auto Numbering fi Member Type There are four options Field Property link to a table field Additional Property field that does not exist in the Entity table but is used in the Front End and or in the e Con Studio Relation relation to another Entity Method name link to a table display method field Field Name OTo Increase B V 75 TOINCREASE O This is only entered if the member type is Field Property Here the field of the table is selected Description Description
175. options 2 GetMatrixzColumns CATEGORY true CONNECTION BIKE MODEL CATEGORY MODEL This rule establishes that when the end user selects a Model the various Category options associated with that Model are retrieved from the Decision Matrix Implication 1 MODEL options 2 GetMatrixRows MODEL false CONNECTION BIKE MODEL CATEGORY CATEGORY This rule established just the opposite When the end user selects a Category the associated Models are retrieved from the Decision Matrix e he GetMatrixCell function is used to get information linked to a certain cell of the decision matrix the so called additional data Below you will find an example how to use this function Implicatian 1 WEIGHT 2 GetstringMatrizCell CONNECTION BIKE Weight CATEGORY CATEGORY MODEL MODEL I In this rule the weight is retrieved from the Decision Matrix Bike Based on the chosen Category and Model the right cell is consulted For more detailed information about these functions see the document Data Functions Library Descriptions 7 11 How to optimize a model Optimization of the e Con model means that the so called Where Used field from the members is calculated Actually this means that is calculated in which rules a member is used These rule numbers are stored in the so called Where Used field of the member To Increase B V 195 TOINCREASE O
176. ot entity InventTable 1 Add a new property from the type additional relation Set up the relation between the entity InventTable 1 and InventTable 6 BE Latt Member Member Ep Relation UU POMS Generic Model AEL wersion iode 1 lable Meme Inventlable Leite bine ha 1 e m x Seu Tak end eb Hrb Tgp ELTERN ENS ami Laed idid Diog w JL EL F TEES cle Fedd Tapis E 3 Hana e Check constant and visible e Certify and generate the data structure e Check the result by configuring the model As you will see the new buttons will be shown instead of the normal buttons e The sizing of the buttons can be better The label Show Costs for instance is not shown completely The size of the buttons can be controlled with the style Cols The value of the style determines the width of the button Apply the stye cols with value 5 to the members HOWWHY EXPANDALL and ALLCOLAPSED Apply this style with value 15 to the member SHOW This will result in O To Increase B V 208 TOINCREASE O L JL JL JL Sae Restart Exit Show Costs J Print e The Last step is to add intelligence that will control what happens when a certain button is clicked Maybe you have found out in the former step that even the standard button functionality isn t working anymore e Open the e Con studio and add a new rule e The task that has to be executed by clic
177. ot exist There is na link defined for the tables in Member Relatic e Label ROUTE occurs more than once in entity Frautet e Label ROUTE occurs more than once in entity Routej e Child Entity af Member Relation Haute pr 1 ROUTE is Clear Close Read the errors and solve the problems 6 5 How to Add a Number Series to Your Data Model You can define a number series in e Con to be used for the Entity members you configure e To add a number series go to the BIKE Entity InventTable 1 EB Entity Member Member Type Field Property BIKE Generic Model BIKE Version Code EBE Overview Field Method Relation Member Type BEERA Field Mame Itemid j Description Item number Property Type No Series bike sl Step Size for Auto Numbering i e Select the Field Property BIKE on the Entity Card Go to the field labeled No Series Number Series e Use the lookup button to open the No Series form OQ To Increase B V 135 TOINCREASE O You can then select an existing Number Series from the list that appears If you designate the given Field Property as being invisible and not editable by NOT check marking these two fields it will not be shown in the Front End However when the Save button is clicked a number wil
178. owever it s mandatory to use the style zoom as well to show the pop up screen For more information see section How to add a pop up screen 6 11 23 Readonly When this style is applied to a member this member is read only That means that it s not possible to change the value When a field is read only it appears in light gray Category 6 11 24 Radio When this style is applied to a member with value true the options of the member are shown as radio buttons Type L Lady s bicycle f Man s bicycle 6 11 25 Reset This style can be used to reset a member to a certain value by starting up the e Con front end Especially useful when a certain member has to be reset by reconfiguring The value added to this style becomes the member by starting up the eCon front end 6 11 26 Customerselect This style can be used add special functionality like a calendar calculator and rich text editor to a member in e Con By applying this style an assist button is added to that member Clicking this assist button lets pop up the calendar calculator or rich text editor Apply the value calendar to the style to add the calendar the value calculator to add the calculator and editor to have the rich text editor available For more information see section How to add a Calculator Calendar or Rich Text Editor to a member 6 11 27 nitline This style is useful when for example sales lines are added with eCo
179. p the Original model unchanged then copy the model to a new version Certify this version Once this new version is selected as the active one in the Generic Model Card and the XML is generated it will be used for configuration Generation Date Date the last XML document was generated Generation Time Time the last XML document was generated 5 2 2 2 Fields of the General Tab To Increase B V 59 TOINCREASE O EB Generic Model No BIKE Bike demo model Overview General Include ta Object No m Infalag detail All Online Recovery fija wv Limit Online Synchronizing User contimation v Include to Object When Include to Object is check marked the configured object of this generic model will be stored as a separate XML file object This child object can be reconfigured independently of its parent object For example if you use the BIKE demo model to configure a Bike e Con will generate one XML object file for both generic models BIKE and FRONTWHEEL unless the Include to Object field is check marked in the FRONTWHEEL model In that case two separate XML object files are created Online Recovery To activate the Online Recovery for this particular model With Online Recovery the user has the possibility to recover erroneous configuration If the processing of a configuration fails the next time the user starts
180. r model the model is a sub model an interface is required and must be selected here To Increase B V 82 TOINCREASE O Configured Models This form displays the objects that have been configured from the Front End Once the Save button is clicked in the Front End this list will be updated z Configured Models Ho CUSTOMER 1 No CUSTOMER Overview Link Details eC 5 Model Status UserID Last Date Last Configured Model L Configured a Admin 28 10 2004 202342 Configured Admin 28 10 2004 e Con Model ID e Con will automatically create this value It is a serial number Synchronize If set to Yes before Configure the model will be synchronized during reconfiguration Model Status The status of the model new configured etc Error This field contains an error code if there s a problem with a configuration User ID User ID of the user who configured the object Last Date Modified The last processing date of the configured object Last Time Modified The last processing time of the configured object O To Increase B V 83 TOINCREASE O 5 2 18 e Con Studio Button on Generic Model form Start the e Con Studio for the active version of this Generic Model Rules can be used to add intelligence to the data structure For example if the type of the bike is a mountain bike no mudguards can be chosen After rules are added to the e Con Studio the rules are
181. r be used to consult the Axapta database during the configuration process or to process the XML document after saving The last option is only used when the Post functionality is used Post functionality allows to save and process a configured document without exiting the e Con UI Status Shows the status of the Appication Server the correct status is only displayed if you use the buttons Start Server and Stop Server to start and stop the Application Server There are 4 statuses e Stopping The Application Server is stopping After status started the status changes to stopping after clicking the button Stop Server Only when the Application Server is stopped correctly the status changed to stopped e Stopped The Application Server is not running or not correct e Starting The Application Server is starting Clicking the Start Server button will first change the status to starting After the correct start up of the server the status becomes started e Started The Application Server is running in the right way Run as This field has two options batch and client e Client The client is used as an Application Server Clicking the start button runs the current client as the e Con application server e Start up command An Axapta batch process running as a service runs as the e Con application server Stop Indicator when the Application Server must stop This field is checked after activation of the Stop Server function Last Date
182. r the e Con model The model itself consists of a structure with properties options relations and objects The structure of the model is built with Entities The key of an Entity consists of a Table Name and a Line No Tips amp Tricks When the default model is entered in the e Con setup the Label and Members Entity lines of an Entity are copied from the default model When an Entity of a table is inserted for the second time in the same model for example a Bill of Material line the Entity is no longer copied from the Default model but from the same Entity above Table Name Name of the Axapta Table You can use the lookup button to select the right table Line No Line No is present because a table can be used on multiple levels in the model This number makes the Entity unique Only numbers can be used Use no 1 for the first Entity of a certain table 2 for the second etc e Con Label Label for the Entity that is used in the XML document The code of the label will be used in the rules of the e Con Studio the description of the label will be used in the Front End OTo Increase B V 71 TOINCREASE O Type Writeable generic part of model generic item which has to be written into the database Read only lowest level of model which is linked to a table record which only has to read data from the database Action on Duplicate The action to be taken if the generation process of the Axapta Back End finds a d
183. relation to the Frame entity 13 Add the Frame relation s entity 14 Change the entity s type to Object H Entity e Con Label Table Name Lin amp Con Label Action on Duplicate Generate Key Fields i l nventT able C Frame E Abort if found Key Value An entity can be of the type Class or Object An Entity of the Class type is a generic entity which means that the linked table will be filled by e Con An Entity of the Object type is not a generic entity which means that the linked table is not filled by e Con Entities of type Object are only used to retrieve information OQ To Increase B V 26 TOINCREASE CI The result so far is as follows i Modelling tree E MYBIKE Itemid ltem ame ltemT ype ltemGroupld DimGroupld Modellroupld Model BOUMVersion BOMVersior Iteml d BOMId Mame Approved i 999099000 99 9 ApprovedB y Active amp 424 a e Frame E Frame BOMId LineMum Recld Itemid Urithd BOM T ype BOMConsump BOMOty lnventDinld Frame E Itemid 9999909040009 Now copy the Frame relation and rename the relation s copy to Wheel Also rename the Frame relation the relation to the InventTable table to Wheel To do so OTo Increase B V 27 TOINCREASE 15 Right click the Frame relation the relation to the BOM table and click Copy node i Modelling tree El
184. rerere W E NETUS COE 28 To look for the item that is created in Axapta on the Key Value form right click the key value record and click Go to the Main Table To Increase B V 31 TOINCREASE CT i E Key values eCon Model ID 240 BIKE 00002 7 eCon Model ID 240 eCon T able Mame Field Mame Key Value InventT able tend o Find Filter Sort Ascending Sort Descending Go En Ehe Main Table Hide Setup Record info What s This As a result the main table s form in Axapta appears displaying the created item In our example the item form appears E Item Item number BIKE 000077 BIKE 000027 Item number BIKE 000027 Overview General Setup References Price Discount Quantity Other Dimension Transactions Item number Item name Search name Item group Item type Un hand SSE E BIKE O00027 BIKE 000027 eCon Bike Trade agrmt Functions Inquiez k Forecasting k c I Is Route Configure 3 3 Add Your Business Rules This section describes how some business rules can be added to a model The starting position is the Bike model that is described in the previous section We will add the following business rules step by step The name of the item and the BOM Version of the bike that should be entered with the chosen model A default value for the model Some dependencies between the chosen model and the default v
185. riak SRi BEEASA Hi iiai Ay P rmx i Psi Ei PEE oj A iii 15 piis apa i arti E oW laa xil 3 Cangas Exi lt i Bari a CE hia hai g ru xm CHE Tama TERT Y E y rT d m Cad magi r J Fera e ep x ims rms dd gud F X db HEL Cg Ted rim me her bein ara 3m TC Tes 7 ba impium mcEr Ema Punt TI pig Lir mom acl 3 3 EET Ei 5 T 5 5 z CE Duet l un t D iren gl a d F E 3A 5 mig i m m meus rms IIT E CEE um on nom m m at a i ly Ea cor oe a aay iri m Pom cim el DS apil i d m COL Ku Sle her Ls Urb nce zai 8 RcmbiRomromb eC ae Pim br oncpi er mg ppp 3 098 Sa esla laci Haud TETTE 34 Aime hem m his acie bocca cani c Eoi socle roseo a d eee ipi mcer 4g Deap Dinara 36 X QD Bae ed recie mode X m Ducha Peu 3 Feblkzh Vie a d PRE Fea i ala used Ln Y g LUE 3 Lm m kwuiinkd mi 4 m SHOE bos X d EUM ELM Ferd 4 kamili i rera ii w U Fandemia om ins ii BOT bip irk Harp User bei rpg keai uu Note it is also possible to startup the e Con studio from the e Con Model form Go there with the Setup Model button Besides that the studio can also be started for a project Select e Con Projects and from there e Con studio which is available under the Project button 7 10 How to Set Up Decision Matrices This section describes the Decision Matrix functionality An overview of this functionality is given followed by instructions for setting up the mat
186. rix and an explanation of the business rules needed 7 10 1 Overview You can use Decision Matrices to indicate an interdependency between member options in your model In many cases certain options are not possible for a given Model Options in this case may mean other Options like Color or Type as well as Items It s also possible to lay out such interdependencies in the business rules However these interdependencies may change frequently and changing your business rules frequently is not ideal In addition it is often Sales Representatives Assortment Control staff or Product Control employees who need to make these changes and they are usually not authorized to alter the business rules So instead e Con makes use of easy to use Decision Matrices By check marking fields in these Matrices employees can easily make the necessary changes in interdependencies OQ To Increase B V 186 TOINCREASE CT aB among Entity members And they need only make use of a few existing business rules to consult the matrix 7 10 2 Setting up the Matrix This section covers setting up a Decision Matrix in Axapta A decision matrix consists of two or more Option sets of which the options are dependent of each other The Option sets are based on existing queries These queries can be based on Axapta tables or not Setting up a Decision Matrix MS Main menu e Con 3 5 Company tst Banal ledger Mer e e Con LA mn d i e Can P
187. rojects Accounts receivable Ey Models m E amp ecision Matrices amp gg Reports Inventory management i Periodic Master planning C Setup Accounts payable Production Product Builder shop Floor Control K i Human Resources Questionnaire Project Cost accounting Cost purpose calculation Basic Administratian e Con Generator e First select Decision Matrices in the e Con menu OTo Increase B V 187 TOINCREASE CE EB Decision Matrix Decision Matrix BIKE Description Active Version ki BIKE 1 Demo Bike MYBIKE My bike Versions Version Description Starting Date Ending Date e The Decision Matrix form for setting up the Decision Matrices and Versions appears Different Decision Matrices with version can be determined Every Decision Matrix has an Active Version The Option sets are determined as Version Lines per version E Decision Matrix Decision Matrix New Record Decision Matris Description Active Version MYBIKE My bike 1 e Add a new line on the Overview tab with CTRL N and fill a unique code for the Decision Matrix and a Description Versions Version Description Starting Date Ending Date pr
188. s causes a button to be displayed at the Front End The button s label reads New plus the label description like New Line or New Accessory Clicking on this button adds a new Entity which is visible at the Front End Designating an Entity as Repeatable is quite straightforward but there are a few important rules to keep in mind 1 An Entity is made Repeatable by putting a check mark in the Repeat field in the relevant Entity s relation on the Entity Member form 2 Only members of the type Relation can be made Repeatable it s not possible to make a member of the type Additional Property or Field Property Repeatable 3 Only relations of the type Master Detail can be made Repeatable it s not possible to make a relation of the type Reference Repeatable For example In the Bike demo model the Entity member Accessory has been designated as a Repeatable Entity To do this go to the Entity Member form for BOMVersion Entity BOMVERSION 1 and find the Entity member of type Relation that is labeled Accessory Simply check mark the Repeat column for that member and the corresponding BOM Line will be repeatable EB Entity Member Member Type Relation ACCESSORY Generic Model BIKE Version Code EBE Overview Field Method Relation Member Type FERT Relation Type Master D etail Repeat Description Child Model BIKE Child Version 1 Child Table BOM Child Line Na 12 Q
189. s in the Front End e Con is structured in this way to optimize performance When there are images in the model e Con must scan the XML structure twice once for members and once to show images The second check is only carried out if a member called IMAGES is present in the data structure This streamlines performance if there are no images The next step is to add Business Rules in the Studio to set up the images You can fully control your images with the help of Styles A few styles are specially designed for use with images these must be applied to a member You could simply add this style to the new member IMAGE but it s best to apply the styles to the related members O To Increase B V 168 TOINCREASE O For example if you want to show an image of the Bike s Front Wheel simply add the relevant styles to the member in the data structure where the Front Wheel is selected This facilitates a clear overview Before displaying images in the Front End space has to be reserved to show the images This space is called the background Use the style Style ImgSrc to set up the background Standard available is the file transparant gif This file can be used as a background For Example IMAGESQsSstyle imgsrc images transparant gif IMAGES style imgposition right This will offer a transparent background space at the right hand side of the Front End The following styles are available to control the images
190. s offered All that should be configured can be configured is a motto designed to clarify that e Con can be used for configuring products service calls time sheets prospect data and much more 2 2 Configuration Processes As described above you can configure everything with e Con Some possibilities are listed below Customers prospects suppliers items Customer specific items BOMs Bills of Materials and Routings Customer specific services Mortgage quotes and mortgage contracts Insurance policies Questionnaires for customer surveys in CRM systems Projects and project budgets Warehouse environments and optimal inbound outbound operations Sample orders for quality control General ledger accounts Service maintenance contracts To Increase B V 9 TOINCREASE O Service orders Sales contracts for products and services Service maintenance schedules Purchase orders for products and services Alternative routings in BOMs or recipes Recipes for input driven quality Any entity or business process that involves business rules Now we will describe some common processes in more detail 2 2 1 Product Configuration In the product configuration process product data is generated by using questions and answers based on a generic configuration tool model The result of a product configuration generally includes e Product data such as descriptions texts etc e Product Bill of Materials or BOM e Product Routing
191. se B V 99 TOINCREASE Main menu e Con 3 5 Company tst My alerts Views E e Con z e Con Projects Models z Decision Matrices p puso E Es Reports Production 0 Periodic amp Application Server L oenerate models sete Export 5 Human Resources amp 3 Offline Questionnaire ES Setup E Platform Masher planning Froject Cost accounting Cost purpose calculation Basic Administration e Con Generator Solution Center z Generate models Generic Model From EX Toj 1 8B Certify From Model from where XML generation must start Start of range TO To Increase B V 100 TOINCREASE CE End of range of models to be generated Certify When check marked models in range are certified before generation 5 2 26 Export Export of setup and data Export setup will export the following data Queries Styles XML labels Context Transitions Metadata groups e Con parameters Export data will export all the models These export functions are useful to export the whole e Con environment EM Main menu e Con 3 5 Company tst PIE Genera ledger Solution Center 220 My alerts Accounts receivable m uz views ccm m mE con Accounts payable E e Con Projects Inventory management 2 Mode
192. status for models without any data or if certain options are no longer available Table Name The main Entity to which this Generic Model is linked The rest of the Entities are linked refer to this Entity For example when a new generic item is created with Bom version Routing and Bills of Materials BOM the Root Entity will be the InventTable Item Once configuration is complete a new item is inserted in the Item table Root Line No The line number of the main Entity to which this Generic Model is linked The rest of the Entities are linked refer to this Entity It is possible to have a more then one entity for a table The Line No will make every entity unique Starting Date To Increase B V 62 TOINCREASE O The starting date of the period in which the version is valid Ending Date The ending date of the period in which the version is valid A version can only be used for configuration while it is valid 5 2 4 Model Setup Button on Generic Model form only available when the version is under development Opens the e Con Model form gt oneal a oan o Ere wit ee E Hera cd kaiia In this form the data structure of the model can easily be maintained It is different from the method used in chapter 4 2 Adding end maintaining entities To Increase B V 63 TOINCREASE O T able Mame In Type Ref Count Internal model entities Class Class BOMT able Class BU Version
193. stored in the XML document of the Generic Model 5 2 19 Configure Button only available when the version is certified Start the Front End for the active version of this Generic Model Use this function to view the layout of the Model in the Front End or to test the model Once the Front End is saved or Cancel clicked Axapta returns to the Generic Model Card However if the Front End is started from the sales order line the system returns to the sales order line 5 2 20 Copy Model Version button It starts the function to make a copy of the selected model version z Copy Model Version Enter new name and version Generic Model MYBIKE m Version Fill the Generic Model and Version and OK New versions for the same model can be made but also new version of other models or a whole new model can be made 5 2 21 Import Model Button With this function an export e Con model file can be imported in the Axapta database E Import data File name Ahy Documents My PrajectssM ao Model xml Duplicates EET Validation Ful File Name The file name of the e Con export model file can be selected here To Increase B V 84 TOINCREASE O Duplicates Set up how to handle with duplicates found during import Typical e Con labels and e Con queries could already exist Validation Set up how the Axapta record validation should be performed at the import of the e Con model To Increase B V 85 TOINCREASE
194. t Business Rules Now that you ve set up the Decision Matrix in Axapta you will need to add the necessary business rules These rules ensure that the options are retrieved from the Axapta database for those members that require it To set up the business rules you will use the options attribute and the following functions from the eCon Data Functions Library e GetMatrixColumns expr expr expr expr expr expr expr expr gt lt expr gt e GetMatrixRows expr lt expr gt lt expr gt lt expr gt lt expr gt lt expr gt lt expr gt lt expr gt lt expr gt e GetMatrixCell expr expr expr lt expr gt expr expr lt expr gt expr ex prz The GetMatrixRows and GetMatrixColumns functions are both used for consulting the decision matrix to retrieve options The GetMatrixCell function is used to retrieve the additional data linked to a certain cell in the decision matrix e The GetMatrixRows function is used for retrieving options that are located in a row of the matrix The variable value is then located along the x axis of the Decision Matrix e The GetMatrixColumns function is used for retrieving options that are located in a row of the matrix The variable value is then located along the y axis of the Decision Matrix Below are two examples how to use those functions OTo Increase B V 194 TOINCREASE O Implication 1 CATEGORY
195. table Additional Property A query can be made in table no 0 This means a set of options can be filled in Relation to an Object A filter can be created for an Axapta table Relation to a Class Using a filter a reference to another Entity is created Tips amp Tricks The primary key fields of an Entity have to be defined as Field Property in the Entity lines Entity members These field properties are created automatically when the Generate Key Fields function is run in the Entities form There are quite a few fields to be defined for each member on the Entity Card The chart below shows which fields are mandatory and which are optional according to member type Mandatory J Optional A Blank or automatically filled in by the system LR 97 Ha Fean 18 RR oen 1 Properyype A 9 A OQ To Increase B V 80 TOINCREASE O LEN pooo mae 1 A Weway T T eet Tt 1L mm KR K 8 fenidverson R KR 8 ewe TT ww KR meym TT Deme T A mosis DK KR Sese D KR KR 5 2 16 Entity Member Buttons H8 Entity Member Type Field Property Generic Model MYBIKE1 Version 1 Table InventTable E Sele Overview Field Methad Relation e Con Label 0 Itemid Field Sd Panay EE D Ttemlaroupld Field Property a DimGroupld Field Property ol MadelGroupld Field Property ol ItemM ame NE ca qa a iE 5 2 16 1 S
196. ter Table Name Unique ID Field No This field indicates which field from the primary key acts as the key to generation the option This field makes only sense for queries applied to table with a primary key that exists of multiple fields O To Increase B V 108 TOINCREASE O 5 2 32 Datasource tab of Query details ACCESSORIES details Properties D atasource Description Use ML Datasource Im v Generation D ate Generation Time 00 00 00 Uses XML Data Source Indicator if a XML Data Source is available from the query Configurations of Model This field has to be filled up when a Data Source has to be build from former made configurations Based on this model and the table name a data source in XML format is build up That data source is populated with the object id s and key values of the configurations of that particular model Furthermore the data of the fields added in the option query lines are added as well Generation Date Last generation date of the data source Generation Time Last generation time of the data source 5 2 33 Description tab of Query details ACCESSORIES details Properties Datasource Description Description To Increase B V 109 TOINCREASE O Description of the query 5 2 34 Option Query Line Tab FRAME Lines Field name Option e Con Label E c8 E WD IternN ame Field Name Name op the field out of the table the query is based on were a filter
197. th the active version of the model The field Synchronize does not play any role in this case OTo Increase B V 217 TOINCREASE O e Automatically When e Con detects a difference between the configuration version and active version of the model synchronization takes automatically place without any user interaction The field Synchronize does not play any role in this case 7 21 How to add e Mail functionality to my model It s possible to set up e mail functionality in your model that allows you to send the configuration as an attached document to a certain e mail address From To Subject and Body can be part of the message In this section is described how to set up such functionality In this example three properties are added to allow the user to enter the To the address of the e mail Subject subject of the e mail and Body the actual message The From from who s the e mail will be part of the settings An extra setting will be added here Finally a rule is added to add the e mail task to a button e First add three properties to your model which represents the From Subject and To fields required to send an e mail H8 Entity Member Member Type Additional Property SUBJECT Generic Model BIKE Versi PE EJ Overview Field Method Relation Member Type Sequence e Lon Label a Sdditional Property SUBJECT Additional Property TO Additional Praperty FRUM Field Proper
198. the Bike A rule is available in the bike to generate text as specifications from the configured bike Since the type of rim is part of these specifications as well information of the rim should be available in the bike model Two properties exists in the interface model for the front wheel e Category e Rim To set up such a interface model the next steps must be performed e Open the submodel and check the field To interface for every property that must be part of the interface In the example for both properties Category and Rim this field is checked H8 Entity Member Type Additional Property CATEGORY Overview Field Method Relation LE ab eil L LU e Execute the function Generate model interface To Increase B V 159 TOINCREASE BEL 1 Internal model entities Table Lin amp Con Label Type Ae gt BOM 6 BOM Writeable BOM 7 BOM writeable BOM 8 BOM writeable BOM 3 BOM writeable BOM 10 BOM writeable BDMVersion 4 BOMVersion Wiiteable InventT able 1 FRONTWHEEL writeable InventTable j InventTable H ead only e The system asks for name description and label for the interface model that will be created after clicking OK A new interface model is added in the Generic Model list The interface model is added to the Frontwheel sub model e Check if the interface is added by selecting Model Interface
199. the data structure and therefore in the Front End can be changed O To Increase B V 65 TOINCREASE O 5 2 5 e Con Model form Buttons Certify Clean up Generate Model e Lon Studio Configure Configured Models Generate model interface Certify The data structure is certified The status of the version becomes certified Clean Up The model is checked for unused entities These entities are available in the model entities but not used in the tree After the check e Con is asking for a confirmation to delete the unused entities from the model Generate XML Before the Generic Model can be used in the Front End and in the e Con Studio the XML document and Net assembly dll has to be created The XML document consists of the data structure and rules that are created in the e Con Studio The data structure is generated This can be done with the Generate XML function When this function is selected both the XML document and Net assembly dll are created e Con Studio Start the e Con Studio for the active version of this Generic Model Rules can be used to add intelligence to the data structure For example if the type of the bike is a mountain bike no mudguards can be chosen After rules are added to the e Con Studio the rules are stored in the XML document of the Generic Model Configure Start the Front End for the active version of this Generic Model Use this function to view the layout of the Model in the Fro
200. the e Con model the user is asked if he want to reopen the erroneous configuration After reopening the configuration a reprocess can take place Online Synchronizing The online synchronizing field has to do with the reconfiguration of an already configured object When you reconfigure an object it will be synchronized with the active version of the base model There are three ways of synchronizing e Manual When the flag Synchronize of the configuration is check marked the configuration will be synchronized e On Confirmation You will be asked if go e m you want to synchronize no matter if the flag synchronize is check marked e Automatically The object is always synchronized no matter if the flag synchronize is check marked D Tha vansin oF thi obWet diffens from the current siniion df thanh tis di Do yau mani ko upr ade Hie object to He nem verdn To Increase B V 60 TOINCREASE O For example On 23 03 01 a customer orders a series of 100 customer specific With the help of e Con a customer specific Item with its customer specific Bill of Material and Routing will be generated On the 12 of April the same year the customer again orders a series of 100 bicycles which are identical to the series ordered a few weeks before except for the color This time the customer wants a special color So a search for the item which had been generated a few weeks ago is done and based on this item a
201. tokkle the value of the Boolean field Subject 7 17 How to add a Calendar Calculator or Rich Text editor to a member To easily select a date for a field in the e Con front end it s possible to add a calendar to that field With the aid of the calendar a date can be selected that will taken over in the field itself It s also possible to add a calculator to a certain field With the aid of the calculator a certain value can be calculated That value will be taken over in the field in the e Con front end when you leave the calculator and return to the e Con front end Further more a rich text editor can also be added to a member In the rich text editor text can be added A lot of text editor functions as bold italic and underlined fonts bullets and numbers etc is offered in that editor By posting this text the editor will be left and the text is taken over in the member In this section is described how this functionality can be added to an e Con model First select the member in the data structure used to be shown the calendar or calculator Now a style has to be added This can be done in a business rule or in the data structure The latter is described hereunder Select styles in the member menu Fill in the style customselect with the value o calendar for adding a calendar o calculator for adding a calculator o editor for adding a rich text editor Leave the screens and go to the
202. ts of an item itself a BOM version and lines The BOM consists of two lines one line for the frame and one for the wheels e First import the demo bike model because it will add the necessary items to the database See chapter 6 5 or Installation manual Let s get started 1 The first step is to create a model e Select Models from the e Con main menu The Generic Models are shown e nsert a new line with Ctrl N e Enter a No and description ES Generic Model No MYBIKE My Bike Overview General 2 Create a version e Go to the lines underneath the models and insert a new line with Ctrl N e Enter a version number e g 1 and a description Add a label This label will be the name of the XML file once the data structure is generated If the label doesn t already exist create a new one Click the lookup button in the Label field The Labels form will appear Insert a new record and enter the label ID and description If the label also exists as Axapta label the field Axapta label will be check marked automatically Select the label and Past selected label Notice that New is displayed in the Status field of this version Then enter the Root Entity This tells e Con which Entity table record to insert first of the data structure This is in fact the top level of the data structure in this case Entity InventTable Root To Increase B V 18 TOINCREASE CE Line No will be automatically inserted
203. tton will tokkle the value 6 12 How to Include Another Data Structure You can include or link to another model or data structure using e Con the so called sub models To do so a number of steps are required e Create an interface model e Select the interface model for the to included sub model e Set up the link to the sub model in the data structure of the main model 6 12 1 Set up of an interface model An interface model is needed for each sub model The interface model is as it is in the name the interface or connector between a sub model and the main model main model is the model including the sub model All properties from the sub model used in the main model must be part of the interface model As an example the Bike demo model In the bike demo model a sub model is available for the front wheel In this front wheel the default type for the rim depends on the Category of the bike Since the category is chosen in the main model Bike this information should passed down to the sub model front wheel Here fore a property Category is added to the front wheel model and a rule is added in the bike model to pass the Category to the front wheel model To Increase B V 158 TOINCREASE O Label ie data to Front Wheel Sub Model Condition B Implication PRODUCTION FRONTWHEEL FRONTWHEEL CATEGORY CATEGORY Besides that category must be part of the interface model as well The type of the Rim of the front wheel is used in
204. ty ternl d Bis oe e Add anew button Send See section 7 17 for more details about adding custom buttons e Certify the model and Generate the Data structure e Open the e Con Studio e Add anew rule Mail In this rule the task for sending an e mail is assigned to the custom mail button The task to be used Is task eCon Ul Tasks EmailTask This task can have a maximum from four additional expressions To Subject Body and From When one or more from these expressions are missing e Con expect them in the e Con settings and will retrieve them from there In our example only the From is retrieved from the settings Therefore the second expression is empty To Increase B V 218 TOINCREASE O Id Mail Label tail Condition true Implicatian 1 MAIL MAIL default 2 task eCon UI Tasks EmailTask SMAIL TO SMAIL SUBJECT SMAIL BODY SMAIL FROM Notice that the members used in this string have a as prefix It s an indication for e Con that the part of string following on is a member of the model e Since From is retrieve from the settings it must be added to the settings of this environment Select Options from the toolbar f e Con Studio Fie Edt View Tools Help LO GI8 ES i 6 5a X 148 55 BEER on eS esa E BE amp esuE 8X BKET ES m cag BIKE ld Mail Object Explorer 2 28 Objects e Select the Administration
205. tyles Here the style of an Entity member can be filled in This style influences the behavior of the entity member in the Front End To Increase B V 81 TOINCREASE O EB Entity Member Style Style 0 Generic Model MYBIKE Version E E X Style HTML description Value Description selecthirst selectfirst 5 2 16 2 Entity When the selected Entity Member is of Member Type Relation the related Entity form can be opened 5 2 16 3 Table Relation z Entity Member Link Generic Model MYBIKE Version Code 1 Table M di E Table Mame zl Foreign Kep Field Child T able Primary Key Field AHE UM version B MId l ME RERRARRRRSAASAAE Normally it is not necessary to tell the data structure what fields must be equal to have a valid relation between to table records When the model version is certified this is checked If it is needed to fill the related fields manually is will be told during certifying of the model version Then it is necessary to fill this form Add a line with CTRL N and select the appropriate fields 5 2 17 Generic Model Version Button on Generic Model Form Model Setup d Generic Model Version k Entities Can Stud Model Interface ns Configured Models Configure Entities Displays the entities from the selected model See section 5 2 23 Model Interface Shows the interface for the current model Only if the model is referenced from anothe
206. ubleshooting cucraraceut tertio teoneidatn Nes derchabuda t dub abu ads C ia MravbETUtORU Dea PE 225 10 1 How to Solve Errors in the Data structure after configuration 225 To Increase B V 6 TOINCREASE O 10 2 Common Procedure for Resolving Errors ceccceecececeteeseeeeeaeeueeteteteeeratanees 226 10 3 List with most common syntax errors ssesssseeenn mmn 233 10 4 List with most common Net compile errors esnn 234 Sac I GOSS ANY DP 236 OTo Increase B V TOINCREASE O Chapter 1 Getting Started In this chapter you will find an introduction to e Con Read this section to get a quick overview of the product and the manual 1 1 Introduction We all know that today s business processes are dynamic The market is changing constantly as are the needs of customers If your company s business processes are flexibly organized you can adjust them at a moment s notice and stay ahead of the competition e Con makes this possible e Con is a powerful tool which allows you to record and manage all dynamic information relevant to your organization Companies are increasingly using the Internet to offer their customers personalized service Order fulfillment e Business e Commerce and e Collaboration business models require integration of new Internet technologies with your current business processes All of this is possible if your business software is web based e Con functions as a web b
207. uery ID Read Only Relation In short the only step required for making an Entity into a Repeatable Entity check mark the Repeat field for the relevant Entity member 6 14 2 How to Set Up Arrays In the above section we describe how Entities can be made into Repeatable Entities Doing so will cause the Entity to be expanded with an index that is 1 for the first repeated Entity 2 for the second 3 for the third and so on If we didn t have arrays and you wanted to add a rule to a Repeatable Entity then you would have to repeat this rule over and over again For example if you wanted to assign a default value to a member of a Repeatable Entity the rule would look like this REPEAT 1 DEFAULT defaultvalue O To Increase B V 165 TOINCREASE O The rule would result in the member DEFAULT of the first Repeatable Entity REPEAT has a default value of defaultvalue But this rule would only apply to the first of the many repeated Entities In order to carry this rule through and assign the desired default value to all the repeated Entities you would have to add many more rules REPEAT 2 DEFAULT defaultvalue REPEAT 3 DEFAULT defaultvalue REPEAT 4 DEFAULT defaultvalue REPEATT DEFAULT defaultvalue As you can see this is not the best way to go about making rules But arrays make this sort of repetitive rule making unnecessary Instead you can define an array for a Repeatable
208. uplicate Key Value when inserting the record into Axapta A duplicate Key Value can only occur if the Key Value s are specified in the e Con Front End and no No Series are used in the Entity members The following actions are available Stop Process This is the default value If there is a duplicate value the process is stopped and Axapta generates an error message Use Database Record The generation process will use the record found in the database any data entered in the e Con Front End is ignored for this Entity Modify Database Record The record is used and the data entered in the Front End is used to modify the record If the Key Value of the Root Entity is entered in the e Con Front End or generated by the rules and a No Series is used then both values Front End value and No Series value are combined into one single value 5 2 10 Entity form Buttons EEk Entity Members Generate Kev Fields Key Value Copy Entity Entity Members Opens the Entity Member form The members corresponding with the Entity can be entered in this form See the section on Entity Member form Generate Key Fields OTo Increase B V 72 TOINCREASE O The Generate Key Fields function must be used once an Entity has been entered It will generate the key fields as the first members of the entity which are necessary Key Value H8 Entity Key Value Key Value 1000 Generic Model MYBIKE Version NER ey
209. x is available in XML as well Generation Data Date of generation of the XML file of the decision matrix Only filled up when the decision matrix is available in XML format Generation Time Date of generation from XML file from the decision matrix Only filled up when the decision matrix is available in XML format Button Generate Datasource This function is used to export the selected decision matrix to a XML file The XML file generated is stored in the folder Datasources in the eCon data folder O To Increase B V 89 TOINCREASE 5 2 23 4 Version Lines Tab E Decision Matrix Decision Matrix BIKE 1 Decision Matrix BIKE PEE j i mM E e del RL HP Overview Decision Matrix Version Lines e Con Labe Mame af table Query ID Fass ABE MODEL BIKEMDDEL Decision Matris Link Check Options In the version lines the queries used in the decision matrix are determined per version e Con Label Label of the version line option set Name of table Table linked to the query that will deliver the option set Empty if the query is not based on an Axapta table Query ID Select the query that will deliver the options 5 2 23 5 Functions Button Seis Generate Options Decision Matris Option Decision Matrix Link Check Options Generate Options Generates the options for the version line based on the Query linked to the version line Decision Matrix Option
210. xapta batch process running as a service runs as the e Con application server Custom Reader Class When custom classes are executed with the e Con Data Function CallFunction the class containing these custom class definitions must be specified here Read more about this in the SDK Axapta integration Stop Indicator when the Application Server must stop This field is checked after activation of the Stop Server function Status OQ To Increase B V 98 TOINCREASE O Shows the status of the Appication Server the correct status is only displayed if you use the buttons Start Server and Stop Server to start and stop the Application Server Last Date modified The last date of stopping or starting the application server Last Time modified The last time of stopping or starting the application server Trace With this setting the trace functionality can be activated Activating trace will log all communication between e Con and Axapta All the XML messages send via the message queues are logged and stored in the folder as indicated in the field Directory Directory Location where the trace function stores the trace files Long Queries A special function for performance analyses All queries with a duration longer then specified in this field are gathered 5 2 25 Generate models Batch generate of models Useful to update the XML files of the models with for example latest item and price information OQ To Increa

Download Pdf Manuals

Related Search

Related Contents

ハウス内を4段変温管理しながら、 ハウス内のモヤ・霧・温度ムラを予防し  USER MANUAL - Impact Soundworks  Sterling Allen-Bradley 060 User's Manual  Siemens M200D User's Manual  Transcend TS8XDVDS-K  Adaptador Inalámbrico USB Manual de Usuario  Mitel SIP-Telefon 6869i  

Copyright © All rights reserved. Failed to retrieve file