Supply chain reports and stock cards

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.

{screenshot:reports-and-dashboards-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:reports-and-dashboards-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:reports-and-dashboards-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:reports-and-dashboards-transaction-processing-state}

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

• Roles: Roles and permissions.