In computing, Microsoft Dynamics is a line of enterprise resource planning ERP and customer relationship management CRM software applications. Overview. Managed host control in Microsoft Dynamics AX 2012 is used to host a. NET or WPF control on a Microsoft Dynamics AX form. It is used to enhance the. ANEGIS Consulting UK is a leading Gold Cloud Microsoft Dynamics Partner specialising in implementing Microsoft Dynamics 365 Dynamics AX systems. Capture new opportunities across your business when you bring people, data, and processes together with Microsoft Dynamics 365intelligent cloud applications that. Feature allows to initiate credit transfer in ISO20022 generic format in Microsoft Dynamics AX 2009, AX 2012, AX 2012 R2, AX 2012 R3 for Switzerland, Sweden, Norway. This year at Convergence. I learned that a low percentage of AX customers are aware that new reports have been developed to assist with the inventory reconciling process. Im hoping this post will help spread the word. Included in this post is the material I covered in my session at Convergence this year Inventory Costing Reconciliation Tips Tricks for  Microsoft Dynamics AX 2. Sims 2 Base Game. Truthfully, the content is not specific to AX 2. Power_BI_example_1.jpeg.jpg' alt='Microsoft Dynamics Ax Reporting Tools' title='Microsoft Dynamics Ax Reporting Tools' />Below are the key takeaways from the session A new Inventory Value report was developed for AX 2. AX 2. 00. 9. A new Potential Conflicts report was also developed for AX 2. AX 2. 00. 9. Physical Inventory by Item Group report For AX versions where the new reports are unavailable, we recommend this report for reconciliation against GL values. Inventory Dimension settings have a significant impact on financial values, and should be considered during reconciliation. New logic was introduced for inventory transfers. This was developed for AX 2. AX 2. 00. 9. Tips and Tricks for reconciliation. Inventory Value Report. Ignify is a Microsoft Business Solutions Axapta Gold Certified Partner and offers the following Dynamics AX Services Microsoft Dynamics AX ERP. Pw0n4ForHbI/V1lcBwfbOfI/AAAAAAAAA_Y/GyxRcfZ5b_gKHJk4IjrRNOXR147HHeZrQCKgB/s1600/24.jpg' alt='Microsoft Dynamics Ax Report' title='Microsoft Dynamics Ax Report' />The new report is configurable and actually allows you to set up multiple versions of the report. You can use the report framework as a one stop for Inventory, WIP, Deferred COGS, COGS, and Profit Loss. You could also set up separate reports for each. Each of the financial positions can also be compared to their corresponding GL balance on the report. The report can be run using the date intervals that are used in other areas of the system. This is a change from previous inventory reports, which were limited to using an as on date. Potential Conflicts Report. If the Inventory Value report identifies a difference between GL and inventory values, the new potential conflicts report can be used to identify what caused the imbalance. The report was designed to check for the most common issues that cause discrepancies between GL and Inventory values. The new reports are included in hotfix rollup 5, and later on AX 2. If you are on AX 2. SP1 prior to hotfix rollup 5, you can download the package that includes reports and the non financial transfers functionality described later in this post. Heres the link for that download https mbs. KBDisplay. aspx scidkb en US 9. Here is the whitepaper that covers the new reports https mbs. Physical Inventory by Item Group Report. This is the report that should be used to reconcile against GL balances if you are an AX build that can not leverage the new inventory value report. The report should be run as of a date that an inventory close was executed in order to have the most accurate values. Inventory Reports Status Physical InventoryFinancial Quantity financially updated quantity. Deducted physically updated quantity of outflow. Received physically updated quantity of inflow. On HandPhysical Inventory sum of Posted Quantity Deducted Received. Financial value Inventory Value Financially updated amount of Posted Quantity. Physical Value not posted Floating Value physically updated quantity Item master cost price. Only updated if no transaction in the ledger. Physical Value Posted Posted Physical value physically updated item transactions that are associated with the a ledger transaction. Known Financial DifferenceKnown value physically updated transactions existed at the AS OF date of the report  but after that date the transaction was financially updated. Inventory Value Estimated Inventory Value sum of Financial value Known value Physical value  posted and not posted to GL Inventory Dimension Considerations. Physical on hand and financial values can be viewed in AX and in reports at any inventory dimension level. However, the only way to get the most accurate numbers is to view on hand and financial value using the dimensions that are marked as financial inventory on the inventory dimension group. The financial inventory checkbox effectively does two things for us with regards to inventory valuation 1. Calculates running average cost price at that dimension level 2. Settles receipts to issues at that financial level when the inventory close is run separate FIFO layers per financial dimension level, separate weighted average calculation per financial dimension, etc. Heres an example that illustrates the point For the test, I created two FIFO items both track site and warehouse. The only difference is that one has warehouse marked as financial inventory and the other does not have warehouse marked as financial inventory. I entered the same three transactions for both items. Take note of the warehouses specified 512. Purchase 1 qty 1. Purchase 1 qty 2. Sell 1 qty from warehouse 1. In AX, the issue transaction is valued at the running average cost price. So, in this example you may expect a value of 1. This is where the financial inventory setting comes into play. For the item that has warehouse marked as financial, the issue transaction is valued at 2. With financial marked, costs are maintained per warehouse, so the only receipt considered when calculating the average cost for the issue transaction was the receipt for 2. For the item that does not have warehouse marked for financial inventory, the issue transaction is valued at 1. Both transactions were used in the calculation of the average price warehouse is basically ignored. Why is this relevant to reconciliation If I want to view on hand value by warehouse for the two items, well see the problem The item that has warehouse marked as financial looks fine   but if you are viewing on hand value by warehouse for the item that does not track warehouse as financial, we see something strange. Notice that warehouse 1. Quantities were removed from warehouse 1. Reconciliation by warehouse should only be done for items that track warehouse as a financial dimension. The same is true for all inventory dimensions. Tips and Tricks for Reconciling Posting Types Ledger entries get stamped with a posting type. The posting types that will also result in a change in the inventory subledger values are the following  Financial Updates. Purchase, Receipt. Sales order issue. Inventory Receipt. Production Receipt. Production issue. Purchase, Standard cost price offset Physical Updates. Purchase, packing slip. Order packing slip. Production, picking list. Production, Report as Finished In order to leverage this information, I used the ledger voucher inquiry  GL Inquiries voucher transactions. Change the selection criteria to look at ledger account and posting type. Going into this process, you know two things The GL accounts that you deem to be inventoryThe posting types that will reflect inventory balance Run the inquiry two ways 1 Identify Non Inventory accounts that used inventory posting types note that the selection criteria includes the posting types listed above, and NOT the inventory accounts. To accomplish the not, use an exclamation point Ledger Account Inventory. Posting type   Purchase, packing slip, Order packing slip, Production, picking list, production, Report as Finished, Purchase, Receipt, Sales order issue, Inventory Receipt, Production Receipt, Production issue, Purchase, Standard cost price offset 2 Identify Inventory accounts that used non inventory posting types.