Betagro Inbound Logistics Improvement

TO-BE Swimlane Diagram (Future Process - Option I)

Inbound Officer (Office)

Prepare Truck Template

Prepares "Template แจ้งทะเบียนรถรับสินค้า" with expected trucks per DO.

Upload to Power App

Uploads template into Power App 1.

Carrier Officer

Confirm/Update Info

Confirms or updates truck plate and driver info in Power App 1.

Status: 'add' or 'cancel'.

Inbound W/H Officer (Ext. & Plant)

Register Trucks in App 1

Links each truck to specific DO 28xxxxx. Controls visibility based on 'cancel' status.

Search Truck in App 2

On arrival, searches truck by DO or license plate in Power App 2.

View Matched Data

Sees matched info from SAP HANA, Queue data, and SAP TM.

External Warehouse Officer

Load & Confirm

Loads material and confirms/fills truck registration in Power App 1.

Weighing Room (Plant & Origin)

Origin Weighing
Phase II

Creates "ใบชั่งต้นทาง (origin slip)". Data captured automatically via:

  • API from external W/H system
  • OCR from scanned slip
Plant Weighing

Captures actual gross & net weight.

Phase I: Manual Entry

Phase II: Automatic (API/OCR)

Power App 1: Truck Reg.

Receive & Validate

Receives truck data from upload/carrier. Shows warning for duplicate plates.

“ถ้าทะเบียนรถซ้ำ ให้ขึ้นเตือน” (If license plate is duplicated, show warning).

Power App 2: Weight Validation

Combine & Display Data

Shows combined dataset from SAP HANA, SAP TM, and Plant systems.

Calculate Weight Diff

Calculates Gross - Net and compares against allowance rule.

Validate & Highlight

Marked as "Back in allowance".

Highlighted as "Over allowance".

Save for Reporting

Saves final record for BI dashboard and settlement.

SAP / BI / Accounting

Data Sources

HANA, TM, and Plant systems feed data to a new combined data model.

BI Dashboards
  • HANA-TM consistency check
  • Allowance weight report
  • Transport performance
Simplified Accounting

Uses dashboard and consolidated exports to verify payments, replacing manual Excel checks.