Is it possible to generate a Report containing the results from the Where Used function? Other solutions I've seen only contain one level of results - I am looking for a Where Used Report that goes through multiple levels.
Per Angela's suggestion, I did this with a query definition. Basically I have a custom item type for Finished Goods that lives at the top of all my BOMs and I needed the Where Used to go all the way up to that item. I have also got the AML from this query somewhere. I simply ran the debugger to get the log to view the AML request sent to the server as the query was executed.
My definition looks like:
And the resulting view looks like (it's looking up even though it looks like it's going down... haven't figured this part out yet):
Oh very cool. I want to do something similar at work, but I still have a lot of research to do
Are you looking for a Report or just the query result?
There is a AML action ("GetItemWhereUsed"), that gives you the XML result. If you are more looking for an real Report option I would use other inbuild option.
1. Query Definition + Tree Grid View. You can use these two for building a custom Where Used view for users. In newer version you should be able to Export the result as xls
2. SSRS Report. Here you have to program the Where Used Query by yourself. But it gives you more freedom when exporting various formats like pdf, xls, xlsx and when you want to use the result in a data package.
3. Maybe Aras Self-Service Report
4. Aras XSLT Report. Would be the fasters solution, but stylesheet challenging.
The "GetItemWhereUsed" only returns one level of the Where Used Results - I'd like to expand it for multiple levels like in the Where Used view. Any suggestions for getting the expanded results?
How many ItemTypes are involved in your task? 'GetItemRepeatConfig' would work when you don´t have too much ItemTypes.
https://community.aras.com/b/english/posts/special-aml-actions
It´s maybe possible to combine it with GetItemWhereUsed when you need a full coverage of everything, but I never tried.
Beware: The sample shown in the article looks "downwards", as you would do in a Bill-of-material.
You have to change the repeat property so it looks "upwards".
