> 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/reports/configure-brand-wise-consolidated-and-detailed-sale-report.md).

# Configure Brand wise consolidated and detailed Sale Report

**YouTube:** [How to configure Brand-wise consolidated and detailed Sale Report?](https://youtu.be/X6BQRgTmp-s)

## How to Configure Brand wise consolidated and detailed Sale Report

In this tutorial, we’ll learn how to configure and generate **brand-wise consolidated** and **detailed sale reports** in **Logic ERP** using the *Sale Register - Cross Tab Report*.

***

### **Access the Sale Register Cross Tab Report**

* Navigate to the **Reports/Queries** section.
* Select **Sale Registers**.
* Open the **Sale Register - Cross Tab** report.
* Click on **Configuration** to open the setup window.
* Define a new **report configuration**.

<figure><img src="/files/rvxp3nushcPUVZzvEj1E" alt=""><figcaption></figcaption></figure>

***

### **Configure Report Options**

* Navigate to Report options.
* Under **Report Consolidation** select "**Item"**.
* Within **Item Consolidation**, tick **Company Name** and move it to the **top** using the arrow keys.
* In the **Report Totals** section, enable the **Grand Total** option to display overall totals.
* Under **Report Order**, move **Item** to the top using the arrow keys to prioritize item-wise sorting.

<figure><img src="/files/rw89IJ0N7XNZ4d6gN2rf" alt=""><figcaption></figcaption></figure>

***

### **Configure Transaction and Other Options**

* Navigate to the **Transaction Options** section.
* Enable **Display Transaction Details**.
* Choose whether to present the report **by Value** or **by Quantity**.

<figure><img src="/files/VN00Ze8aspKldUGX6ecV" alt=""><figcaption></figcaption></figure>

* In the **Other Options** section, configure any additional preferences as per your requirements.

<figure><img src="/files/vFwglJYpE0GoU9FJWA2m" alt=""><figcaption></figcaption></figure>

* Once done, **save the configuration**.

***

### **Create and Customize the Report Layout**

* From the list of available configurations, select your newly created configuration.

<figure><img src="/files/LS2AlgPP9xYYkCmqp8my" alt=""><figcaption></figcaption></figure>

* Click on the **Create** button.
* By default, all columns will be visible.
* To customize:
  * Click **Setup Column Attributes**.
  * Select all columns first, then choose only the required ones for your report.
  * Rearrange the column order using the arrow keys.

<figure><img src="/files/PXCVQBKgRHV1aYU0rW6A" alt=""><figcaption></figcaption></figure>

* Save your settings.

***

### **Generate and View the Brand-Wise Sale Report**

* Refresh the report by pressing **F2**.
* The report will now display **brand-wise consolidated sales** within the defined date range.

<figure><img src="/files/Qc34agHJI65oxBtPy2il" alt=""><figcaption></figcaption></figure>

### **View Report Using Brand Filters**

* To view sales for a specific brand or company, use the **Report Filter.**
* Select the desired **brand/company** from the list.

<figure><img src="/files/AqYJ5k7vlGkzxvOJPeoM" alt=""><figcaption></figcaption></figure>

* Generate the report accordingly.

<figure><img src="/files/Vc9kd3c6WthUnEBAFwfn" alt=""><figcaption></figcaption></figure>

***

### **Generate a Detailed Brand-Wise Item Report**

* To view **item-level details** for a specific brand, open the **Configuration** window again.
* Under **Report Options → Item Consolidation**, select:
  * **Item Name**
  * **Pack Name**
  * **Shade** (if applicable)

<figure><img src="/files/tY8bLwyPH4LwIevbBxsP" alt=""><figcaption></figcaption></figure>

* Next, open **Setup Column Attributes** and enable:
  * **Item Name**
  * All related fields required to generate a detailed item-wise report.
* Save the configuration and refresh the report.
* The system will now display a **detailed brand-wise item-level sales report**.

<figure><img src="/files/Pr8ewzqI150TpNd9DoIR" alt=""><figcaption></figcaption></figure>

***

**You have successfully configured both consolidated and detailed brand-wise sales reports in Logic ERP.**


---

# 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 dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/configure-brand-wise-consolidated-and-detailed-sale-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.