Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
I am trying to generate a inventory value report but found the following problems:
1) All items are retrieved although I have set selecting criteria "XX12*" in "Resource"
2) Warehouse & Location data could not be retrieved (Already set View "Warehouse" & "Location" in report parameter)
Could anyone please advise if you have the same problem or not? or how you retrieve the warehouse & location data for each item (resource)?
AX2012 R2 Newbie,Arqxlep
I can see some of your problems too.
When I set criteria on the resource, only the selected items are retrieved. So this is working correctly within my enbironment.
Warehouse and Location: columns are presented, but values are missing. I guess the same problem as you have.
When I use the site: The values are shown.
When you share a printscreen of your settings, maybe we can have some ideas for you.
André Arnaud de Calavon
I ran it for a set warehouse and whilst there were many blank lines I transferred one item into the warehouse and I could see the transaction and the warehouse was listed in the voucher line. I would guess the dimension group financial costing flag would also impact on this.
" I would guess the dimension group financial costing flag would also impact on this." <- Do you mean the storage dimension setting (attached below) would affect the data display?
As we set site only as financial inventory dimension, so we could not get the warehouse & location data to the inventory value report?
Yes that is where I was going, if you do not cost at warehouse level then why would you show it at this level in a split format as it will always be the same unit cost - it would be the total that is different. I can see warehouse values in the one I have set. Can you create a new item with financial inventory set at warehouse, book it in and run the same valuation settings and see if you get a value?
I have seen the same behavior on the Inventory Value report where there is no data in the warehouse. I validated that the warehouse is displayed on the inventory value report only if the Financial Inventory box is checked in the item’s Storage Dimension Group.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics