Purchase Order Pending Item Report
The Purchase Order Pending Item Report provides complete visibility into purchase orders containing pending or partially received items.
It helps track supplier delivery progress, incoming stock, and item-level pending quantities across branches.
Navigation Path
- Open Back Office.
- Go to Reports.
- Select Order Reports.
- Click Purchase Order Pending Item Report.
- Alternatively, use the shortcut Alt + R to open Reports directly.
Filters Available in the Report
The following filters assist in narrowing down specific pending purchase orders:
Date Filters
- From Date
- To Date
Search Filters
- Number / Customer
- Search Product Name
Dropdown Filters
- Branch (All branches or specific branch)
- Order Status (All, Pending, Partially Received)
- Brand (All brands or selected brand)
Applying these filters automatically refreshes and loads relevant purchase order data.
Report Fields Overview
| Field | Description |
|---|---|
| Created On | The date the purchase order was created |
| Number | The purchase order reference number |
| Order Status | Indicates Pending / InProgress / Partially Received |
| Tracking Number | Supplier shipment or tracking reference |
| Line Items | Total number of product lines in the order |
| Total Items | Total quantity of items ordered in the PO |
| Supplier Name | Supplier associated with the purchase order |
| Item Name | Product included in the order |
| Ordered Qty | Quantity ordered from the supplier |
| Received Qty | Quantity already received |
| Pending Qty | Remaining quantity yet to be received |
| Branch / Channel | Branch where the purchase order belongs |
How to Use the Report
- The report loads with current-date data.
- Update the Start Date and End Date.
- Select filters such as Brand, Order Status, and Product Name.
- Review pending and partially received goods in item-wise layout.
Export Options
- Export All � Downloads the complete report
- Export Current Page � Downloads visible page data
- CSV Format � Ideal for Excel and third-party analytics
Benefits
- Tracks supplier delivery delays
- Highlights pending and partially received goods
- Prevents stockout situations
- Improves procurement accuracy
- Supports branch-wise purchase analysis