Purchase Order Line
- Code: PUR-POL
- Module: Purchasing
- Type: System Record
1. Overview
Purchase Items is a cross-PO summary that puts the ordered quantity of each Purchase Order (PO) item side by side with the quantity actually received, accumulated from all Goods Receipts (GR) referencing it. Goods received through a GR without a PO also appear in the same summary, without an ordered quantity to compare against. All of its content is generated by the system from PO and GR data; no data is created, edited, or deleted directly from here.
Expected outcome: the receiving progress of every ordered product is visible in one place across POs and stores, the remaining quantity still awaited is known without opening POs one by one, and over-deliveries are immediately visible.
2. Problem
Without this summary, finding out a product’s remaining quantity means opening its POs one by one and then manually adding up all the GRs that have received it. As a result:
- The remaining order per product is not visible across POs, so purchasing staff have to open each PO to confirm what is still awaited.
- Over-deliveries from suppliers are not easy to detect because there is no place that directly compares ordered and received quantities.
- Goods received without a PO are not recorded in any summary, so they are separated from the overall picture of goods receiving.
3. Goals & Non-goals
3.1 Goals
- The ordered, received, and remaining quantity of every item is visible in one place, filterable by store, supplier, PO, product, and status.
- Over-receiving is detected without manual calculation.
- Goods received without a PO are still recorded in the same summary, clearly separated from items that come from a PO.
3.2 Non-goals
- Creating, editing, or deleting data from here; all changes are made through Purchase Order and Goods Receipt.
- Being a document of its own with its own status and flow; this module is purely a derived view of PO and GR data.
4. Business Rules
Business rules are the set of provisions and constraints that apply to Purchase Items throughout the application, on every screen and action that involves it, whoever performs it. These rules are the single source of truth: if another part of this PRD appears to differ, the rules here prevail.
- BR-01 One Purchase Items row represents one PO item, or one GR item received without referencing any PO.
- BR-02 On rows that come from a GR item without a PO, all order-side fields — ordered quantity, remaining quantity, ordered price, and order status — are empty, because there is no order to compare against.
- BR-03 The received quantity is the accumulated received quantity from all GRs in Submitted or Closed status that reference that item. GRs in Draft and Cancelled status are not counted.
- BR-04 The remaining quantity is calculated as the ordered quantity minus the received quantity, at least 0. A received quantity that exceeds the ordered quantity is marked as over-received, not as a negative remaining value.
- BR-05 The receiving status is determined by comparing the received quantity with the ordered quantity: Not Received if nothing has been received, Partially Received if less than the ordered quantity, Fully Received if equal to or more than the ordered quantity on rows that come from a PO item, or Received on rows that come from a GR item without an order to compare against.
- BR-06 The order status follows the status of the PO that contains the item, and is empty on rows that come from a GR item without a PO.
- BR-07 Data in this module cannot be created, edited, or deleted directly; all of its content is determined by changes to Purchase Orders and Goods Receipts.
5. Flow
5.1 Main Flowchart
- PO Submitted — From the moment a PO is submitted, each of its items is available as a Purchase Items row with the ordered quantity filled in and the received quantity at 0.
- Row Formed — A row is also formed for each GR item received without referencing a PO, without an ordered quantity to compare against (BR-02).
- Quantities Updated — Every time a GR referencing this row is submitted or cancelled, the received quantity, remaining quantity, and receiving status are recalculated (BR-03, BR-04, BR-05).
This feature has no status of its own; the statuses shown follow the PO status and the receiving status derived from it, so there is no separate Status Lifecycle.
6. Document Structure
This section defines the content of each Purchase Items row: which fields it has and where they come from. All fields are set by the system and derived from PO and GR data, not filled in by users.
6.1 General
| Field | Type | Required | Default | Rules |
|---|---|---|---|---|
| Store | Ref. Store | — | — | Set by the system, follows the PO’s store or the GR’s store |
| Supplier | Ref. Supplier | — | — | Set by the system, follows the PO’s supplier or the GR’s supplier |
| PO Number | Ref. PO | — | — | Set by the system; empty on GR items without a PO (BR-02) |
| Order Date | Date | — | — | Set by the system; empty on GR items without a PO (BR-02) |
| Product (Package) | Ref. Store Product Inventory | — | — | Set by the system |
| Measurement Unit | Text | — | — | Set by the system, follows the package |
| Ordered Quantity | Decimal | — | — | Set by the system, from the PO item; empty on GR items without a PO (BR-02) |
| Received Quantity | Decimal | — | 0 | Set by the system, accumulated from GRs (BR-03) |
| Remaining Quantity | Decimal | — | — | Set by the system (BR-04); empty on GR items without a PO (BR-02) |
| Ordered Price | Currency | — | — | Set by the system, from the PO item; empty on GR items without a PO (BR-02) |
| Order Status | Enum | — | — | Set by the system (BR-06); empty on GR items without a PO (BR-02) |
| Receiving Status | Enum | — | Not Received | Set by the system (BR-05) |
| Receiving Progress | Percent | — | — | Set by the system, received quantity divided by ordered quantity; empty on GR items without a PO (BR-02) |
| First Receipt Date | Date | — | — | Set by the system, from the first submitted GR; empty if there is no receipt yet |
| Goods Receipts | Object, multiple | — | — | Set by the system; the list of GRs referencing this item along with their sent, rejected, and received quantities and status |
7. UI Structure
This section defines how Purchase Items are displayed: the list columns and filters. This section only governs display; content and value rules still follow Document Structure.
7.1 Datatable
| Column | Sortable | Sample Value | Component |
|---|---|---|---|
| Expand Toggle | — | — | Expand Toggle |
| No | — | 1 | Number |
| Store | — | Cianjur Store | Text |
| Supplier | — | PT Sumber Rejeki | Text |
| PO Number | — | PO/CBI/2026/000042 | Link, empty if without a PO |
| PO Date | — | 20 Sep 2026 | Date, empty if without a PO |
| Product Code | — | SKU-0012 | Text |
| Product (Package) | — | Cooking Oil 2L (Carton) | Thumbnail, Text |
| Measurement Unit | — | Carton | Text |
| Ordered Quantity | — | 10 | Number, empty if without a PO |
| Received Quantity | — | 9 | Number |
| Remaining Quantity | — | 1 | Number, empty if without a PO |
| Ordered Price | — | Rp 250,000 | Currency, empty if without a PO |
| Order Status | — | Submitted | Badge, empty if without a PO |
| Receiving Status | — | Partially Received | Badge |
| Receiving Progress | — | 90% | Progress Bar, empty if without a PO |
There is no Select or Actions column — rows cannot be bulk selected and have no actions at all (BR-07).
Expanded Row
The list of Goods Receipts referencing this item.
| Column | Sample Value | Component |
|---|---|---|
| GR Number | GR/CBI/2026/000042 | Link |
| GR Date | 23 Sep 2026 | Date |
| Sent Quantity | 10 | Number |
| Rejected Quantity | 1 | Number |
| Received Quantity | 9 | Number |
| Status | Submitted | Badge |
Empty, with a message that there are no goods receipts for this item yet, if no GR references the item.
7.2 Advance Filter
| Field | Control | Options Source | Default |
|---|---|---|---|
| Store | Multi Select | Stores assigned to the user | Active store |
| Supplier | Multi Select | Supplier master, searchable | Empty |
| Purchase Order | Multi Select | POs of the selected stores in any status other than Draft, searchable | Empty |
| Product | Multi Select | Product master, searchable | Empty |
| PO Date Range | Date Range Picker | — | Empty |
| First Receipt Date Range | Date Range Picker | — | Empty |
| Order Status | Multi Select | Order status enum | Empty |
| Receiving Status | Multi Select | Receiving status enum | Empty |
8. User Stories
US-01 - View receiving progress across POs
As purchasing staff, I want to see the ordered, received, and remaining quantity of each purchase item, so that I know what is still awaited without opening each PO.
| ID | Acceptance criteria |
|---|---|
| AC-01.1 | By default, the active store’s items are shown; advanced filters: store, supplier, PO, product, PO date range, first receipt date range, order status, and receiving status; keyword search. |
| AC-01.2 | Columns: store, supplier, PO number, PO date, product code, product, measurement unit, ordered quantity, received quantity, remaining quantity, ordered price, order status, receiving status, and receiving progress. |
| AC-01.3 | Items that come from a GR without a PO show the PO number, PO date, ordered quantity, remaining quantity, ordered price, order status, and receiving progress columns as empty (BR-02). |
US-02 - Trace an item’s receipts
As purchasing staff, I want to see all GRs that make up an item’s received quantity, so that I can trace the origin of each receipt.
| ID | Acceptance criteria |
|---|---|
| AC-02.1 | Rows can be expanded to show the list of GRs referencing the item, along with their sent, rejected, and received quantities and status (BR-03). |
| AC-02.2 | Items without any receipt show a note that there are no goods receipts yet when the row is expanded. |
US-03 - Detect over-receiving
As purchasing staff, I want items received beyond the ordered quantity to be clearly visible, so that they can be followed up with the supplier.
| ID | Acceptance criteria |
|---|---|
| AC-03.1 | Items whose received quantity exceeds the ordered quantity show a receiving progress above 100% and a remaining quantity of 0, not a negative value (BR-04). |
US-04 - View goods received without a PO
As purchasing staff, I want goods received without an order to still be recorded in the same summary, so that all goods receiving is visible in full.
| ID | Acceptance criteria |
|---|---|
| AC-04.1 | Items that come from a GR without a PO appear with the receiving status Received, without an order status (BR-02, BR-05). |
9. User Scenarios
| Role | Scenario |
|---|---|
| Purchasing Staff | Filters by PO to check the remaining quantity before creating a follow-up GR for a supplier that delivers in stages |
| Owner | Filters the Partially Received status across stores to monitor suppliers that often deliver less than ordered |
| Purchasing Staff | Finds items with progress above 100% to confirm an over-delivery with the supplier |
10. Permissions & Actions
10.1 Permission by Action
| Action | Permission | Condition |
|---|---|---|
| View Purchase Items List (All Stores) | purchase:purchase-order-line:list:any | — |
| View Purchase Items List (Assigned Stores) | purchase:purchase-order-line:list:store | — |
11. Notifications
This feature does not trigger any notifications.
12. Dependencies
Related PRDs
- Purchase Order — the source of each item’s ordered quantity and price (BR-02, BR-06).
- Goods Receipt — the source of the received quantity, accumulated per item (BR-03).
Master data
- Stores — the active store and the stores assigned to the user.
- Suppliers — the supplier data of each item.
- Products & Product Inventory — packages, measurement units, and barcodes.