web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Creating an inventory ...
Microsoft Dynamics AX (Archived)

Creating an inventory Cube

(0) ShareShare
ReportReport
Posted on by Lionel07 495

Hello Experts, I have a requirement to develop an Inventory Cube for my company.

Can anyone help me with what are the tables am to use to create the view pls? Any recommendation on the measure? Anything that you guys deem important would be greatly appreciated.

For this Cube they want to see how the inventory is. that is Physical quantity, available quantity, on hand  etc.

*This post is locked for comments

I have the same question (0)
  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    Hi Lionel07

    AX 2012 R2 / R3 already has an InventoryValueCube.

    docs.microsoft.com/.../inventory-value-cube-inventvaluecube-for-microsoft-dynamics-ax-2012-r2-and-r3

    Perhaps it will give you what you want already?

    Alternatively, you could a take a look at the Views behind it to see how it works. Start at the InventValueCube Query, and look at the Views used.

    Aside from that, my suggestion would be to use InventTrans, InventTransOrigin and InventDim. Your measures will most likely be the Qty field, and one or more of the CostAmount fields on InventTrans.

  • Lionel07 Profile Picture
    Lionel07 495 on at

    Thanks for your response Guy, but i don't think the inventoryValueCube gives me what i want.

    So for example, I want to be able to run a cube to see what are the items in the physical and financial amount that i have in stock. I thought the inventoryCube would give me this but it doest not.

    I am now forced to build a cube that can give a similar result like the inventory value report.  The tables you recommended are not giving me the correct values....

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    Hi Lionel07,

    If you cannot get the values you want, you are probably not excluding the right transactions. From what you describe, it sounds like you only want transactions with a Receipt status of blank, Received or Purchased, and Issue status of blank, Deducted or Sold.

  • Lionel07 Profile Picture
    Lionel07 495 on at

    Hi Guy, what i want exactly is a cube that will give me my physical inventory and the monetary value of the inventory. I really need some help on this. As I mentioned before the inventoryValueCube does not give me this information.

    I have tried to implement a cube using the following tables: InventSUM, InventDIM, InventBatch but it gave me error when i tried to link the InventBatch and inventSUM.

    Any help will be greatly appreciated.

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    As I said, I wouldn't use InventSum for that, because of the way that InventSum stores that data at multiple levels of the inventory dimensions (but that doesn't mean it's not possible).

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    Building a cube is wee bit  sensitive matter in AX2012. You need to take care of dimensions and measures. Do not include non-needed fields in your view. Make sure to assign an aggregate type to each real/decimal type field and make remaining fields as dimensions.

    Finally include your cubs into existing Cube Group called Dynamics AX, because that's mainly used to display data on EP role centers. In-fact you can mark only single cubes group as primary which ultimately feeds your dashboard, or else you have to use excel to extract data of cubes.  

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans