TUTORIAL ENABLE MODIFIED AND CREATE IN TABLE AXAPTA

TUTORIAL ENABLE MODIFIED AND CREATE

IN TABLE AXAPTA

Trainee: Song Thanh Nghia

My leader ask me create a document that help people dont know code can do it.

1. Step 1:

Path: AOT\Data Directory\Table

In 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 change in table

 

Right click and Restore table 

3. Step 3: 

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

Open  form content data of table. ( In 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 table name in properties. Then click fields, 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.

In finish, open form and see it.