> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/production/generate-projected-production-cost-sheet-report.md).

# Generate Projected Production Cost Sheet Report

**YouTube:** [How to Generate Projected Production Cost Sheet Report?](https://www.youtube.com/watch?v=Ql9Yq0eTeUg)

## How to Generate Projected Production Cost Sheet Report?

In this tutorial, we will learn how to generate a **Production Cost Sheet Report** in Logic ERP. This report helps analyze all costs incurred during the complete production cycle, including raw materials, processes, and final product cost.

***

### **Accessing Reports and Configuration**

* Navigate to Production\Production Reports/Queries\Production Raw Material Reports and then select **"Cost Sheet".**
* Click on **Configuration**.
* Create a **new report setup** and enter a suitable **configuration name**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FV4pEtUUp1jdyOtPM12CN%2FReport%20Configuration%20%20Name.png?alt=media&amp;token=0ad215ef-dbd6-4355-aa71-608ba716200d" alt=""><figcaption></figcaption></figure>

***

### **Set Print Options**

* Under **Print Options**, enable the following based on your requirement:
  * **Transaction Types Totals**
    * Displays totals grouped by each transaction type within a job order.
  * **Job Order Totals**
    * Shows the overall total cost per job order, consolidating all related transaction types.
* Set **Control Break = Job Order Wise**
  * This groups and displays data separately for each job order for a clear cost overview.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FcUyS2PKUlxUc1cCmQjMh%2FPrint%20Totals.png?alt=media&amp;token=0939af42-bcbb-43fb-8437-959ba44c3f4c" alt=""><figcaption></figcaption></figure>

***

### **Configure Report Options**

* In the **Report Options** section:
  * Select the required **Raw Material Rates** from the dropdown (this rate type will be used for cost calculation).
  * Use the **Markup MRP As** option to define how markup MRP rates should appear in the report.
  * In the **Report Order** section, use the arrow buttons to arrange components in the desired sequence for a clean and organized layout.
  * Enable **Quantity Produced Net Cost from Issue** if you want a more detailed cost analysis.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FVchfVPaVOrUuOkxJc5ft%2FReport%20Options.png?alt=media&amp;token=6127948f-7e72-4db0-a493-67581c83830f" alt=""><figcaption></figcaption></figure>

* After completing all settings, **save the configuration**.
* Your report setup is now created.

***

### **Generate the Report**

* Click on **Create** to generate the cost sheet report.
* The report will display **all available columns** by default.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FKBwjIVVMujvgO2qdw7EF%2FDefault%20Report.png?alt=media&amp;token=aafaccd0-9c85-4eea-9b0e-f2de55cbd589" alt=""><figcaption></figcaption></figure>

***

### **Customize Report Columns**

* Open **Setup Column Attributes**.
* First, **Unselect All** columns.
* Then, select only the columns you want included in the report.
* Rearrange the columns using the arrow buttons for proper sequence.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FAsnInR8kuBLaK4nZ2amB%2FSet%20Column%20Attribute.png?alt=media&amp;token=5020ea06-00a2-4d7f-a66d-a6c96569413e" alt=""><figcaption></figcaption></figure>

* Save your changes.

***

### **View the Final Cost Sheet**

* Press **F2 (Refresh)** to update the report.
* The refreshed report will now display your customized columns and the latest data.
* This report helps you analyze:
  * Total production cost
  * Raw material consumption cost
  * Process-wise cost
  * Job order–wise production cost
  * Final product cost

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FJr43Z9Ncv0TmOo7eXFW3%2FFinal%20Report%20View.png?alt=media&amp;token=af4c4b18-e026-4ca3-9df4-61408e4bb3dd" alt=""><figcaption></figcaption></figure>

It provides a **complete and consolidated view** of all production expenses for the selected period.

***

### **Conclusion**

With these steps, you can easily configure and generate a detailed Production Cost Sheet Report in Logic ERP. This report is essential for understanding cost flow, evaluating profitability, and making informed decisions related to production planning and cost control.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/production/generate-projected-production-cost-sheet-report.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
