Microsoft Dynamics AX (Archived)

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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Brian Kinser 815 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No