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.


Previous Post
Next Post

post written by: