AX 2012 Development Training

1. AX 2012 Development Training Presented by VishyGrandhi

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. 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