Welcome to my blog

To enlarge pictures click on picture

Thursday, November 24, 2011

To add Item Name in inventory journal for Newbie

Most of the implementation some users has a request about showing item name in inventory journal. This article will guide how to show item name in the simple way without much coding and use drag and drop technique also no need to X++ license only morph X and eligible user to access AOT (ex: administrator Group). Exactly DAX (dynamics AX) has provide ‘Method’ to show item name in the table for inventory the table is ‘InventJournalTrans’, so we just need to call this method at form or report.

The following picture describe the inventory journal at DAX (look at red line/rectangle)

Now you can try to open one of inventory journals (ex: Movement) click the lines button and you will see there is no item name there also in ‘general’ tab and ‘dimension’ tab.


Now you can move to design form through ‘lines’ form active by right click at lines form area and choose ‘setup’>tab ‘information’>button ‘edit’ at ‘form name’ row (see the red line arrow) or you can open manually from AOT by find form ‘inventjournalmovement’

Open another AOT and find out ‘InventJournalTrans’ table and ‘itemname’ method and then drag to form ‘inventjournalmovement’ after that you need to define the properties of ‘datasource’ from itemname with ‘InventJournalTrans’. Why we choose method from ‘InventJournalTrans’ table ? because datasource used in ‘inventjournalmovement’ form is ‘InventJournalTrans’ table. Now we need to arrange itemname to be placed after itemid you just drag itemname to below of itemid and don’t forget to save also compile the form ‘inventjournalmovement’.





Now we want to proof or to see the result of ‘inventjournalmovement’ customization, open movement journal>click lies button> and then you can see the name of item was appeared in the form.


You can do this to other inventory journals except journal tag counting which is different table name (InventJournalTrans_Tag).

GoodLuck

1 comment:

Anonymous said...

thank you very much