Atlas xl is a Dynamics AX add-on tool allowing users to create reports without having to learn complicated query languages. Using Atlas xl users can consolidate data from all Microsoft Dynamics™ AX modules into a single report that will dynamically update. Atlas xl introduces Excel as an Axapta client enabling organizations to quickly analyze, understand, monitor and act on conditions that affect corporate performance and profitability from within Excel.

Security in Atlas xl uses the same validation and business rules that Microsoft Dynamics™ AX employs so a user can not access data unless they have rights set up inside Dynamics AX. Atlas xl reporting provides the user drilldown functionality to source transactions from an Atlas xl formula using Microsoft Excel's right-click menu.

Atlas xl is the most efficient method for importing data into Microsoft Dynamics™ AX. From your spreadsheet, use Atlas xl to import journals, budgets, forecasts, trade agreements and more. The import functionality is not limited to transactional data; you can use Atlas xl to load or update customers, vendors, projects, item or any other main or setup tables as well. Atlas xl import functionality uses the same validation and business rules that Microsoft Dynamics™ AX employs.