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
Choose a configuration (see Purchase Order Status Report - Configuration).
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.
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.
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:
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:
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:
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