The AX2012 Shadow Layer: How a Commodity Trading Firm Got Real-Time Margin Visibility

The Client

An international commodity trading firm operating on Dynamics AX2012 with a growing margin visibility crisis.

The Problem

Executives had zero real-time visibility into netback margins. The data existed — but it was trapped inside AX2012, fragmented across modules, and supplemented by manual spreadsheets that were consistently 48 hours behind the market.

In commodity trading, 48 hours is an eternity. Freight costs shift. Financing terms change. Terminal logistics fluctuate. Every contract was being evaluated on stale data, and traders had no way to input real-time variables like freight, financing, and terminal logistics costs on the fly. The result: decisions made blind, with millions in revenue at risk from margin erosion nobody could see happening.

The Solution

We built a real-time BI bridge using SQL queries directly against the AX2012 database, SharePoint as the collaboration layer, and a custom Power App that gave traders the ability to input live variables — freight costs, financing terms, terminal logistics — against every active sales contract.

This wasn't a rip-and-replace. It was a surgical extraction of the data that mattered, combined with a user-facing tool that eliminated the spreadsheet layer entirely. The Power App fed directly into the BI layer, creating a single source of truth for margin visualization.

The Result

Instant margin visualization for every sales contract. Traders could now see real-time netback margins with live freight, financing, and logistics variables. Decision-making went from 48 hours stale to real-time accurate — protecting millions in revenue through faster, data-driven trading decisions.

Is your data trapped in a legacy system? Let's build the bridge.