For the complete documentation index, see llms.txt. This page is also available as Markdown.

Purchase Order Status Report

YouTube: Purchase Order Status Report

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

  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, RATE DIFF, RATE DIFF AMOUNT

rejections, replacements 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".

Last updated