Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Cost of the items in power BI

Posted on by 110

Hi All

I'm Creating a dashboard in Power BI using  CustInvoiceTrans , InventTable and  InventDim tables , I want to get the cost of the items within the specified period ? is theire anyway to get it direct from this tables or I need to add Inventtrans & InventTransOrigin to the datasource of the Dashboard ?

Categories:
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cost of the items in power BI

    I see.

    But even then the costs might subsequently change if a transaction is not fully settled in one month and is then picked up in the next inventory close.

    The inventory value report is the right 'base' for your PowerBI analysis in my opinion.

    Please check out the underlying data provider for the extraction of your data and analysis in PowerBI.

    Best regards,

    Ludwig

  • Hussien Ahmed Profile Picture
    Hussien Ahmed 110 on at
    RE: Cost of the items in power BI

    Hi  the weighted average

    We are doing inventory closing and adjustment and recalculation every month using the weighted average principle and according to it we are getting the cost of the items in the inventory value report and the inventory transaction with the correct value.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cost of the items in power BI

    Hi Hussien,

    What kind of costs are you looking for and what cost valuation principle do you use (Fifo, Lifo, etc.)

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans