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
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
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
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156