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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Management Report - pu...
Microsoft Dynamics AX (Archived)

Management Report - pull sales quantity into P&L

(0) ShareShare
ReportReport
Posted on by lmai 2,438

Hi All, 

Is there a way that I can pull the sales quantity into the Income Statement? I saw a thread in the community about excel add-in.  

To get the total "Sold" quantity, is there a report that shows beginning inventory + new purchase inventory - ending inventory = sold?  What about the unit conversion?

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,195 Super User 2025 Season 2 on at
    RE: Management Report - pull sales quantity into P&L

    Hi Kim,

    There is  customer/item statistics report which can show the sold quantities together with the turnover. Why do you want to combine quantities on your income statement? The quantities sold for e.g. DVD players cannot be compared/cumulated with e.g. charging cables.

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,671 Moderator on at
    RE: Management Report - pull sales quantity into P&L

    Hi Kim,

    MR is for financial reporting and doesn't account inventory quantities within financial reporting. As no qty, so no unit conversion either.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Report - pull sales quantity into P&L

    Hello Kim,

    Management Reporter is probably not the best tool for quantity based recording as Andre mentioned.

    Theoretically you can do that either with the Excel integration or by posting the quantities separately on statistical accounts that you can analyze in MR.

    This does, however, involve a lot of additional work and I feel that the standard reports and BI tools are better suited for that.

    About your report:

    The inventory value report can show you the quantity sold through sales orders in a separate column. For that purpose, you have to enable the "COGS" checkbox in the inventory value report configuration window.

    Best regards,

    Ludwig

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 3

#3
Willem van Duren Profile Picture

Willem van Duren 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans