Implementasi Haversine Formula Untuk Otomatisasi Perhitungan Jarak Pengiriman Pada ERP Odoo 19
Year: 2026
Type: article
Abstract: Manual delivery distance estimation and shipping cost calculation can lead to inconsistent cost determination and increase administrative workload in distribution operations. This study aims to implement the Haversine Formula in Odoo 19 Enterprise Resource Planning (ERP) to automate delivery distance estimation and shipping cost calculation. The system was developed using the Rapid Application Development (RAD) method, comprising requirements planning, user design, construction, and cutover. The implementation integrates customer address geocoding through the Nominatim API, geographic distance calculation using a Python-based Haversine function, and automated shipping cost calculation within the Sales Order workflow. The Haversine function uses an Earth radius of 6,371 kilometers and calculates the distance between warehouse and customer coordinates based on latitude and longitude. Shipping costs are determined using a tariff of IDR 5,000 per kilometer. Functional testing was conducted using Black Box Testing to verify address geocoding, distance calculation, shipping cost calculation, and related delivery functions. The test results reported in the system development study indicated that the implemented features operated according to the specified functional requirements. This implementation demonstrates how geographic distance calculation can be integrated into an ERP transaction workflow to support more consistent and structured shipping cost determination. However, the Haversine Formula calculates straight-line geographic distance rather than actual road distance, and further quantitative validation against an independent reference calculation is required to assess numerical accuracy. The study provides an implementation basis for evaluating the integration of geographic distance calculation into ERP-based distribution processes.
Institutions: Politeknik STMI Jakarta, Universitas Suryadarma
Language: English
Subfield: Management Information Systems
Domain: Social Sciences
Open Access status: hybrid
OpenAlex ID: W7225821966
FWCI:
Cites:
Cited by:
Related to: