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 :
Finance | Project Operations, Human Resources, ...
Suggested answer

How do I setup COGS?

(0) ShareShare
ReportReport
Posted on by 20

Our COGS at the moment is setup to our Manufacturing Cost where in fact it needs to be setup to be the inventory of items sold cost.  How can we go about this change?

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How do I setup COGS?

    Hi,

    The CostOfGoodSold can consist of your item costs, the costs related to your work processes (routes), charges and more.

    Can you let us know more details of what you want to setup exactly, what has been setup and possibly does not work and elaborate?

    Some supporting screenshots would help.

    Many thanks,

    Ludwig

  • stefyu3677 Profile Picture
    20 on at
    RE: How do I setup COGS?

    Hi Ludwig,

    Thank you for your quick response. Our Cost Of Goods sold (Income Statement) should include item cost.  Item costs should include the amount (weighted average):

    - Raw Materials

    - Direct Labor Cost

    - Fixed Overhead

    - Variable Overhead

    Current setup includes item above but not the historical item cost but the cost for the given month.  

    Can you guide me to which screenshots you would need for better assistance?

    Thanks.

    Regards,

    Stef

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How do I setup COGS?
    [quote user="stefyu3677"]Current setup includes item above but not the historical item cost but the cost for the given month.  [/quote]

    Can you explain what you mean by this?

    Many thanks, 

    Ludwig

  • stefyu3677 Profile Picture
    20 on at
    RE: How do I setup COGS?

    No-COGS.pdfHi Ludwig.  I attached the file for your reference.  There's something wrong with the setup of COGS.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How do I setup COGS?

    Hello Stef,

    Thanks for sharing the document.

    What I got from there is that you want to include let's call it "overhead" in your inventory values / COGS.

    This can be achieved by making use of the costing sheet where you can define a kind of surcharge / allocation of that overhead.

    As an example, whenever you purchase or produce an item then $x is added on top of the material or labor costs.

    To see how this works, have a look at the costing sheet that is available in the USMF MS demo company.

    It includes a couple of examples how overhead can be incorporated into your valuations.

    Best regards,

    Ludwig

  • stefyu3677 Profile Picture
    20 on at
    RE: How do I setup COGS?

    Where can I access the USMF MS demo?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How do I setup COGS?

    Hi Stef, 

    Do you have a demo or test environment?

    Probably ask your IT admin guys for that. 

    If you have that, search for the USMF demo company and then in the inventory module for the costing sheet where you can find some examples. 

    Best regards, 

    Ludwig

    2768.cs.png

  • stefyu3677 Profile Picture
    20 on at
    RE: How do I setup COGS?

    I accidentally activated a cost rate of an item. How do I edit the rate of a cost item?1263.Picture1.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How do I setup COGS?

    Hi,

    Just activate a new price of $0.

    That should fix the issue.

    Best regards,

    Ludwig

  • stefyu3677 Profile Picture
    20 on at
    RE: How do I setup COGS?

    The "Activate" button is disabled already.  I only have "Validate" and "Save" button up.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,100

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 890 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 633 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans