COGM Report

Report Module Guide: COGM Report

Module Location

Inventory > Item/Service > COGM Card > Report

Module Objective

The COGM Report module is used to generate a report that displays the current Cost of Goods Manufactured (COGM) for all items. This report is a recapitulation of the calculation results that have been created and approved in the COGM Card module, and it is used to see the list of standard product costs.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Show Item:

  • Select All to display all items, or Last Update to display items whose COGM was recently updated.

• As of Date:

  • Specify the reference date ("as of" date) for the COGM data to be displayed.

• Detail:

  • Select Summary for a concise report, or Detail to display a breakdown of the cost components.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, such as the date and the report's level of detail.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the COGM report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of items along with their cost of goods manufactured.

• View: This report displays the Item Code, Item Name, Price (Cost), and Update By information (who updated it and when).

• Additional Features: This report is interactive, allowing you to copy, download in CSV or Excel format, or print directly using the buttons in the top-left corner.

Tips & Important Notes

• This report is a quick way to see the standard cost (COGM) of all your products.

• Use this report for profitability analysis by comparing the COGM here with the selling price in the Item/Service Price module.

• This report is a recapitulation of the data that is final and approved in the COGM Card workflow.