> 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.md).

# Purchase Register Detailed – Cross Tab

**Available on:** Desktop · Web

Navigate to **Reports/Queries\Purchase Reports** and click on "Purchase Register Detailed - Cross Tab".

The **Purchase Register Detailed - Cross Tab** lists your purchases for a date range as a cross tab. You decide what each **row** stands for (a bill, a party, an item, a lot, a branch …) and which figure is spread across the **columns** (by branch, party, agent, godown, item or period). Use it to see what was bought, from whom, where it went, at what rate, and how it compares with the purchase order behind it.

## Run the report

1. Choose a configuration (see [**Purchase Register Detailed - Cross Tab - Configuration**](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/purchase-report/purchase-register-detailed-cross-tab/purchase-register-detailed-cross-tab-configuration.md)).
2. Enter the **From** and **To** dates. They check the purchase voucher date, or the supplier's bill date if the configuration says so.
3. Narrow the report with the selections if needed — items, lots, companies, parties, party groups, purchase accounts, vouchers, branches, godowns and so on. You can choose more than one of each. Leave them empty to include all.
4. Run the report.

Good to know:

* **Purchase / Return As** in the configuration decides whether purchases, purchase returns (with rate-difference documents) or both are shown. It is not applied when a **Sttock Receipt Production Fillter** is chosen. Purchase returns are shown as minus figures.
* Purchase challans can be added with **Display Purchase Challans also** in the configuration. The **Purchase Challan Register - Cross Tab** is the same report for purchase challans.

## How the report is laid out

**Rows.** Each row is one combination of the entries ticked under **Report Consolidation** and **Item Consolidation** in the configuration. For example, ticking **Document No.**, **Item Name** and **Pack / Size** gives one row for each item and pack on each purchase bill (a second row if the same item is billed at a different rate). All the purchase lines that fall into a row are added together.

**Columns.** **Column As** in the configuration picks what the columns stand for: **Branch** (first choice), **Branch Group**, **Party**, **Party Group**, **Items**, **Agent**, **Godown** or **Period**. The report makes one column for each branch, party, agent … found in the data. With **Period**, **Period As** decides whether the columns are days, weeks, months, quarters, half-years or years. **TOTAL** adds up all these columns on the row. The row's own column for that choice — for example **BRANCH NAME** when the columns are branches — is left blank.

**What each cell shows.** The figures ticked under **Txn Type Selection** — **Total Qty**, **Free Qty**, **Repl Qty**, **Sample Qty**, **Gross Value**, **Net Pur Value**, **User Defined Net Amt-1**, **User Defined Net Amt-2**, **Contribution(%)** and **Lot Number Count**. Each ticked figure is printed on its own line under the row, and **TXN TYPE** names it. With **Show TXN Types As Columns** ticked, they become columns instead, one for each column-and-figure pair.

> **Example — godown-wise purchases by bill**
>
> The configuration has **Column As** set to **Godown**, **Total Qty** and **Net Pur Value** ticked under **Txn Type Selection**, and **Document No.**, **Item Name** and **Pack / Size** ticked. Bill 1024 from Sharma Textiles brings 100 shirts at ₹250: 60 go into the Main Godown and 40 into the Showroom godown.

The report shows two lines for that item of the bill:

| TXN TYPE      | MAIN GODOWN | SHOWROOM | TOTAL  |
| ------------- | ----------- | -------- | ------ |
| Total Qty     | 60          | 40       | 100    |
| Net Pur Value | 15,000      | 10,000   | 25,000 |

## The main columns

These columns are offered when the report opens. A column whose condition is not met stays empty, and an empty column is hidden after the report runs (except the item picture column).

| Column                                                                                                                                                                                                          | Meaning                                                                                                                                                                                             |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **VOUCHER DATE**, **VOUCHER NO.**, **FIN YEAR**, **BILL NO.**, **BILL DATE**, **GRN NO.**                                                                                                                       | the purchase voucher and the supplier's bill. They need **Document No.** ticked. Without it, **VOUCHER DATE** shows the period of the row when **Period** is ticked and the columns are not periods |
| **G.R. NO.**, **G.R. DATE**, **TRANSPORT**, **TRANSPORT MODE**, **REMARKS-1**, **REMARKS-2**, **REMARKS-3**                                                                                                     | transport details and remarks of the purchase — with **Document No.**                                                                                                                               |
| **DOCUMENT TYPE**                                                                                                                                                                                               | **Purchase**, **Purchase Return**, **Rejection** or **Rate Difference** — with **Document No.**                                                                                                     |
| **BRANCH GROUP NAME**, **BRANCH NAME**, **BRANCH CODE**, **AGENT NAME**, **GODOWN NAME**                                                                                                                        | filled when the matching entry is ticked under **Report Consolidation**                                                                                                                             |
| **PARTY NAME**, **PARTY GROUP NAME**, **ADDRESS-1**, **ADDRESS-2**, **ADDRESS-3**, **CITY NAME**, **PIN CODE**                                                                                                  | the supplier — with **Party Wise** ticked (**Party Group Wise** for **PARTY GROUP NAME**)                                                                                                           |
| **ITEM NAME**, **ITEM NAME W/O SHADE**, **ITEM CODE**, **PACK / SIZE**, **COMPANY NAME**, **GROUP NAME**, **SHADE NAME**                                                                                        | the item, as far as it is split under **Item Consolidation**                                                                                                                                        |
| **ITEM DESCRIPTION**                                                                                                                                                                                            | the item's **Item Description-1** from the item master. It fills when **Item Name** or **Item Description** is ticked, and shows in full when **Item Name** is ticked                               |
| **LOT CODE**, **LOT NUMBER**, **EXPIRY DATE**, **MFG DATE**                                                                                                                                                     | the lot — with **Lot Code** or **Lot Number** ticked                                                                                                                                                |
| **TOTAL QUANTITY**, **FREE QTY**, **REPL QTY**, **SAMPLE QTY**                                                                                                                                                  | quantities purchased. **Include Free/Repl/Sample In Total Qty** adds free, replacement and sample quantities into **TOTAL QUANTITY**                                                                |
| **RATE/UNIT**, **RATE/PACK**, **RATE-1**, **RATE-2**, **MARGIN(%)**                                                                                                                                             | rates. They fill with **Document No.** together with **Lot Code**, **Lot Number**, or **Item Name** and **Pack / Size**, or when **Rate Consolidation As** is **Rate-1 And Rate-2**                 |
| **GROSS AMOUNT**, **NET AMOUNT**, **ACTUAL NET AMOUNT**                                                                                                                                                         | the purchase values                                                                                                                                                                                 |
| **TAX-1(RS)**, **TAX-2(RS)**, **TAX-3(RS)**, **CD**, **TD**, **SP CD**, **FREIGHT**, **SP. DISCOUNT**, **ADJUSTMENT**, **SCHEME(RS.)**, **DEBIT NOTE**, **CREDIT NOTE**, **DISPLAY**, **HANDLING**, **POSTAGE** | taxes, discounts and charges on the purchase                                                                                                                                                        |
| **UD NET AMOUNT-1**, **UD NET AMOUNT-2**, **AMOUNT (USER DEFINED RATE)**, **DIFFERENCE**, **DIFFERENCE(%)**                                                                                                     | amounts worked out the way the configuration defines them                                                                                                                                           |
| **TXN TYPE**, **TOTAL**                                                                                                                                                                                         | the figure shown on the line, and the total across the columns                                                                                                                                      |

## More columns

These can be switched on in the report's column settings.

| Column                                                                                                                                    | Meaning                                                                                                                                                                                                          |
| ----------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **PO ORDER NO.**, **PO ORDER DATE**, **PO SUPPLIER ORDER NO.**                                                                            | the purchase order(s) the purchase was made against — with **Document No.**                                                                                                                                      |
| **PO RATE**, **PO QUANTITY**, **PO PENDING QUANTITY**, **PO AMOUNT**                                                                      | the rate, quantity and amount (quantity × rate) ordered on the purchase order, and the quantity still pending on it today. **PO RATE** is blank when the orders have different rates                             |
| **PO REMARKS**, **PO DELIVERY DATE**, **PO DELIVERY AT**, **PO DELIVERY ADDRESS-1**, **PO DELIVERY ADDRESS-2**, **PO DELIVERY ADDRESS-3** | remarks, delivery date and delivery address entered on the purchase order                                                                                                                                        |
| **SHORT QTY**, **REJECTION QTY**                                                                                                          | the short and rejected quantities entered against the purchase                                                                                                                                                   |
| **DN DOC NO.**, **DN DOC DATE**, **DN BILL NO.**, **DN BILL DATE**, **DN QTY**                                                            | the debit note made from that shortage or rejection — a purchase return or a purchase return challan, made in any financial year                                                                                 |
| **GST NO.**, **GST STATE CODE**, **GST STATE NAME**, **ACCOUNT CODE**, **PARTY USER CODE**, **ACCOUNT PRINT NAME**                        | more supplier details — with **Party Wise**                                                                                                                                                                      |
| **TOTAL CGST AMOUNT**, **TOTAL SGST AMOUNT**, **TOTAL IGST AMOUNT**, **HSN CODE**, **HSN DESCRIPTION**, **TAX REGION**                    | GST amounts and the item's HSN                                                                                                                                                                                   |
| **CD(%)**, **TD(%)**, **SPCD(%)**, **TAX-1(%)**, **TAX-2(%)**                                                                             | discount and tax rates                                                                                                                                                                                           |
| **PURCHASE A/C NAME**                                                                                                                     | the purchase account the purchase was posted to                                                                                                                                                                  |
| **GPN NUMBER**, **GPN DATE**, **CHALLAN NO.**, **CHALLAN DATE**, **VEHICLE NO.**, **LOGIC USER NAME**, **VOUCH TIME**                     | gate pass, supplier challan and vehicle details, and who entered the purchase and when — with **Document No.**                                                                                                   |
| **E-INVOICE ACKNOWLEDGEMENT NO.**, **E-INVOICE ACKNOWLEDGEMENT DATE**, **E-INVOICE IRN NO.**                                              | the e-invoice of the purchase — with **Document No.**                                                                                                                                                            |
| **ITEM IMAGE**, **PURCHASE ITEM DESC**, **ADDLTIONAL ITEM NAME**, **ADDLTIONAL ITEM CODE**                                                | the item's picture (with **Item Name** or **Item Name W/o Shade** ticked), the description typed on the purchase line, and the additional item name (with **Item Name** or **Item Description** ticked) and code |
| **LOT BILL NO.**, **LOT PURCHASE DATE**                                                                                                   | the bill number and purchase date recorded on the lot — with **Lot Code**                                                                                                                                        |
| **ADDITIONAL EXPENSES**                                                                                                                   | one column for each additional expense posted against the purchase, and a per-unit column as well when **Also Display Addl Expense/Unit** is ticked — with **Document No.**                                      |
| **CONTRIBUTION(%)**                                                                                                                       | the row's share of the grand total, or of its item group, as set under **Contribution Option**                                                                                                                   |
| **CUMULATIVE TOTAL QUANTITY**, **CUMULATIVE NET AMOUNT**, **CUMULATIVE GROSS AMOUNT**                                                     | running totals from the start of the financial year or the calendar year (**Cumalative As**), period by period — with **Period** ticked                                                                          |

**PO RATE**, **PO QUANTITY**, **PO PENDING QUANTITY**, **PO AMOUNT**, the PO remarks and delivery columns, **SHORT QTY**, **REJECTION QTY** and the debit note columns fill when **Document No.**, **Item Name** and **Pack / Size** are all ticked. When an item on a bill comes from several purchase orders, or has several debit notes, the quantities and amounts are added together and the dates, remarks, addresses and numbers are listed one after the other, separated by commas. **PO ORDER NO.**, **PO ORDER DATE** and **PO SUPPLIER ORDER NO.** need only **Document No.** and list every order on the bill. Purchases without a purchase order leave the purchase order columns blank.

To show item images and margins, see [**View Item Image and Margin in Purchase Register Detailed - Cross Tab**](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).

> **Example — an order with a rejection**
>
> Purchase order PO-88 is for 500 metres of cotton fabric at ₹120. Bill 2231 brings 400 metres against it, and 20 metres are rejected. A debit note RTN-15 is made for the 20 metres. Nothing else has been received against PO-88.

With **Document No.**, **Item Name** and **Pack / Size** ticked, the row of that item on bill 2231 shows:

| TOTAL QUANTITY | PO RATE  | PO QUANTITY | PO PENDING QUANTITY | PO AMOUNT | REJECTION QTY | DN DOC NO. | DN QTY |
| -------------- | -------- | ----------- | ------------------- | --------- | ------------- | ---------- | ------ |
| 400            | 120.0000 | 500         | 100                 | 60,000    | 20            | RTN-15     | 20     |

**PO PENDING QUANTITY** shows what is still pending on PO-88 today, so it changes as more is received against the order.

## Totals

Totals rows are switched on under **Report Totals**, **Item Totals** and **Period Totals** in the configuration — for example a total for each bill, party, branch, item or month, and a **Grand Total**. Their names appear in the first column of the report (under **VOUCHER DATE** when the first column is not a name, number or date column).

* Totals add up the quantities, amounts, taxes, charges, **SHORT QTY**, **REJECTION QTY** and every cross-tab column.
* Names, numbers, dates and rates are not totalled; **CONTRIBUTION(%)** and **DIFFERENCE(%)** are worked out again from the totals. The purchase order columns and **DN QTY** are not totalled, because an order received over several bills would be counted more than once.
* **Period Totals** print when **Period** or **Document No.** is ticked.
* **Txn Type Totals** decide which of the ticked figures appear on the totals rows.

## Good to know

* Ticking **Document No.** makes the periods date-wise, whatever **Period As** says.
* Zero values are shown as blanks.


---

# 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.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.
