Skip to main content

Notifications

Announcements

No record found.

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?

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

    Hi,

    Have you tried activating things in a costing version?

    You need to open your costing version in the inventory module (check the setup section) where you can activate those prices as well.

    If you cannot do it there as well, then talk to your system administrators because you might need more user rights.

    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.

  • 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?

    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 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?

    Where can I access the USMF MS demo?

  • 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?

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

  • 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?

    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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,025 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,852 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans