TUTORIALS ENABLE MODIFYING AND CREATING TABLE AXAPTA 4.0

TUTORIALS ENABLE MODIFYING AND CREATING TABLE AXAPTA 4.0

Trainee: Song Thanh Nghia

My leader asks me to create a document that helps people who don't know code can do it.

1. Step 1:

Path: AOT\Data Directory\Table

In the table, Axapta right click add choose properties, look at  fields ModifiedDate, ModifiedTime, ModifiedBy, and CreateDate, CreateTime, CreateBy.

2. Step 2:

Set value to Yes. 

(Right-click table)

Then, right-click and save the change in the table

 

Right-click and Restore the table 

3. Step 3: 

Path: Main menu/ Stock Manager/ Journal/ Item transaction/ Movement

Open form content data of the table. (For example, I choose a form Movement content data of table: InventJournalTrans

Click Movement you can see a form 

Right click form and click Setup you can see User Setup Form

In User setup form click tag information  and click edit  form table setup open will be open

4. Step 4

Right-click in form, and Restore form 

Click node  Data Sources and select table in datasource( the last table user edit in step 1), you can see the table name in properties. Then click fields, and you can see ModifiedDate, ModifiedBy, CreatedDate, CreateBy.

Right click table in node DataSource and choose open in new window (*)

Click node design and choose exactly tab, grid you want add fieds. You can see grid or tag in User Setup/Layout

Click data table Open In new Window(13) and choose all fields you need to view in design and pull down it in grid design(14)

Axapta will add it in design

Finally, right-click form in Axapta and Save, Compile, Restore.

To finish, open the form and see it.