Skip to content

Purchase Management

Purchase Management

Manage procurement of educational supplies, lab equipment, library books, IT equipment, furniture, and other institutional needs through a streamlined purchasing workflow.

Time Required: 20-30 minutes (initial setup), 5-10 minutes (per order) Module: Purchase User Role: Purchase Manager, Procurement Officer


Table of Contents

  1. Before You Begin
  2. Understanding Purchase Workflow
  3. Configure Products for Purchasing
  4. Set Up Vendor Pricelists
  5. Create a Request for Quotation
  6. Send RFQ to Vendor
  7. Confirm Purchase Order
  8. Receive Products
  9. Manage Vendor Bills
  10. Purchase Agreements (Blanket Orders)
  11. Call for Tenders
  12. Reordering Rules
  13. Purchase Analysis Reports
  14. Field Reference
  15. Troubleshooting
  16. Related Topics

Before You Begin

Ensure you have:

  • Purchase module installed and enabled
  • Inventory module installed (for stock tracking)
  • Accounting module installed (for vendor bills)
  • Purchase Manager or Procurement Officer role assigned
  • Vendor contacts created in the Contacts app
  • Products configured as purchasable items

Common Educational Purchases

CategoryExamples
Lab EquipmentMicroscopes, chemicals, beakers, safety equipment
Library MaterialsTextbooks, journals, reference books, e-resources
IT EquipmentComputers, projectors, tablets, networking gear
FurnitureDesks, chairs, storage cabinets, laboratory benches
StationeryPaper, pens, markers, folders, printing supplies
Sports EquipmentBalls, nets, gymnasium equipment, uniforms
Classroom SuppliesWhiteboards, markers, teaching aids, craft materials

Understanding Purchase Workflow

The purchase process in OpenEduCat follows a structured workflow:

Product Need Identified
|
v
Create Request for Quotation (RFQ)
|
v
Send RFQ to Vendor(s)
|
v
Receive Vendor Response
|
v
Confirm Purchase Order (PO)
|
v
Receive Products
|
v
Create and Pay Vendor Bill

Purchase Order Stages

StageDescriptionStatus
DraftRFQ created but not sentRFQ
RFQ SentQuotation sent to vendor, awaiting responseRFQ Sent
To ApproveAwaiting approval (if approval workflow enabled)To Approve
Purchase OrderOrder confirmed with vendorPurchase Order
DoneProducts received and billedDone
CancelledOrder cancelledCancelled

Configure Products for Purchasing

Before creating purchase orders, products must be configured as purchasable items.

Step 1: Navigate to Products

  1. Go to Purchase in the main menu
  2. Click Products > Products
  3. Click Create for a new product, or select an existing product

Step 2: Enable Purchasing

FieldActionExample
Product NameEnter descriptive name”Laboratory Microscope - 40x”
Can be PurchasedCheck this boxEnabled
Product TypeSelect type”Storable Product”

Step 3: Configure Purchase Tab

In the Purchase tab:

FieldDescriptionExample
VendorDefault vendor for this product”Lab Equipment Suppliers Ltd”
Vendor Product CodeVendor’s SKU/code”MIC-40X-BIO”
PriceUnit purchase price2500.00
Delivery Lead TimeDays to receive after order7

Step 4: Configure Inventory Settings

In the Inventory tab (if using Inventory module):

FieldActionExample
RoutesEnable “Buy” routeBuy
Track InventoryEnable for stock trackingBy Unique Serial Number

Click Save to store the product configuration.


Set Up Vendor Pricelists

Configure vendor-specific pricing for products to auto-populate prices on purchase orders.

Step 1: Access Vendor Pricelists

  1. Go to Purchase > Configuration > Vendor Pricelists
  2. Click New to create a new pricelist entry

Step 2: Configure Pricelist Entry

FieldRequiredDescriptionExample
VendorYesSelect vendor”ABC Office Supplies”
ProductYesSelect product”A4 Paper Ream”
QuantityNoMinimum order quantity10
Unit PriceYesPrice per unit150.00
Start DateNoPrice validity start2026-01-01
End DateNoPrice validity end2026-12-31
Delivery Lead TimeNoDays to deliver3

Step 3: Add Multiple Vendors per Product

For competitive pricing, add multiple vendors for the same product:

Example - A4 Paper Ream:

VendorQuantityUnit PriceLead Time
ABC Office Supplies1160.003 days
ABC Office Supplies50145.003 days
XYZ Stationery1155.005 days
XYZ Stationery100140.005 days

Click Save after adding each pricelist entry.


Create a Request for Quotation

A Request for Quotation (RFQ) is the first step in the purchasing process.

Step 1: Navigate to RFQ Dashboard

  1. Go to Purchase > Orders > Requests for Quotation
  2. Click New to create a new RFQ

Step 2: Fill Header Information

FieldRequiredDescriptionExample
VendorYesSelect supplier”Science Lab Equipment Co.”
Vendor ReferenceNoVendor’s reference number”QUOTE-2026-001”
Order DeadlineNoDate vendor must confirm by2026-01-15
Expected ArrivalAutoCalculated from lead times2026-01-22
Deliver ToYesReceiving warehouse”Main Warehouse”

Step 3: Add Products

In the Products tab, click Add a product and fill:

FieldRequiredDescriptionExample
ProductYesSelect product”Digital Microscope”
DescriptionAutoProduct descriptionAuto-filled
QuantityYesOrder quantity10
UoMAutoUnit of measure”Units”
Unit PriceAuto/ManualPrice per unit3500.00
TaxesAutoApplicable taxes”GST 18%“
SubtotalAutoLine total35,000.00

Educational Context Example - Science Lab Order:

ProductQuantityUnit PriceSubtotal
Digital Microscope103,500.0035,000.00
Petri Dishes (Pack of 100)5800.004,000.00
Safety Goggles50150.007,500.00
Lab Coats50450.0022,500.00
Total69,000.00

Step 4: Add Additional Information (Optional)

Click the Other Information tab:

FieldDescriptionExample
BuyerPerson responsible”John Smith”
Source DocumentReference to original request”DEPT-REQ-2026-042”
IncotermShipping terms”Delivered at Place (DAP)“
Payment TermsPayment conditions”30 Days Net”

Click Save to create the RFQ as a draft.


Send RFQ to Vendor

After creating the RFQ, send it to the vendor to request pricing and availability.

Step 1: Review the RFQ

Before sending, verify:

  • Correct vendor selected
  • All products and quantities accurate
  • Expected arrival date acceptable
  • Contact email configured for vendor

Step 2: Send by Email

  1. Click Send by Email button
  2. A compose email window appears with pre-filled template
  3. Review and customize the message if needed
  4. Click Send

The RFQ status changes from RFQ to RFQ Sent.

Step 3: Alternative - Print RFQ

  1. Click Print RFQ to generate a PDF
  2. Download or print the document
  3. Send manually via fax, courier, or hand-delivery

Confirm Purchase Order

Once the vendor confirms the quotation, convert it to a Purchase Order.

Step 1: Update Vendor Information

If the vendor provides updated pricing or lead times:

  1. Open the RFQ from Purchase > Orders > Requests for Quotation
  2. Update unit prices, quantities, or expected dates as needed
  3. Click Save

Step 2: Confirm the Order

  1. Click Confirm Order button
  2. The RFQ converts to a Purchase Order (PO)
  3. Status changes to Purchase Order

Step 3: Verify Confirmation Details

After confirmation, review:

FieldDescription
Confirmation DateDate and time order was confirmed
Order ReferenceUnique PO number (e.g., PO00001)
ReceiptSmart button showing expected receipts

Receive Products

When products arrive, record the receipt to update inventory.

Step 1: Access the Receipt

From the Purchase Order:

  1. Click the Receipt smart button
  2. Or navigate to Inventory > Operations > Receipts

Step 2: Validate Receipt

ActionDescription
ValidateConfirm all products received as ordered
Edit QuantitiesAdjust if partial delivery received
Set Done QuantitiesClick to match ordered quantities

Step 3: Handle Partial Receipts

If only some products are received:

  1. Edit the Done quantity for each product
  2. Click Validate
  3. Choose No Backorder or Create Backorder
OptionWhen to Use
No BackorderRemaining items will not be delivered
Create BackorderRemaining items expected in future delivery

Step 4: Complete Receipt

  1. Click Validate to confirm receipt
  2. Inventory quantities are updated automatically
  3. Receipt status changes to Done

Manage Vendor Bills

Create and pay vendor bills for received products.

Bill Control Policies

Products can be configured with different billing policies:

PolicyDescriptionBest For
On Ordered QuantitiesBill created when order confirmedServices, prepaid items
On Received QuantitiesBill created after products receivedPhysical goods

Step 1: Create Bill from Purchase Order

  1. Open the confirmed Purchase Order
  2. Click Create Bill button
  3. A draft vendor bill is created

Step 2: Enter Bill Details

FieldRequiredDescriptionExample
Bill DateYesInvoice date from vendor2026-01-20
Bill ReferenceNoVendor’s invoice number”INV-2026-0042”
Due DateAutoPayment due date2026-02-19
Payment TermsAutoFrom vendor settings”30 Days Net”

Step 3: Verify Invoice Lines

Review that all lines match the vendor’s invoice:

FieldDescription
ProductShould match ordered items
QuantityShould match received quantities
Unit PriceShould match vendor invoice
AmountTotal per line

Step 4: Confirm and Pay

  1. Click Confirm to post the bill
  2. Click Register Payment to record payment
  3. Select payment method and journal
  4. Click Create Payment

3-Way Matching

Enable 3-way matching to ensure bills are only paid when:

  1. Purchase Order exists (what was ordered)
  2. Receipt completed (what was received)
  3. Vendor Bill received (what is being charged)

To enable:

  1. Go to Purchase > Configuration > Settings
  2. Enable 3-way matching under Invoicing section
  3. Click Save

Purchase Agreements (Blanket Orders)

For recurring purchases from the same vendor, set up blanket orders to lock in pricing and terms.

When to Use Blanket Orders

ScenarioExample
Annual contractsYearly stationery supply agreement
Bulk discountsNegotiated pricing for 500+ textbooks
Recurring needsMonthly lab supplies replenishment
Budget planningPre-approved spending limits

Step 1: Enable Purchase Agreements

  1. Go to Purchase > Configuration > Settings
  2. Enable Purchase Agreements under Orders section
  3. Click Save

Step 2: Create Blanket Order

  1. Go to Purchase > Orders > Purchase Agreements
  2. Click New
  3. Fill the agreement form:
FieldRequiredDescriptionExample
VendorYesSupplier for agreement”National Book Distributors”
BuyerAutoResponsible personCurrent user
Agreement TypeYesSelect Blanket Order”Blanket Order”
Agreement ValidityNoValid date range2026-01-01 to 2026-12-31
CurrencyAutoPayment currencyINR

Step 3: Add Products and Pricing

In the Products section, add items with negotiated prices:

ProductQuantityUnit PriceNotes
Textbook - Mathematics Grade 10500350.00Annual requirement
Textbook - Science Grade 10500400.00Annual requirement
Notebooks (Pack of 10)1000180.00Quarterly orders

Click Confirm to activate the agreement.

Step 4: Create Orders from Blanket Order

  1. Open the blanket order
  2. Click New Quotation
  3. A new RFQ is created with pre-filled products and prices
  4. Adjust quantities as needed
  5. Confirm the order

Call for Tenders

Request quotes from multiple vendors to compare pricing and select the best offer.

When to Use Tenders

ScenarioExample
Large purchasesNew computer lab equipment
Price comparisonAnnual stationery contract
Policy requirementGovernment/institution mandates
New vendorsEvaluating potential suppliers

Step 1: Create Initial RFQ

  1. Go to Purchase > Orders > Requests for Quotation
  2. Create RFQ for the first vendor
  3. Add all required products
  4. Click Save (do not confirm yet)

Step 2: Create Alternative RFQs

  1. In the RFQ, click the Alternatives tab
  2. Click Create Alternative
  3. Select a different vendor
  4. Check Copy Products to include same items
  5. Click Create Alternative
  6. Repeat for additional vendors

Step 3: Send All RFQs

For each RFQ in the Alternatives tab:

  1. Click on the RFQ reference
  2. Click Send by Email
  3. Return to alternatives and repeat

Step 4: Compare Quotations

Once vendors respond:

  1. Open any linked RFQ
  2. Click the Alternatives tab
  3. Click Compare Product Lines
  4. View side-by-side comparison:
ProductVendor AVendor BVendor C
Desktop Computer45,00042,50044,000
Monitor 24”12,00013,50011,800
Keyboard + Mouse1,5001,2001,400
Total58,50057,20057,200

Step 5: Select Best Offers

  1. Click Choose for preferred product lines
  2. Products can be mixed from different vendors
  3. Navigate back to RFQs
  4. Confirm selected orders
  5. Cancel or keep alternatives as needed

Reordering Rules

Automate purchase orders when stock falls below minimum levels.

Step 1: Configure Product for Reordering

  1. Open the product form
  2. In Inventory tab, ensure:
    • Product Type is “Storable Product”
    • Track Inventory is enabled
    • Routes includes “Buy”

Step 2: Create Reordering Rule

  1. On the product form, click Reordering Rules smart button
  2. Click Create
  3. Configure the rule:
FieldRequiredDescriptionExample
LocationYesStock location”Main Warehouse/Stock”
Min QuantityYesTrigger level50
Max QuantityYesReorder target200
Multiple QuantityNoOrder in multiples25
UnitAutoUnit of measureUnits

Step 3: Automatic RFQ Generation

When stock falls below minimum:

  1. Scheduler runs daily (or manually triggered)
  2. RFQ created automatically for configured vendor
  3. Quantity calculated to reach max level
  4. Review and confirm as normal

Example - Stationery Reordering:

ProductMinMaxCurrentAuto-Order
A4 Paper Reams5020045155 units
Ballpoint Pens10050080420 units
Staplers105012No order

Purchase Analysis Reports

Monitor purchasing performance with built-in reports.

Access Purchase Reports

  1. Go to Purchase > Reporting > Purchase
  2. Select view type: Graph, Pivot, or List

Available Measures

MeasureDescription
# of LinesTotal order lines across all POs
Average CostAverage cost of purchase orders
Days to ConfirmTime from RFQ to PO confirmation
Days to ReceiveTime from PO to product receipt
Qty OrderedTotal quantity ordered
Qty ReceivedTotal quantity received
Qty to be BilledQuantity pending invoicing
TotalTotal spend including taxes
Untaxed TotalTotal spend excluding taxes

Common Analysis Examples

1. Vendor Performance Analysis

  • Group by: Vendor
  • Measure: Days to Receive
  • Purpose: Identify fastest/slowest suppliers

2. Monthly Spending Trends

  • Group by: Confirmation Date (Month)
  • Measure: Total
  • Purpose: Track procurement spending over time

3. Department-wise Purchases

  • Filter by: Source Document (department codes)
  • Measure: Untaxed Total
  • Purpose: Budget monitoring per department

4. Product Category Analysis

  • Group by: Product Category
  • Measure: Qty Ordered
  • Purpose: Identify most purchased categories

Field Reference

Purchase Order Fields

Field NameTechnical NameTypeRequiredDescription
Vendorpartner_idMany2oneYesSupplier contact
Vendor Referencepartner_refCharNoVendor’s reference
Order Deadlinedate_orderDatetimeNoConfirmation deadline
Expected Arrivaldate_plannedDatetimeAutoCalculated arrival date
Currencycurrency_idMany2oneAutoOrder currency
Deliver Topicking_type_idMany2oneYesReceiving operation
Source DocumentoriginCharNoReference to source
Payment Termspayment_term_idMany2oneNoPayment conditions
Buyeruser_idMany2oneAutoResponsible user
StatusstateSelectionAutoOrder stage

Purchase Order Line Fields

Field NameTechnical NameTypeRequiredDescription
Productproduct_idMany2oneYesOrdered product
DescriptionnameTextAutoProduct description
Quantityproduct_qtyFloatYesOrder quantity
Unit of Measureproduct_uomMany2oneAutoUoM
Unit Priceprice_unitFloatYesPrice per unit
Taxestaxes_idMany2manyAutoApplicable taxes
Subtotalprice_subtotalFloatAutoLine total

Purchase Order Statuses

StatusTechnical ValueDescription
RFQdraftDraft quotation
RFQ SentsentQuotation sent to vendor
To Approveto approvePending approval
Purchase OrderpurchaseConfirmed order
DonedoneCompleted
CancelledcancelCancelled order

Troubleshooting

”Cannot confirm order - No product selected”

Problem: Confirm button fails with no products error.

Solutions:

  1. Ensure at least one product line is added
  2. Check product quantities are greater than zero
  3. Verify products are saved (not in edit mode)

“Product not available for purchase”

Problem: Product doesn’t appear in product dropdown.

Solutions:

  1. Open product form and enable Can be Purchased checkbox
  2. Ensure product is not archived
  3. Check user has access to the product

”Expected arrival date in the past”

Problem: Warning about past expected arrival.

Solutions:

  1. Update the Order Deadline to a future date
  2. Check vendor lead times in product configuration
  3. Manually adjust Expected Arrival date

”No vendor defined for product”

Problem: Price not auto-filling when adding products.

Solutions:

  1. Add vendor pricelist for the product
  2. Configure default vendor in product’s Purchase tab
  3. Manually enter price on the order line

”Cannot create bill - Nothing to bill”

Problem: Create Bill button shows error.

Solutions:

  1. Verify products have been received (check Receipt)
  2. Check product Bill Control Policy is “On received quantities”
  3. Ensure ordered quantities match received quantities

”3-way matching exception”

Problem: Bill shows “Should Be Paid: Exception”.

Solutions:

  1. Verify bill quantities match received quantities
  2. Check prices match the purchase order
  3. Review any modifications made to the draft bill
  4. Override manually if discrepancy is valid

”Reordering rule not triggering”

Problem: Stock is below minimum but no RFQ created.

Solutions:

  1. Run scheduler manually: Inventory > Operations > Run Scheduler
  2. Verify product has “Buy” route enabled
  3. Check reordering rule is not archived
  4. Ensure vendor is configured for the product

Best Practices for Educational Institutions

Procurement Planning

PeriodActivity
AnnualReview blanket orders, negotiate new contracts
QuarterlyAnalyze spending, adjust reordering rules
MonthlyReview pending orders, check delivery schedules
WeeklyProcess RFQs, follow up on delayed orders

Vendor Management

  1. Maintain vendor database - Keep contact information current
  2. Track performance - Monitor delivery times and quality
  3. Diversify suppliers - Avoid single-vendor dependency
  4. Regular reviews - Annual vendor performance evaluation

Budget Control

  1. Set approval limits - Require approval for large purchases
  2. Use blanket orders - Pre-negotiate pricing for budgeted items
  3. Monitor spending - Regular reports by department/category
  4. Track commitments - Include open POs in budget planning

Academic Calendar Alignment

PeriodFocus Areas
Pre-Session (2 months before)Textbooks, course materials, lab supplies
Session StartStationery, uniforms, IT equipment
Mid-SessionMaintenance supplies, replacement items
Session EndInventory audit, next session planning
VacationMajor equipment, furniture, renovations


Last updated: January 2026