when learning the Microsoft Dynamics Ax you will face some difficulty in learning, the basic doubts arise in mind are where to start....??????
to avoid this confusion in your mind follow simple steps mentioned bellow
if you have basic idea about the SQL Database it will be a grate advantage for you in learning the AX.
the data will be stored in the SQL database for AX. so as a developer you need to work with this data every time. so my suggestion is to start with basic data storage.
1. First thing you need to work with tables. tables are basic storage for data base.
every data in the ax will be stored in these tables. there are so many tables in the AX database. you can't able to remember them all, you know about them through out learning.
2. create a Table in the AOT, and insert some data into it.
3. After inserting data into the table you need work with the table properties like Relations and DeleteActions.
4. Relations and DeleteActions are very important in the maintaining data base consistency as well as to manipulate data.
5. The Relations will give the relation between the tables. Basically in learning stage you get a doubt what is relation??????
6. Basically the data in the AX is related to the Customers, Vendors, Purchase Table, SalesTable Ware house, etc.......
7. we cannot store all the data in a single table. it will be difficult and we cannot maintain data consistency. So the data related to the Customers will be stored in the customers table(CustTable), and the sales done by the customers will be stored in the SalesTable. So there should be a relation between Customer and his Sales Order in order maintain this relation Relations are used in AX.
8. The Next task is DeleteActions, these are used for the maintaining the delete procedure.
Further details about the relations and delete actions will be in next post.
9. After learning the tables and relations you need to work with the job creation.
10. Create a job and write a simple code to get the values stored in the table.
to avoid this confusion in your mind follow simple steps mentioned bellow
if you have basic idea about the SQL Database it will be a grate advantage for you in learning the AX.
the data will be stored in the SQL database for AX. so as a developer you need to work with this data every time. so my suggestion is to start with basic data storage.
1. First thing you need to work with tables. tables are basic storage for data base.
every data in the ax will be stored in these tables. there are so many tables in the AX database. you can't able to remember them all, you know about them through out learning.
2. create a Table in the AOT, and insert some data into it.
3. After inserting data into the table you need work with the table properties like Relations and DeleteActions.
4. Relations and DeleteActions are very important in the maintaining data base consistency as well as to manipulate data.
5. The Relations will give the relation between the tables. Basically in learning stage you get a doubt what is relation??????
6. Basically the data in the AX is related to the Customers, Vendors, Purchase Table, SalesTable Ware house, etc.......
7. we cannot store all the data in a single table. it will be difficult and we cannot maintain data consistency. So the data related to the Customers will be stored in the customers table(CustTable), and the sales done by the customers will be stored in the SalesTable. So there should be a relation between Customer and his Sales Order in order maintain this relation Relations are used in AX.
8. The Next task is DeleteActions, these are used for the maintaining the delete procedure.
Further details about the relations and delete actions will be in next post.
9. After learning the tables and relations you need to work with the job creation.
10. Create a job and write a simple code to get the values stored in the table.