Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Breakdown of COGS
Business Central forum
Suggested answer

Breakdown of COGS

(1) ShareShare
ReportReport
Posted on by RA-27060820-0 2
Hi,
 
We are a company in the horticultural industry. We are producing customer ready bouquets for retail chains. Is it in any way possible to get a breakdown of COGS? I.e. we have setup Inventory valuation and direct posting to G/L. However all inventory postings result in a lump sum amount on COGS account. I would like to have insight in the breakdown of all relevant costs added to inventory costs (item charges like airfreight, labour etc). Is that possible?
 
Regards,
Richard
Categories:
Financial Management
Reports and Business Intelligence
  • Matteo Fiocco Profile Picture
    Matteo Fiocco 73 on at
    Breakdown of COGS

    Hi Richard,

    Yes, it's definitely possible. Here’s how you can achieve this:

    1. Using Item Charges

    Item charges allow you to add costs such as airfreight, labor, and other additional costs to the value of your inventory items. By doing this, you can ensure that the costs are accurately reflected in your inventory valuation and subsequently in your COGS.

    Steps to Set Up and Apply Item Charges:

    1. Set Up Item Charges:

      • Go to "Item Charges" page.
      • Define the various item charges you want to track (e.g., Airfreight, Labor).

    2. Assign Item Charges to Purchases:

      • When posting purchase invoices, you can assign these item charges to the relevant inventory items.
      • Navigate to the "Purchase Invoice" page.
      • Enter the purchase lines as usual.
      • Add a new line for the item charge.
      • Use the "Item Charge Assignment" function to distribute the charge to the appropriate items.

    2. Tracking and Reporting:

    To get a detailed breakdown of your COGS, you can use a combination of standard reports and customizations:

    1. General Ledger Reports:

      • Use the "Inventory Posting - Cost to G/L" report to get an overview of how costs are posted to the general ledger.

    2. Inventory Valuation Reports:

      • The "Inventory Valuation" report can provide details about the value of your inventory, including the applied item charges.

    3. Cost Accounting:

      • You can set up cost accounting in Business Central to get a more detailed analysis of your costs. This involves setting up cost types, cost centers, and cost objects.

    4. Custom Reports and Analysis:

      • Create custom reports using Business Central’s reporting tools or Power BI for more granular insight into your COGS.
      • Use the "Item Charge Assignment" entries to analyze the distribution of item charges.

    Example:

    If you want to see the impact of airfreight on your COGS:

    1. Assign airfreight item charges to your purchase orders.
    2. Run the "Item Charge Assignment" report to see how the airfreight costs are distributed.
    3. Use the "Inventory Valuation" report to see the adjusted inventory values including the airfreight costs.

    By properly setting up and using item charges, you can get a much more detailed breakdown of your COGS. This will allow you to see the impact of various additional costs like airfreight and labor on your inventory and COGS accounts.

    Feel free to ask if you need detailed steps on any part of this process or if you need assistance with setting up custom reports.

  • FX-03070658-0 Profile Picture
    FX-03070658-0 4 on at
    Breakdown of COGS
     
    Hi,
     
    This is richard (trough a different account as I can't login with my previous account anymore, entered in a "sign in loop"......).
     
    @ Jun Wang / Valentin: we are using the production order between purchase and sales orders. So all costs are posted to direct costs and COGS accounts when we raise the invoice for produced items. We add additional costs to the purchase receipts through item charges posted via separate purchase invoices for the respective costs. All item charges have their own Product Posting Group. However, all inventory postings result in COGS postings on the product posting group settings of the sold product (in our situation always flowers). Is there a way to achieve this? I tried using dimensions, which work for the purchase part but not for the COGS part. Then dimensions are not carried forward.
     
    Rgrds,
    Richard
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 5,498 Super User on at
    Breakdown of COGS
    you need to check if your general posting setup, if business/product posting groups combination was setup using the proper cogs accounts. If all point to the same account, you won't be able to differentiate properly. 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 6,582 Super User on at
    Breakdown of COGS
    Can you please expand on your inventory/process. Do you simply buy and re-sell items? Or do you use assembly orders for your bouquets? Where is the item charge for labor included, in the sales order?
     

Helpful resources

Quick Links

First Dynamics 365 Community Call (CRM Edition)

Don't miss the first D365 Community Call on 7/10!

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 285,557 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,484 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans