Microsoft Dynamics AX (Archived)

How to display Product number on Transfer orders, Movement journal lines forms? AX 2012 R2

(0) Share

Report

Posted on by Rana Anees

1,813

Hii,

I have a requirement to show product number column on Transfer orders, Movement journal lines and some other forms.

Item id is already there but need to show Product number as well. I added the DisplayProductNumber field from EcoResProduct table not showing info.

Please guide how we can achieve it so we can show Product number where ever item id is being displayed.

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You may have missed correct joins between InventTable and EcoResProduct

would you like to elaborate your current solution, so we can see where its going wrong.

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report
Copy link

Link copied!

Hii Shoaib,

Please see the following Transfer orders form. Here we want to show Product no.

On personalize, cant see Product number in any table. Please guide. Thanks

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately none of the datasources behind this form, has got product id.

you would have to do any of following approach. (customization)

1) add new datasource by joins

or

2) write display method on InventTransferLine

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report
Copy link

Link copied!

Thanks Shoaib,

Can you please elaborate what should I write in display method on InventTransferLine table to get product id.

Thanks,

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Please use display method, as following.

//BP deviation documented public display EcoResProductDisplayProductNumber productNumber() { ; return EcoResProduct::find(InventTable::find(this.ItemId).Product).DisplayProductNumber; }

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report
Copy link

Link copied!

Thanks Shoaib,

I achieved the requirement. One more thing, how to make productNumber column search able.

Thanks,

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

to make it searchable you have to change the way the solution is deigned. you need to add InventTable and EcoResProduct as datasources in your form.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

To get the productnumber(searchable) on the lookup, add the table EcoResProduct as the datasource to the form InventItemIdLookupSimple and set the properties as shown below.

Was this reply helpful? Yes No