Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

for Onhandinvent to add new fields from ecoresproductcategory table category and categoryhierarchy

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

In Ax 2012 R3 Onhandinventory reports i added two fields from ecorescategoryhierarchy table

but now i didn't get thedata to two fields how to write the code any one please guide me.

thanks for advanced.

sudarshan

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: for Onhandinvent to add new fields from ecoresproductcategory table category and categoryhierarchy

    Hi SudarshanChowdary,

         Gone through the product information management --> releasedproduct-->and select one item and go to actionpane and click productcategories button path,

    1. This is to categories the items to which categories need to be selected, and this is to be select the item category in below path:  Product information management --> Common --> product by category

    Prod1.JPG

    You can write a condition for this category wise, What your missing here, Please show me your report screen shot with specifying the category!

    Thanks

    Suresh

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: for Onhandinvent to add new fields from ecoresproductcategory table category and categoryhierarchy

    Hi suresh ,

    go to product information management --> releasedproduct-->and select one item and go to actionpane and click productcategories button

    then you select the categoryhierarchy and category i need that data

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: for Onhandinvent to add new fields from ecoresproductcategory table category and categoryhierarchy

    Hi Sudarshan,

       Onhand Inventory report wont show category wise, You can please check back again. Or else please share one scenario, i will also test in my environment.

    Thanks

    Suresh  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: for Onhandinvent to add new fields from ecoresproductcategory table category and categoryhierarchy

    HI Brian now coming the data both fields when i select different categories for different items the ax picking based on first item only getting category and hierarachy. how to get

  • Suggested answer
    Brian Kinser Profile Picture
    Brian Kinser 815 on at
    RE: for Onhandinvent to add new fields from ecoresproductcategory table category and categoryhierarchy

    you must first modify the data provider.....you should look at InventOnHandDP class, that is where the data for the report comes from....there you will see you need to add the field there....and you will need to write some code to find the field value you are looking to display.....when using this approach (Data Provider as opposed to a simple query) you must run query or select statement to gather the data, then insert into a temp table, then your report will pull from the temp table....so...you need to add your field to the temp table...then create a select or query to find your table/field value, insert into the temp table....then in the report make sure you right click data source and refresh to see your new field

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans