Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / adding new field in in...
Microsoft Dynamics AX (Archived)

adding new field in invent Value Report.

(0) ShareShare
ReportReport
Posted on by munsif 1,534

hi expert, i have small question, i want to add new field (item name) in invent value report, for this i do following customization 

1 . add new field with name ItemName in InventValueReportTmpLine table .

2. also reference it in InventValueReportDP  class in method getInventValueReportTmpLine. i.e

str ItemName;

also note that in this method there is macro used.

#LOCALMACRO.GroupByFields
TransactionId,
ResourceType,
ResourceGroupId,
ResourceId,

........................

#ENDMACRO

insert_recordset inventValueReportTmpLineTmp
(
#GroupByFields,itemName,

.........

}

select  #GroupByFields,itemName,

.....

then after it also it reference it in InventValueReportPopulateItem method findReportLine

tmpReportLine.ItemName          =_inventTable.itemName();

}

i also refresh inventvalueTmpLine Query, all related classes, restart AOS & SSRS service, but data are not fetching in newly created field,

please guide me.

Regards.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: adding new field in invent Value Report.

    You have to write a select statement to join the Item No.

  • Ismail Mohamed Profile Picture
    Ismail Mohamed 570 on at
    RE: adding new field in invent Value Report.

    Any update ?

  • Rahul Saklani Profile Picture
    Rahul Saklani 190 on at
    RE: adding new field in invent Value Report.

    HI All,

    Anyone have a solution for this because , i am also looking for the same issue.

    I added the value even in Insert method of the table but no luck .

    Please help 

  • munsif Profile Picture
    munsif 1,534 on at
    RE: adding new field in invent Value Report.

    thanks boss, yes i debugged that line of code, i.e tmpreportline.Itemname=_inventTable.itemname();

    also step ItemName method, but data still not populating!

    how strange that is !

  • munsif Profile Picture
    munsif 1,534 on at
    RE: adding new field in invent Value Report.

    if you have time, so i can give you team viewer for better understanding.

  • Iulian Cordobin Profile Picture
    Iulian Cordobin 8,201 on at
    RE: adding new field in invent Value Report.

    So, to resume, we know the problem is the fact that the ItemName is not inserted into your table by the code added in InventValueReportPopulateItem / method findReportLine.

    I was asking if debugging gets you to that line of code and if are you able to step in the ItemName method and see that it actually retrieves the value.

  • munsif Profile Picture
    munsif 1,534 on at
    RE: adding new field in invent Value Report.

    one thing more, that i  added the code in reportfindMethod of InventValueReportPopulateItem class.

  • munsif Profile Picture
    munsif 1,534 on at
    RE: adding new field in invent Value Report.

    yes i just did so? but not any result!

  • Iulian Cordobin Profile Picture
    Iulian Cordobin 8,201 on at
    RE: adding new field in invent Value Report.

    You're welcome ... hope eventually the issue will be resolved.

    Right, so you mentioned you've debugged the code: this means that you hit your code in the InventValueReportPopulateItem class where you've added the itemName = _inventTable.itemName()? I am asking this because of course I have not tried to debug it and making sure the class you've changed is the proper place.

  • munsif Profile Picture
    munsif 1,534 on at
    RE: adding new field in invent Value Report.

    this is the main point, boss the data is not populating,in table in itemName field, even i debugg the code, but no positive result,what would be reason, i just wonder,

    Thanks a lot for giving me your valuable suggestions...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans