Pricing, ERP and Data Architecture Modernisation
Redesigned pricing and data architecture for a last-mile fuel distributor: governed workflows, role-based approvals, and full auditability.
~$200K
Annual revenue protection
~70%
Approval manhours reduced
Meet our client
PS Energy is a Singapore-based last-mile fuel distributor serving commercial and industrial clients. The company manages a complex pricing environment across multiple product types, customer tiers, and approval levels, with margins sensitive to small errors or delays in pricing decisions.
Context
PS Energy, a last-mile fuel distributor in Singapore, ran a sprawling stack: CRM, an on-premise ERP, pricing portals, delivery systems, and mobile field apps. Fuel pricing is unforgiving, costs, transfer prices, and selling prices shift constantly, and the existing setup overwrote pricing records, lost history, and scattered approvals across teams.
Challenge
The environment had grown organically into real operational risk:
- Multiple systems across CRM, ERP, pricing portals, delivery, and mobile with limited synchronisation
- Heavy data lifting between Linux-based portals and on-premise ERP databases
- Overwritten pricing records, with lost history and weak auditability
- Complex pricing across cost, transfer, selling, and term pricing
- Manual, role-based approvals spread across analysts, line managers, sales, and customer service
What we did
VentureSEA ran a deep technical and process assessment, then designed a governed, future-ready pricing architecture.
- Redesigned the landscape into clear logical layers and introduced a standalone historical pricing table in SQL Server, preserving every change without touching core ERP schemas
- Structured pricing into governed processes for cost, transfer price, and selling price, with a two-level approval hierarchy
- Defined granular role-based access across analysts, line managers, sales, customer service, and administrators
- Built Power Apps workflows integrated with Dynamics 365 Business Central via web services, with approval tracking, revision history, and notifications
- Completed the technical and process assessment in six weeks, then delivered in phased releases so daily pricing operations never stopped
Outcome and impact
- Eliminated pricing data overwrite risk with append-only, governed price history
- Faster pricing updates with full approval traceability at every step
- Regulatory-grade audit trail: every price change, approver, and timestamp reconstructable on demand
Business value
For a last-mile fuel distributor, pricing discipline is margin. On revenue in the low hundreds of millions at thin fuel margins, recovering even a tenth of a percent from eliminated mispricing and lost-history errors is worth roughly $150K to $250K a year. Replacing manual email approval chains with structured Power Apps workflows cut approval cycle time by roughly 70 percent, freeing the pricing and sales teams from the back-and-forth that previously delayed every change. The harder-to-price benefit is defensibility: a full audit trail removes a regulatory and dispute liability that can cost far more in a single incident.
More case studies
AI Suite Enablement for an HVAC BMS Platform
A modular AI suite for a building management platform: fault detection, remaining-useful-life prediction, and energy optimisation.
AI-Powered Quality Assurance for Insurance Customer Support
A multi-agent QA system that reviews support tickets against multi-page policies, with built-in PII redaction for GDPR.
AI Agent-Powered Travel Concierge with End-to-End Booking
A hierarchical multi-agent travel concierge: conversational itinerary generation plus direct flight booking through a GDS.
Have a project like this?
Tell us the outcome you need. We will map the path and the team to ship it.