Supply chain reports and stock cards
Complete guide to inventory valuation reports, Bin Cards, Stock Cards, aging analysis, and procurement dashboards.
1. Overview & Business Value#
This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Supply chain reports and stock cards within SmartERP.


This reference guide details all executive cockpits and operational reports in SmartERP Supply Chain.
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 → Reporting; Inventory → Reporting.

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 (Supply Chain Director, Inventory Analyst, CFO).
- 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.
Core Reports#
1. Stock Card / Bin Card (Form 3.12)#
The official chronological record of every physical transaction for a specific product and warehouse:
- Inbound Column: Model 19 GRN reference, date, received quantity.
- Outbound Column: Model 20 SIV reference, date, issued quantity.
- Balance Column: Running physical stock on hand.
- Menu trail: Inventory → Reporting → Stock Moves.
2. Stock Aging Analysis#
Categorizes inventory by duration of retention in storage:
0–30 Days: Fast-moving fresh inventory.31–90 Days: Normal operational buffer.91–180 Days: Slow-moving alert.180+ Days: Obsolete/dead stock requiring disposal review.
3. Procurement Spend Dashboard#
- Total spend by vendor, category, and procurement method (NCB, ICB, RFQ).
- Budget consumption variance against annual procurement plans.
- Vendor On-Time In-Full (OTIF) fulfillment performance.
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#
- Roles: Roles and permissions.
Last updated: 2026-11-15