SmartERP Documentation An Ashewa Technology Solutions Platform

Conduct blind cycle count audits

Execute periodic blind inventory counts, audit physical discrepancies, and process managerial stock adjustment approvals.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Conduct blind cycle count audits within SmartERP.

Ethiopian store voucher lifecycle diagram connecting Model 19 GRN, Model 20 SIV, Model 21 SRV, and inventory valuation.
Ethiopian store voucher taxonomy and stock valuation integration.

Inventory Cycle Count Audit and Variance Reconciliation Form

This guide explains how internal audit teams conduct blind inventory counts without knowledge of book balances.

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#

  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. Navigate to Inventory → Operations → Physical Inventory.

Inventory Cycle Count Audit and Variance Reconciliation Form

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 (Inventory Auditor, Storekeeper, Warehouse Manager).
  • 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.

Procedure#

  1. Open Inventory → Operations → Physical Inventory and click New Count Batch.
  2. Select target location (e.g. WH/Stock/Zone-A).
  3. Set Count Type: Blind Count (masks the theoretical on-hand quantity on counting sheets).
  4. Print physical count sheets and assign independent counters.
  5. Counters enter physical counts in column Counted Quantity.
  6. The audit controller reviews variances: $$\text{Variance} = \text{Counted Quantity} - \text{Theoretical On-Hand}$$
  7. For variances exceeding 1,000.00 ETB or 2%, an audit explanation is required.
  8. Supply Chain Director reviews and clicks Apply Adjustment.

Stock Adjustment Entries#

SmartERP automatically generates:

  • Gain Move: Debits Stock Valuation, credits Inventory Adjustment Gain.
  • Loss Move: Debits Inventory Shrinkage/Loss, credits Stock Valuation.

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#

Error Symptom / ExceptionProbable Root CauseCorrective Action / Resolution
Access Rights Error: Cannot confirm Purchase OrderUser lacks purchase manager approval privileges.Escalate order to user with purchase.group_purchase_manager clearance.
Validation Error: Stock move destination missingOperation type lacks default internal destination location.Configure target warehouse location in Inventory → Configuration → Operation Types.
Quantity Mismatch: GRN vs PO 3-way match failedDelivered 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 fundsDepartmental budget allocation exhausted for target analytic account.Submit a budget transfer or supplementary allocation request to the Finance Director.

Next#

Last updated: 2026-11-15