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 NAV (Archived) / Sales Analysis and COGS
Microsoft Dynamics NAV (Archived)

Sales Analysis and COGS

(0) ShareShare
ReportReport
Posted on by Community Member

Hello!

Another question, when I make Sale Analysis Reports , the COGS is the average price per unit, as we do average inventory costing method, nevertheless sometimes to yield this reports this amount is not very useful, as for example the price of certain raw materials peak and drop cyclically, so it would be fantastic if we could for example select the last unit cost for the last sale, or the average unit cost for only the last 3 months. Is this possible, and if so, how?

Thanks!!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    *COGS is the average price per unit. I meant COGS is the average cost per unit

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Try this.  Define Column as Unit Cost. 

    0272.1.PNG

  • Community Member Profile Picture
    Community Member on at

    mmm ok, what is that supposed to do, I havent got myself into the analysis type code. I'll try to inform myself . I havent used that at all so far, that is that my colum analisys type code is blank. How does that make a change?

    Thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    If you define the Column Layout, you can choose to get the last Unit Cost (instead of COGS) for further calculation.

  • Community Member Profile Picture
    Community Member on at

    Ok, so I pretty much reproduced what you did in your screenshoot, but when I add that last unit cost colum I get no results when I create the matrix. any ideas why that is so?  

  • Community Member Profile Picture
    Community Member on at

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    attach screen shot here for the output matrix? Are you able to drill down that Unit Cost field and getting Item Master record?

  • Community Member Profile Picture
    Community Member on at

    Attach screen shot again

  • Community Member Profile Picture
    Community Member on at

    Ok, I fixed that.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    If you have too much fluctuation in Raw Material Pricing and would like to see the actual COGS, you should use FIFO costing method instead of Average.

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 NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans