Unseal commercial bids and compute total score
Unseal financial proposals of qualified bidders, check arithmetic errors, compute price scores, and determine combined ranking.
1. Overview & Business Value#
This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Unseal commercial bids and compute total score within SmartERP.


This guide explains how to unseal commercial bids and compute final composite scores.
2. Prerequisites & Security Access Groups#
- Required Modules:
purchase, stock, smarterp_store_voucher, purchase_requisition - Security Groups:
Purchase User(Technical ID:purchase.group_purchase_user)Purchase Administrator(Technical ID:purchase.group_purchase_manager)Inventory User / Storekeeper(Technical ID:stock.group_stock_user)
- Master Data Dependencies: Product masters, units of measure, approved supplier catalog, warehouse storage locations, and procurement budget lines.
3. Step-by-Step Configuration & Execution#
Step 1: Navigating to the Interface#
- Log into your SmartERP instance at
https://smarterp.et/odoo. - Open the main App Switcher (grid icon in the top-left corner).
- Navigate to Purchase → Tenders → Financial Opening.

Step 2: Operational Data Parameters & Controls#
Verify that mandatory and statutory fields are populated in accordance with enterprise policies:
- Designated Authority / Actor: Operating under verified RBAC role (Evaluation Committee, Sourcing Director, Finance Director).
- Associated Transactional Documents: Bound to upstream requisition, tender package, or purchase order contracts.
- Statutory Regulatory Validation: Strict adherence to Ethiopian Public Procurement Guidelines, Customs declarations, or Ministry of Revenue tax rules (VAT Proclamation 1157/2019, Withholding Proclamation 979/2016).
Step 3: Transactional Execution & State Progression#
- State Transition Gate: Progress the operational state from Draft through Audited to Confirmed / Posted.
- Double-Entry Financial Impact: Validated transactions automatically generate immutable accounting journal entries (
account.move) or stock move quant records (stock.move.line). - Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.
Unsealing Procedure#
- Open the tender in state
Technical Evaluation Complete. - Click Unseal Commercial Envelopes. SmartERP decrypts Financial Envelope 2 only for bidders who achieved the technical qualification threshold.
- Inspect lines for arithmetic errors:
- SmartERP recomputes $\text{Quantity} \times \text{Unit Price} = \text{Line Total}$.
- If discrepancy exists between unit price and line total, Ethiopian procurement law establishes that the unit price prevails.
- Click Confirm Arithmetic Verification.
Composite Evaluation Scoring Formula#
SmartERP supports two primary evaluation methods:
- Least-Cost Method: Awarded to the technically qualified bidder offering the lowest commercial price.
- Quality & Cost-Based Selection (QCBS): Combined technical and financial scoring (e.g. 80% Technical, 20% Financial):
$$\text{Financial Score} = \left( \frac{P_{\text{min}}}{P_{\text{bid}}} \right) \times 100$$
$$\text{Combined Score} = (S_{\text{tech}} \times W_{\text{tech}}) + (S_{\text{fin}} \times W_{\text{fin}})$$
Where $P_{\text{min}}$ is the lowest responsive bid price and $P_{\text{bid}}$ is the evaluated bidder's price.
4. Advanced Configuration Points#
- Automated Actions & Scheduled Tasks (Crons):
Procurement: Run scheduler (reordering rules)(stock.ir_cron_run_procurement): Runs daily to generate RFQs for inventory items below safety stockStock: Expired lot quarantine trigger(stock.ir_cron_quarantine_expired): Runs daily to isolate batches past shelf lifePurchase: Check supplier delivery deadlines(purchase.ir_cron_check_deadlines): Runs daily to send automated expediting notices to suppliers
- Custom Print Templates & Reports:
- Purchase Order Confirmation (Commercial Contract)
- Ethiopian Goods Receiving Note (GRN / Model 19)
- Store Issue Voucher (SIV / Model 20)
- Vendor Bid Evaluation & Comparison Matrix
- Multi-Company Rules: Record-level security isolation under Company 1 (
Ashewa Technology Solutions S.C.), preventing cross-company ledger leakage across parent and subsidiary legal entities.
5. Comprehensive Troubleshooting Matrix#
| Error Symptom / Exception | Probable Root Cause | Corrective Action / Resolution |
|---|---|---|
Access Rights Error: Cannot confirm Purchase Order | User lacks purchase manager approval privileges. | Escalate order to user with purchase.group_purchase_manager clearance. |
Validation Error: Stock move destination missing | Operation type lacks default internal destination location. | Configure target warehouse location in Inventory → Configuration → Operation Types. |
Quantity Mismatch: GRN vs PO 3-way match failed | Delivered quantity exceeds purchase order limit beyond allowable tolerance. | Verify physical delivery against supplier delivery slip and issue an amended PO or return voucher. |
Budget Reservation Error: Insufficient funds | Departmental budget allocation exhausted for target analytic account. | Submit a budget transfer or supplementary allocation request to the Finance Director. |
Next#
- Adjudicate award: Adjudicate award and manage standstill.