Sometimes you might need either to export data from AX or import data into AX or even both. One way to do this I described in the previous topic: How to import data into O365 through Excel Add-in In today’s article, I will show you another way how to export and import data in Microsoft Dynamics … Continue reading O365: How to Export/Import data through Data Management Framework (DIMF)
I was looking for any tools that I can use for importing data into AX in the fastest way. So far the way described below is the most suitable for me. Open Microsoft Excel Click on the Insert -> See all Select Microsoft Dynamics AX and click Add Note: if you do not see it, … Continue reading How to import data into O365 through Excel Add-in
If you are experiencing in the Excel an issue where Microsoft Dynamics AX add-in is invisible, you might need to install it. Use the link below to install Microsoft Dynamics AX add in https://store.office.com/microsoft-dynamics-office-add-in-WA104379629.aspx?assetid=WA104379629&sourcecorrid=a8afb77b-cfe0-4b70-baeb-f93fa38ad77b&searchapppos=0 Later on, I will show how to use it to upload some data into the Microsoft Dynamics AX system. Please use … Continue reading O365: How to install in the Excel Microsoft Dynamics AX Add-in
When you start deeply working with O365 it’s obvious that you need an access to the tables. The reasons for this might be different. In AX 2012 in was pretty easy to open table just by clicking Ctrl+D and finding needed table in AOT. But what should I do in O365?! What if you do … Continue reading O365: How to open table browser
The great example of using product masters with their variants it’s a Retail industry. Let’s say you have Product master as T-shirt. But this T-shirt might have a lot of variants: variety of colors (White, Red, Black etc.) and in different sizes (S, M, L, XL, XXL etc.). Setup Product dimension group Product dimension group … Continue reading O365: How to create product masters
In order to specify the characteristics of a product (raw material or finished good) you have a configurable way to add as many additional informational to the product as desired. It can be done thought Attributes. For example, for the laptop product, attributes might be: memory size, screen resolution, color, etc. Before adding an attribute, … Continue reading O365: How to create product attributes and assign to the product
Recently I've faced with this issue while I was updating financial dimensions for the intercompany purchase order where intercompany sales order had been invoiced. It turned out that issue was with the RemainInventPhysical and RemainSalesPhysical fields. Due to customization, when I invoiced intercompany sales order, RemainInventPhysical and RemainSalesPhysical fields on the sales order line were … Continue reading Solved issue: Update conflict. The standard cost does not match with the financial inventory value after the update. Value = ###.##, Qty = ###.##, Standard cost = #.## .