Dynamics 365 Finance & SCM implementation for Borjomi

Borjomi engaged Awara IT to replace manual shipment planning and fragmented production planning processes with an automated, optimization-driven planning tool built on Microsoft Dynamics 365 Finance & SCM. The project delivered a single planning engine that evaluates demand forecasts, production capacity, warehouse constraints and vehicle limits to generate feasible, cost-efficient shipment plans across regional warehouses.

The solution also introduced plan-to-actual analytics for transport, production and shipping schedules, enabling rapid identification of deviations and continuous improvement. As a result, Borjomi gained predictable logistics performance, tighter inventory control and faster planning cycles—creating a digital backbone for scaling distribution across Georgia.

Müşteri / Sektör / Ülke

Borjomi is a Georgian beverage manufacturer operating multiple production sites and regional warehouses across Georgia. As a leading bottled water and beverage producer in the region, the company required enterprise-grade planning and supply chain capabilities to support complex production and distribution rhythms.

İş zorluğu

Before the engagement Borjomi relied on spreadsheets and disconnected systems for production and shipment planning. Planners had to manually reconcile demand forecasts, target warehouse balances, production schedules and vehicle capacities. This approach could not consistently account for operational constraints such as well flow rates, working time funds, production standards and lift/vehicle limits, which led to frequent emergency shipments and elevated logistics costs.

Borjomi also lacked systematic plan-to-actual analysis: deviations in transport and production volumes, product mix shifts, and missed shipping windows were identified late, limiting corrective action. The IT landscape included Dynamics 365 Finance & SCM as the core ERP and Casplan for planning inputs, but there was no automated optimization layer to translate forecasts into executable, constraint-aware plans.

Neden Dynamics 365 seçildi

Dynamics 365 Finance & SCM (Dynamics F&O) was chosen because it provides native manufacturing, master planning and warehouse management capabilities that map directly to Borjomi’s process-manufacturing requirements. Its extensibility allowed Awara IT to embed an optimization model and capture the many operational constraints—vehicle capacity, warehouse balances, production rates and well flow—while keeping transactional finance and inventory processes in a single ERP fabric.

Awara IT’s implementation approach prioritized minimizing business disruption: using standard Dynamics F&O modules where possible, integrating Casplan for demand inputs, and deploying Power Platform for analytics and operator interfaces. The end solution balanced out-of-the-box functionality with targeted extensions to meet Borjomi’s specific logistical and regulatory needs in Georgia.

Uygulanan modüller

• Dynamics 365 Finance (general ledger, AP/AR, cost accounting)
• Dynamics 365 Supply Chain Management (inventory, procurement)
• Production Control (process manufacturing scheduling)
• Master Planning (demand planning and optimization engine)
• Warehouse Management (WMS processes, barcode scanning)
• Transportation Management (shipment planning and carrier rules)
• Power BI / Power Platform for dashboards and exceptions

Entegrasyonlar

• Casplan — demand forecasts and planning inputs (API-based integration)
• Warehouse scanners and barcode systems (WMS gateways)
• Telematics/vehicle capacity data for shipment constraint enforcement
• Power BI datasets and Power Platform apps for plan-to-actual analytics
• Legacy Excel data loads and historical production data migration

Yerelleştirme ve uyumluluk

The implementation included Georgian localization for currency (GEL), VAT reporting and statutory document formats to ensure compliant financial close and tax submissions. Awara IT configured language settings and document templates for local operations and ensured transactional postings met reporting requirements for the Georgian Revenue Service. Data residency and privacy controls were applied according to local practice and Borjomi’s internal policies.

İş değeri

By embedding an optimization model into Dynamics 365 Finance & SCM, Borjomi moved from reactive, spreadsheet-driven planning to constraint-aware, executable plans. The company reduced emergency shipments and logistics spend while increasing on-time performance—improving customer satisfaction and reducing premium freight usage. Faster planning cycles and improved forecast accuracy lowered inventory carrying costs and freed working capital for core operations.

The solution also delivered clear plan-to-actual visibility across transport and production, enabling Borjomi’s operations and finance teams to identify root causes of deviations and implement corrective measures quickly. With a modern F&O foundation and Power BI-driven KPIs, Borjomi is positioned to scale distribution across Georgia and adopt further automation initiatives.