Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Suggested answer

COGS Report in MS D365 F&O

(1) ShareShare
ReportReport
Posted on by 2
Hi,

We are looking for COGS by Item/Product Report.

Standard Report in S&M >Inquiries and Reports > Statistics > Sales Analysis by Invoice Report has COGS but it is given by customer wise.
 
Standard Report in S&M >Inquiries and Reports > Statistics > Gross Margin by Item Report has COGS as required.

But in case if we look at visualization point of view how can we achieve in Power BI, the above data populates from CustinvoiceTrans and InventTrans.

I couldn't find InventTrans showing up in Power BI Navigation.

Any help here is really appreciated.

Thank You
Kumar 
  • Suggested answer
    andreasraithel Profile Picture
    andreasraithel 4,828 Super User 2024 Season 2 on at
    COGS Report in MS D365 F&O
    Hy,
    within the Sales and marketing is the "Sales and profitabilty performance" report, that is a embedded Power BI Report that works on Tier 2 and above.
     
    This report covers the dimension Customer and product as dimensions and the revenue, cogs and gross margin as facts.
     
    The report can be redesigned by using "Edit analysis" on the Power BI page which has immediate affect on the report or by customization by Developer.



    Hope thes helps.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans