kat
Uploaded by
19 SLIDES
272 VUES
190LIKES

AX 2012 Development Training Overview

DESCRIPTION

Learn about Data Dictionary elements, tables, and demos in AX 2012 development training. Create new tables, manage data, understand shortcuts, and explore EDTs.

1 / 19

Télécharger la présentation

AX 2012 Development Training Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. AX 2012 Development Training Presented by Vishy Grandhi

  2. Training Outline • Lesson 1: Data dictionary elements • Lesson 2: Tables • Lesson 3: Demo • Create a new table with all the elements • Manage the data in the form

  3. Data Dictionary: Objectives • At the end of this lesson you will have an understanding about • What is Data dictionary • Elements/Objects • Common shortcuts • EDTs in detail

  4. Data Dictionary: What is it? • Data Dictionary • The root node where all the core database objects are stored

  5. Data Dictionary: Elements/Objects • Elements/Objects • Tables • Maps • Views • EDTs, Base Enums • Configuration Keys • License keys • Security Keys • Table Collections

  6. Data Dictionary: Common Shortcuts • Ctrl + 0 – Opens a form, table etc. • Ctrl + D – New AOT window • Alt + Enter – Properties • Ctrl + Shift + S – Save all modified objects • Ctrl + Shift + I – Launch the import project window • F7 – Compile

  7. Data Dictionary: EDTs • Extended data types are basically new fields created based on existing primitive types • Following is a list of primitive types • String, Integer, Real, Int64, Boolean • Date, Time, UTCDateTime • Enum • Container • GUID

  8. Data Dictionary: Wrap-up • We have understood what is Data dictionary • We discussed the elements under this node • We also looked at some of the commonly used short cuts

  9. Tables: Objectives • At the end of this lesson you will have an understanding about • What are tables • What are the different elements of tables • Some core tables

  10. Tables: Overview • Similar in nature to SQL tables with some differences • Tables can have methods • We can define relations, indexes

  11. Tables: Elements • Following are the important elements of tables • Fields • Field Groups • Indexes • Full-text indexes • Relations • Methods • Delete Actions

  12. Tables: Some important tables • CustTable • VendTable • HcmWorker • LedgerTable • InventTable • PurchTable • SalesTable

  13. Tables: Wrap-up • We looked at the different elements of tables and what are some of their nuances • What are some of the important properties of a table • Also we looked at some of the core tables

  14. Demo • Create 2 new tables and link them up • Create a form to edit the data in these tables

  15. Assignment • Create any one of the following tables • Create a form to edit the data in the table that you created.

  16. Recipes: List of recipes • The following recipes are included in this presentation 2a. Create a new table 2b. Create and set a primary key on your table

  17. Recipe 2a: Create a new table • Start • We are going to create a table called SpeciesTablewith 3 fields SpeciesId, Name, Description • Open Microsoft Dynamics AX client • Open Microsoft Dynamics AX development workspace (Ctrl + Shift + W) • The fields of a table are usually based on EDTs, so we need to create the 3 EDTs (or at least locate the EDTs that we can use) • Columns that are based on EDTs will inherit the EDTs label and the table could inherit EDTs relation • Right-click on AOT->Data Dictionary->Extended Data Types and select New->Sring • Rename the EDT to SpeciesIdand set the Caption property to Species Id • We will reuse existing EDTs for Name and Description • Right-Click on AOT->Data Dictionary->Tables and select New Table menu • Rename your table SpeciesTable • Set the Label property to Species • Right-click the SpeciesTablenode and select Open New Window • Drag the 3 EDTs one by one to the Fields node under the table SpeciesTable • Drag all the 3 fields to the node SpeciesTable->Field Groups->AutoReport • The idea is that every field should belong to at least one field group • Finish

  18. Recipe 2b: Create and set a primary key on your table • Start • We are going to set the field SpeciesId as a primary key on our table SpeciesTable • Open Microsoft Dynamics AX client • Open Microsoft Dynamics AX development workspace (Ctrl + Shift + W) • Right-click on the node SpeciesTable->Indexes and select New Index • Rename the Index to SpeciesIdx • Drag the field SpeciesId on top of the Index SpeciesIdx • Select the node SpeciesIdxand set the propertyAllowDuplicatesto No and AlternateKeyto Yes and save your changes • We now need to set this Index as the primary key on the table, so select the table SpeciesTable • Set the property PrimaryIndexto SpeciesIdx • Finish

  19. Summary of Training • We have looked at the Data dictionary • We explored the elements of a table • Finally a demo on creating tables and managing the data

More Related