> 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/order-reports/purchase-order-status-report.md).

# Purchase Order Status Report

**YouTube:** [Purchase Order Status Report](https://youtu.be/Vk3sz1x0Ric)

**Available on:** Desktop · Web

Navigate to **Reports/Queries\Order Reports** and click on "Purchase Order Status Report".

The **Purchase Order Status Report** shows how each purchase order is being received: what was ordered, what has come in against it on purchase bills and purchase challans, at what rate, and how much is still pending. Use it to follow up suppliers on pending orders, to spot late deliveries, and to check that goods were billed at the ordered rate.

## Run the report

1. Choose a configuration (see [**Purchase Order Status Report - Configuration**](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/order-reports/purchase-order-status-report/purchase-order-status-report-configuration.md)).
2. Enter the **From** and **To** dates. These pick the **purchase orders** by their order date (or by their valid-till date, if the configuration says so). Everything received against those orders is shown, whatever the date it was received, as long as the purchase bill is in a financial year included in the report.
3. Select **Purchase Order**, **Purchase Voucher**, **Supplier**, **Item**, **Extra Item Groups**, **Branch** or **Transfer Branch** if needed. You can choose more than one of each. Leave them empty to include all.
4. Run the report.

Good to know about the selections:

* **Purchase Voucher** limits the purchase bills shown; it does not limit purchase challans.
* **Supplier** checks the order's supplier, or its transfer party when **Party Filter As** in the configuration is set to **Transfer Party**.
* **Branch** limits both the orders and the bills and challans shown.

Cancelled orders and cancelled order lines are left out.

## What one row stands for

Most rows are **receipt rows**: one item of a purchase order received on one purchase bill or purchase challan. The order columns (**ORDER QTY**, **ORDER AMOUNT**) are repeated on each receipt row of that item, and the receipt columns show what came in on that bill or challan.

**Report Type** in the configuration decides how far a receipt is split:

* **Lot Wise** — one row for each lot received, with **LOT NUMBER**, **LOT CODE** and **GODOWN NAME** filled.
* **Item Wise** — the lots of a bill or challan are added together into one row for the item, and the lot columns are left blank. A bill that carries the item at two different rates still gives two rows.

**Purchase Order Filter** in the configuration decides which orders appear:

* **Billed PO** — only the order items that have been received at least once.
* **All PO** — also adds a row for each order item that has not been received at all, with the full ordered quantity pending.
* **PO Only** — every order item, received or not, without any receipts.

## The main columns

Shown when the report opens:

| Column                                                                                        | Meaning                                                                                                                                                           |
| --------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **PO DATE**, **PO NUMBER**                                                                    | the purchase order                                                                                                                                                |
| **SUPPLIER NAME**                                                                             | the supplier on the order. The names of totals rows also appear here                                                                                              |
| **ITEM NAME**, **PACK/SIZE**, **COMPANY NAME**, **GROUP NAME**, **SHADE NAME**, **ITEM CODE** | the item                                                                                                                                                          |
| **ORDER QTY**                                                                                 | the quantity of the item ordered on this purchase order, all its order lines together                                                                             |
| **RATE**                                                                                      | the rate on the purchase order                                                                                                                                    |
| **ORDER AMOUNT**                                                                              | ordered quantity × order rate, before discount and tax                                                                                                            |
| **CUM AMOUNT**                                                                                | a running total of **ORDER AMOUNT** down the report, counting each order item once                                                                                |
| **RECEIPT DATE**, **RECEIPT QTY**, **RECEIPT AMOUNT**                                         | the date, quantity and amount (before tax) received on that purchase bill or challan                                                                              |
| **REJECTION QTY**, **REPLACEMENT QTY**, **SHORT QTY**, **RATE DIFF**, **RATE DIFF AMOUNT**    | rejections, replacements, short quantities and rate differences entered against the purchase. **RATE DIFF AMOUNT** is the received quantity × the rate difference |
| **LOT NUMBER**, **LOT CODE**, **GODOWN NAME**                                                 | the lot received and its godown — **Lot Wise** only                                                                                                               |
| **BILLED RATE**                                                                               | the rate on the purchase bill or challan                                                                                                                          |
| **ORDERED PACKS**, **RECEIVED PACKS**                                                         | the ordered and received quantities in packs                                                                                                                      |
| **VALID DATE**                                                                                | the date the purchase order is valid till                                                                                                                         |
| **VALID DATE - RECEIPT DATE**                                                                 | how many days after the valid date the goods were received. Blank when on time                                                                                    |

More columns are available and can be switched on in the report's column settings. The most used ones:

| Column                                                                                                                                          | Meaning                                                                                                                                                                                                                                                         |
| ----------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **PENDING QUANTITY**                                                                                                                            | the quantity still to be received. It counts down the receipt rows of an item, so the last row of the item shows what is still pending                                                                                                                          |
| **QUANTITY(%)**                                                                                                                                 | received quantity as a percentage of the ordered quantity                                                                                                                                                                                                       |
| **RATE - BILLED RATE**, **RATE(%)**                                                                                                             | the order rate less the billed rate, and the billed rate as a percentage of the order rate (100 means the same rate)                                                                                                                                            |
| **BILL NUMBER**, **GRN NO.**                                                                                                                    | the supplier's bill number on the purchase or challan (or its voucher number when no bill number was entered), and its GRN number                                                                                                                               |
| **GPN NUMBER**, **GPN DATE**                                                                                                                    | the gate pass of the purchase bill. For a challan row, the gate pass of the bill the challan was turned into                                                                                                                                                    |
| **PO DELIVERY DATE**, **SUPPLIER ORDER NO.**, **DEPARTMENT NAME**, **REMARKS**, **REMARKS-2**, **ITEM REMARKS**                                 | details entered on the purchase order                                                                                                                                                                                                                           |
| **TOTAL TAX**, **CGST AMOUNT**, **SGST AMOUNT**, **IGST AMOUNT**, **TOTAL DISCOUNT**, **TOTAL EXCISE**, **TOTAL OTHER VALUE**, **TOTAL OCTROI** | the tax and charges of the whole purchase order. **TOTAL DISCOUNT** shows as a minus figure                                                                                                                                                                     |
| **NET ORDER AMOUNT**                                                                                                                            | the item's order amount plus the tax and charges of the whole purchase order, less its discount                                                                                                                                                                 |
| **PO ADVANCES**, **ADVANCE AMOUNT**, **CHEQUE NO.**, **CHEQUE DATE**                                                                            | advances paid to the supplier against the purchase order. **PO ADVANCES** adds a **CASH AMOUNT(PO)** and a **BP AMOUNT(PO)** column; **ADVANCE AMOUNT** needs **PO ADVANCES** chosen as well. **CHEQUE NO.** and **CHEQUE DATE** list the bank payment advances |
| **PURCHASE DATE**, **PURCHASE QTY**, **PURCHASE AMOUNT**, **PURCHASE BILL NUMBER**, **PURCHASE BILL DATE**, **PURCHASE GRN NO.**                | for a challan row, the purchase bill the challan was later turned into. When it went into several bills, they are listed together, separated by commas                                                                                                          |
| **DNO NO.**, **DNO DATE**, **DNO QUANTITY**, **DNO PENDING QUANTITY**                                                                           | the delivery note the bill or challan was made against                                                                                                                                                                                                          |
| **BRANCH NAME**                                                                                                                                 | the branch of the order — only when **Branch Consolidation** is set to **Branch Wise**                                                                                                                                                                          |
| **CREDIT DAYS**                                                                                                                                 | the supplier's credit days                                                                                                                                                                                                                                      |

The rest cover further item details (description, finished item, additional item code and name, item name without shade, set details, order MRP, weight), more rate columns, net amounts, quotation, transfer party and transfer branch details, and the user who made the challan.

**TOTAL TAX**, **NET ORDER AMOUNT** and the other order-wide charges carry the value of the **whole order** on every item row of that order. On a totals row each order is counted only once.

> **Example — PO CH-15 from Sharma Textiles**
>
> The order is for 100 pieces of a shirt fabric at ₹50. On 5 August the supplier delivers 60 pieces on one bill, and on 12 August 30 more on another.

With **Report Type** set to **Item Wise**, **Qty CF** set to **Unit**, **PO Wise Total** ticked and **PENDING QUANTITY** switched on, the report shows two bill rows and a total:

| Row               | ORDER QTY | ORDER AMOUNT | RECEIPT QTY | PENDING QUANTITY |
| ----------------- | --------- | ------------ | ----------- | ---------------- |
| bill of 5 August  | 100       | 5,000        | 60          |                  |
| bill of 12 August | 100       | 5,000        | 30          |                  |
| PO Wise Total     | 100       | 5,000        | 90          | 10               |

The order quantity and amount repeat on each bill row, but the total counts them once. The two bill rows may be listed in either order; **PENDING QUANTITY** counts down as each one is read, so the first shows 40 or 70 and the second always shows 10 — the pieces still to come.

## Totals

**PO Wise Total**, **Branch Totals** and **Grand Totals** can be switched on under **Report Totals** in the configuration. **Branch Totals** print only when **Branch Consolidation** is set to **Branch Wise**. On a totals row the ordered quantity and amount are counted once per order item, the tax and charges once per order, and **PENDING QUANTITY** is the ordered total less the received total.

## Good to know

* Double-clicking a row does not open the purchase order or the bill behind it.
* **PO ADVANCES**, **CHEQUE NO.** and **CHEQUE DATE** show the advances of the financial year you are logged in to.
* When any **DNO** column is switched on, purchase challans not made against a delivery note are left out of the report.
* If the configuration has no columns chosen, the report shows "Configuration Chosen is Invalid".


---

# 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/order-reports/purchase-order-status-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.
