Relational data model

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Relational data model within SmartERP.

This reference document details the core database models and relationships.

{screenshot:data-model-overview-dashboard}

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 Module Interface#

1. Log into your SmartERP instance at https://smarterp.et/odoo.
2. Open the main App Switcher (grid icon in the top-left corner).
3. Select the Purchase app icon.
4. From the top navigation bar, open Purchase → Orders → Purchase Orders / Requisitions; Inventory → Operations.

{screenshot:data-model-app-switcher-navigation}

Step 2: Creating and Parameterizing Records#

1. Click the New button in the top-left control panel.
2. Complete the mandatory fields in the record form:
   • Vendor / Supplier (Mandatory): Approved vendor profile with verified commercial license and TIN
   • Order Lines & Products (Mandatory): Specified items with precise quantities, units of measure, and unit costs
   • Delivery Destination (Mandatory): Physical store or warehouse receiving location
   • Fiscal Position & Taxes (Mandatory): Statutory 15% VAT and applicable withholding tax terms
3. Configure optional operational parameters and localized tags as required:
   • Requisition Reference (Optional): Link to approved departmental purchase requisition
   • Payment Terms (Optional): Contractual settlement schedule (Net 30, Advance, LC)
   • Incoterm & Port (Optional): Shipping terms for import consignments (FOB Djibouti, CIF Bole)
4. Click the Save icon in the control bar to commit the record.

{screenshot:data-model-record-creation-form}

Step 3: Validating and Processing Transactions#

• State Transitions: Execute operational state progression (Draft RFQ → Sent → Confirmed Order → Received (GRN) → Billed → Locked).
• Ledger & System Impact: GRN validation posts stock valuation entries; vendor bill confirmation posts accounts payable and statutory withholding tax liabilities.
• Audit Verification: Automated recording of author ID, timestamp, and immutable revision history.

{screenshot:data-model-transaction-processing-state}

Core Models#

• purchase.procurement.plan: Annual procurement plan headers.
• purchase.procurement.plan.line: Budget line items and procurement method rules.
• purchase.tender: Sealed-bid tender records, lots, and deadlines.
• purchase.tender.bid: Vendor proposal submissions and encrypted payloads.
• purchase.tender.bond: Cashier Payment Orders (CPO) and bank guarantee instruments.
• purchase.tender.score: Technical and financial scoring entries by committee evaluators.
• purchase.tender.award: Adjudication records and standstill cooling-off timer.
• purchase.order: Formal purchase contracts and vendor commitments.
• stock.picking: Physical warehouse transfer records (Model 19 GRN, Model 20 SIV).
• stock.move: Stock move specifications connecting locations and products.
• stock.quant: On-hand physical balances per location, lot, and package.
• stock.landed.cost: Landed cost adjustment records and allocation lines.

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 stock
  • Stock: Expired lot quarantine trigger (stock.ir_cron_quarantine_expired): Runs daily to isolate batches past shelf life
  • Purchase: 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#

Next#

• Security reference: Security and access control.