> 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-learning-hub-tutorials-and-best-practices/reports-queries/purchase-report/purchase-register-detailed-cross-tab/view-item-image-and-margin-in-purchase-register-detailed-cross-tab.md).

# View Item Image and Margin in Purchase Register Detailed - Cross Tab

**YouTube:** [How to Configure Item Image and Margin in Purchase Register Detailed – Cross Tab?](https://youtu.be/iNSiXDlEYOI?si=7wOua1KdaI8e0tCp)

## How to Configure Item Image and Margin in Purchase Register Detailed - Cross Tab?

In this tutorial, we will learn how to add the **Item Image** and **Margin(%)** columns to the **Purchase Register Detailed Cross Tab Report** in Logic ERP.

We will also learn how to adjust the grid row height to view item images clearly and configure the basis for calculating the margin percentage.

***

### Generate the Purchase Register Detailed Cross Tab Report

* Navigate to **Reports/Queries** > **Purchase Reports** and open **Purchase Register Detailed - Cross Tab**.
* Select the required date range.
* Generate the report.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fd1aDYE8gpwS3hpIAPxUL%2Fdefault%20report.png?alt=media&#x26;token=3188d12f-a40d-45b4-bac2-8e632a7543ed" alt=""><figcaption></figcaption></figure>

The Purchase Register Detailed Cross Tab Report is now displayed. Let's customize it by adding the required columns.

***

### Add the Item Image Column

* Open **Setup Column Attributes**.
* Locate the **Item Image** column.
* Select its checkbox to enable it.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FD6RbmRd0QPP4nnvpDfx8%2FSet%20Column%20Attribute.png?alt=media&#x26;token=f2613698-f026-49c4-9b11-4e52c13e561a" alt=""><figcaption></figcaption></figure>

* Save the changes.
* Press **F2** to refresh the report.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FeDbydrcfmBj09cGS64EG%2Fwith%20itm%20img.png?alt=media&#x26;token=b9da9d13-fb34-404d-8641-b6d8bf5a03f7" alt=""><figcaption></figcaption></figure>

**System Behavior**

* As you can see, the **Item Image** column has been added to the report. Images are displayed for items where an image is available.
* If an item image is not available, the column remains blank.

***

### Adjust the Grid Row Height

To view the item images more clearly, you can increase the grid row height.

* Open **Setup Column Attributes**.
* Navigate to **Other Settings**.
* Locate **Grid Row Height**.
* Enter the desired value.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FL8j9Om0wpDC3kHxUsowS%2FGrid%20Row%20Height.png?alt=media&#x26;token=70867321-7e18-496f-8599-55cb179d933f" alt=""><figcaption></figcaption></figure>

* Apply the changes and refresh the report if required.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FhvG7SGdW8danuzzLZ0TC%2Fenlrge%20img.png?alt=media&#x26;token=7cec67df-d05a-48c8-93a0-98763ac35c08" alt=""><figcaption></figcaption></figure>

**Result:** As you can see, the grid row height has increased, making the item images easier to view.

***

### Add the Margin(%) Column

Now, let's add the margin percentage to the report.

* Open **Setup Column Attributes**.
* Locate the **Margin(%)** column. (The separate **Margin** and **Last Margin** columns are different figures.)
* Select its checkbox to enable it.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FKca9bSrcSNsOj3jOYP6J%2FMargin.png?alt=media&#x26;token=2ba2133e-51b9-474d-a92b-372ccd9bb70c" alt=""><figcaption></figcaption></figure>

* Apply the changes and refresh the report.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FocEobIfLUPGYhLC6VWxT%2Fmargin%20column%20added.png?alt=media&#x26;token=701ce136-4146-45c1-b589-793ef8acade3" alt=""><figcaption></figcaption></figure>

**Additional Customization**

* Using **Setup Column Attributes**, you can enable other required columns and arrange them in your preferred order to make the report easier to analyze.
* As you can see, the **Margin(%)** column is now displayed in the report.

***

### Configure the Margin Calculation

* Press **F5** to open the configuration window.
* In **Rate 1 As** and **Rate 2 As**, choose the two rates to compare (Basic Rate, Sale Rate, Pur Rate, MRP, or Sp Rate1 to Sp Rate5). In this example, Rate 1 is **Sale Rate** and Rate 2 is **Basic Rate**.
* In **Margin % As**, choose **Rate1 - Rate2** or **Rate2 - Rate1**. For this example, we have selected **Rate1 - Rate2**.
* The margin is worked out as:
  * **Rate1 - Rate2:** (Rate 1 − Rate 2) ÷ Rate 1 × 100
  * **Rate2 - Rate1:** (Rate 2 − Rate 1) ÷ Rate 2 × 100
  * If either rate is zero, the margin shows 0.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F17Yd45HLL7KbjqsHP11m%2Fconfig.png?alt=media&#x26;token=df018b25-1b15-4071-bff5-a444ef0d1c64" alt=""><figcaption></figcaption></figure>

* Once the configuration is complete, save the changes and refresh the report if required.

***

### Verify the Margin Percentage

Let's review the margin percentage for the same item across two different purchase vouchers.

* **Voucher Date: 29 September 2026** — The margin is displayed as **30.10%**.
* **Voucher Date: 30 September 2026** — The margin is displayed as **33.33%**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fca84erDxqM7OomR1rUWl%2Fafter%20report.png?alt=media&#x26;token=dbd12277-4f16-4887-b3d0-5103bd917b52" alt=""><figcaption></figcaption></figure>

As you can see, the same item shows different margin percentages for the two vouchers. The margin is worked out on each line from the **Rate 1** and **Rate 2** of the lot on that line, so lines whose rates differ show different margins.

***

### Final Outcome

By using **Setup Column Attributes** and the report configuration, you can add Item Image and Margin(%) to the Purchase Register Detailed - Cross Tab report, adjust the grid row height for better image visibility, and define the basis for margin calculation.

The report displays the item images where available and works out the margin percentage on each line from that line's Rate 1 and Rate 2.


---

# 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-learning-hub-tutorials-and-best-practices/reports-queries/purchase-report/purchase-register-detailed-cross-tab/view-item-image-and-margin-in-purchase-register-detailed-cross-tab.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.
