Adding The Item Name to the order lines Report

(0) Share

Report

Posted on by On-Hand Inventory I...

120

Dear Sir

I Would Like to add Item Name to the order lines Report ( report name is SalesLinesExtended) that is present in AX 2012 in the model Sales and marketing under Reports - > Transactions -> Sales orders -> order Lines

I have add ItemName to the table SalesLinesExtendedTmp I Move ItemName from Extended Data Type to the SalesLinesExtendedTmp .

I have added the following statement in the Class

salesLinesExtededDP -> ClassDeclaration

EcoResProduct _ecoResProduct;

EcoResProductTranslation _ecoResProductTranslation;

InventSum _inventSum;

And I have insert those lines in to the Class InserIntoTmpTable

select * from inventTable

where inventTable.ItemId == _inventSum.ItemId;

select * from _ecoResProduct

where _ecoResProduct.RecId == inventTable.product;

select * from _ecoResProductTranslation

where _ecoResProductTranslation.Product == _ecoResProduct.RecId;

salesLinesExtendedTmp.ItemName = _ecoResProductTranslation.Name;

but when I run the report I am not getting the Name of the Item I am getting blank

any help will be appreciated

Waiting for your valuable replay

Best Regards

Jamil

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Ajit 8,755 on at

Like (0)

Report

Issue here is, _inventSum.ItemId must be blank as you are not selecting that table.

You should use just below line of code -

salesLinesExtendedTmp.ItemName = inventTable::find(salesLine.ItemId).itemName();

Was this reply helpful? Yes No
On-Hand Inventory I... 120 on at

Like (0)

Report

Hi Ajit

Thank you very much for your help but I can not Understand this inventTable::find(salesLine.ItemId).itemName(); can you please explain this line because I am new to AX 2012 and is the itemName() is Function , and where can I fined the content of this function itemName()

Thank you very much for your help

waiting for your valuable answer

Best regards

Jamiil

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Jamil Alshaibani, Directly you can pass item name value to your temporary field.

like: salesLinesExtendedTmp.ItemName = salesline.name;

this will get item id from sales line and this field you can use on report.

Hope it will work for you because in many cases it is working.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Jamil,

According to the line of code it is explaining that you are retrieving item name from inventtable where it will take the reference from salesline.itemid. If it will find salesline.itemid then it will pass the reference to itemname method of inventtable.

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

Hi Jamil,

ItemName() is a method and you can find in table 'InventTable' (AOT -> Data Dictionary -> Tables -> InventTable).

Let me know if you don't find that.

Was this reply helpful? Yes No

Community site session details

Adding The Item Name to the order lines Report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Adding The Item Name to the order lines Report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates