Skip to Content
Tenant BackofficePurchasingPurchase Order Line

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

  1. 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.
  2. 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).
  3. 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

FieldTypeRequiredDefaultRules
StoreRef. Store——Set by the system, follows the PO’s store or the GR’s store
SupplierRef. Supplier——Set by the system, follows the PO’s supplier or the GR’s supplier
PO NumberRef. PO——Set by the system; empty on GR items without a PO (BR-02)
Order DateDate——Set by the system; empty on GR items without a PO (BR-02)
Product (Package)Ref. Store Product Inventory——Set by the system
Measurement UnitText——Set by the system, follows the package
Ordered QuantityDecimal——Set by the system, from the PO item; empty on GR items without a PO (BR-02)
Received QuantityDecimal—0Set by the system, accumulated from GRs (BR-03)
Remaining QuantityDecimal——Set by the system (BR-04); empty on GR items without a PO (BR-02)
Ordered PriceCurrency——Set by the system, from the PO item; empty on GR items without a PO (BR-02)
Order StatusEnum——Set by the system (BR-06); empty on GR items without a PO (BR-02)
Receiving StatusEnum—Not ReceivedSet by the system (BR-05)
Receiving ProgressPercent——Set by the system, received quantity divided by ordered quantity; empty on GR items without a PO (BR-02)
First Receipt DateDate——Set by the system, from the first submitted GR; empty if there is no receipt yet
Goods ReceiptsObject, 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

ColumnSortableSample ValueComponent
Expand Toggle——Expand Toggle
No—1Number
Store—Cianjur StoreText
Supplier—PT Sumber RejekiText
PO Number—PO/CBI/2026/000042Link, empty if without a PO
PO Date—20 Sep 2026Date, empty if without a PO
Product Code—SKU-0012Text
Product (Package)—Cooking Oil 2L (Carton)Thumbnail, Text
Measurement Unit—CartonText
Ordered Quantity—10Number, empty if without a PO
Received Quantity—9Number
Remaining Quantity—1Number, empty if without a PO
Ordered Price—Rp 250,000Currency, empty if without a PO
Order Status—SubmittedBadge, empty if without a PO
Receiving Status—Partially ReceivedBadge
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.

ColumnSample ValueComponent
GR NumberGR/CBI/2026/000042Link
GR Date23 Sep 2026Date
Sent Quantity10Number
Rejected Quantity1Number
Received Quantity9Number
StatusSubmittedBadge

Empty, with a message that there are no goods receipts for this item yet, if no GR references the item.

7.2 Advance Filter

FieldControlOptions SourceDefault
StoreMulti SelectStores assigned to the userActive store
SupplierMulti SelectSupplier master, searchableEmpty
Purchase OrderMulti SelectPOs of the selected stores in any status other than Draft, searchableEmpty
ProductMulti SelectProduct master, searchableEmpty
PO Date RangeDate Range Picker—Empty
First Receipt Date RangeDate Range Picker—Empty
Order StatusMulti SelectOrder status enumEmpty
Receiving StatusMulti SelectReceiving status enumEmpty

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.

IDAcceptance criteria
AC-01.1By 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.2Columns: 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.3Items 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.

IDAcceptance criteria
AC-02.1Rows 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.2Items 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.

IDAcceptance criteria
AC-03.1Items 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.

IDAcceptance criteria
AC-04.1Items 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

RoleScenario
Purchasing StaffFilters by PO to check the remaining quantity before creating a follow-up GR for a supplier that delivers in stages
OwnerFilters the Partially Received status across stores to monitor suppliers that often deliver less than ordered
Purchasing StaffFinds items with progress above 100% to confirm an over-delivery with the supplier

10. Permissions & Actions

10.1 Permission by Action

ActionPermissionCondition
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.
Last updated on