US 408 365 4638

Avalon

Streamlining Sales-to-Project Workflows with Connected Cloud ERP

The Goal

Replace manual, disconnected processes with an integrated ERP system to automate project creation, centralize operations, and prepare for scalable, future-ready BOM configuration.

The Outcome

Avalon now benefits from automated sales-to-project workflows, centralized financial and operational visibility, reduced manual effort, and a future-ready platform designed to scale with expansion and material planning automation.

Executive Summary

Avalon International Aluminium partnered with Folio3 to digitize and modernize its operational workflows through Microsoft Dynamics 365 Business Central and integrated D365 Sales. The solution enabled automatic project creation from closed opportunities, improved data consistency, and centralized financial and operational visibility. Avalon plans to implement a BOM configurator to eliminate outdated Excel VBA processes, further boosting planning accuracy and efficiency.

Client
Background

Industry

Aluminum Interior Frames and Door Solutions

Operations

Manufacturing and delivery of custom aluminum frames and doors

Location

Tualatin, Oregon, USA

Previous Systems

Disconnected Excel VBA tools, manual sales-to-project workflows

Problems

Unique Business Challenges they faced

Manual BOM creation in Excel VBA

Used outdated Excel-based tools for Bill of Materials, lacking automation, accuracy, and version control.

Sales-to-Project process disconnected

Sales team operated in D365 Sales while project setup was manual and prone to delays.

Lack of centralized project visibility

Project tracking was scattered, with no real-time insight into resource usage or cost tracking.

Redundant data entry

Sales and operations teams duplicated efforts in multiple systems, leading to errors and inefficiencies.

Key Business Drivers & Objectives for Implementation

Automate sales-to-project creation process
Implement centralized ERP for project tracking & finance
Prepare for future automation in BOM creation
Enable scalability through cloud-based infrastructure

The Solution Delivered

Scope of Implementation

Core Modules

Project Management, Sales, Purchasing, Finance

Custom Extensions

Automated creation of projects from D365 Sales.

Integrations

Planned BOM Configurator for project-specific material planning
D365 Sales and Business Central integration for project sync

Our approach unfolds in four defined steps

Hybrid (Agile for discovery, Waterfall for implementation)

Discovery, Solution Design, Development, UAT, Go-Live

Conducted via Folio3’s proprietary templates

End-user training and phased rollout for ease of adoption

Technology
Stack

ERP

CRM

Planned Extensions

Integration Layer

Key Results & Business Benefits

Sales-to-Project Automation

Enabled automatic project creation in Business Central upon opportunity closure in D365 Sales, reducing manual effort by approximately 60%.

Process Centralization

Consolidated finance, sales, and project operations under a single ERP platform, improving interdepartmental collaboration and reducing data redundancy.

Project Visibility & Accuracy

Gained real-time project tracking and material planning capabilities, reducing project delivery delays by 35%.

Future-Readiness with BOM Configurator

Aims to eliminate Excel VBA tools for BOM management, expected to cut BOM generation time by 70% and improve accuracy in material selection.

Operational Scalability

Cloud-based architecture supports multi-location expansion, including the new facility in Mississippi.

Data Consistency & Error Reduction

Automation has reduced manual entry errors by over 50%, enhancing operational reliability.

Enhanced Decision-Making

Real-time project and financial data allows for more accurate forecasting and faster executive decision-making.

revolutionised avalon

Eduction in Manual Sales-To-Project Effort
0 %
reduction in project delivery delays
0 %
(expected) reduction in BOM creation time
0 %
reduction in manual entry errors
0 %

Want to Implement Microsoft Dynamics 365 Business Applications? We Can Help!