Every month we publish a "feature of the month" where we ask one of our consultants to highlight a feature in MILAS AX (our specific ERP modules for Microsoft Dynamics AX). This month Bartek Cach shares his insights.
Companies that are involved in the trading of commodities (in the physical and future markets), have to evaluate their commodity portfolio on a daily, weekly or monthly basis - depending on the company. Unfortunately, most companies store their contract information outside of their ERP system. This makes the evaluation of the contract portfolio versus market prices needlessly complicated. As an experienced industry partner Adifo Software recommends another approach…
By using our sector specific ERP solution, MILAS AX - based on Microsoft Dynamics AX, we can easily evaluate the commodity portfolio at the click of a button.
How to evaluate your commodity portfolio in your ERP
Companies already store the contracted price, quantity and duration of the contract in their ERP, but why should they stop there?
Rather than having to store the mark to market prices in a separate datasheet, MILAS AX has been developed to store and evaluate mark to market prices. Our solution also automatically calculates the average contract price of the commodity in a certain period.
Once MILAS AX has calculated the average buying price, it can be evaluated with the mark to market prices to provide more insights in the buying position: Is the company buying more competitive than the current market price? What about another factory, group of commodities or just a single contract?
With MILAS AX all these insights can be monitored in real time with the position monitor and the data can easily be exported to Excel at the click of a button.
A centralized ERP solution contains a lot of data but many companies are not yet taking full advantage of the opportunities at their disposal. The MILAS AX commodity and risk management module allows you to get better insights and take better decisions.