importing azure table storage to excel

Part 1 of the BI Blog, “Dynamics AX Reporting Out of the Box,” focused on what is available to Dynamics AX users natively (Click Here to read part 1).   Part 2 will focus on a brief chronology of the elements making up the Microsoft Business Intelligence solution, some of the incremental features and the strategic…

Read More
open time profile dynamics ax

In Microsoft Dynamics AX 2012 R2 and R3 Time and Attendance functionality allows a worker’s scheduled lunch break to be automatically deducted when calculating hours for a work day. However, there may be times when the dedicated worker does not take a lunch break and works through their lunch and needs to be compensated.  An…

Read More

Sometimes companies have employees or contractors that leave their organization on good terms, increase their skill set, or new positions become available and the need arises to rehire the worker. In Microsoft Dynamics AX 2012 R3 (AX 2012 R3). Human resource features easily allow the rehire of a past worker (employee or contractor). The Microsoft…

Read More
Production control Parameters Allow Partial Reservation Dynamics AX

Microsoft Dynamics AX 2012 R3 (AX 2012 R3) has newly added features that can be used to automate Production order reservation process. The automated reservation process ensures that materials will be set aside for use in the ‘Made to Order’ environment and preventing material shortages during a production run.  In addition, a new feature has…

Read More
dynamics ax role center

Much has been announced in the past two years relating to Business Intelligence by Microsoft.  For the Dynamics AX user, consider the laundry list of technologies and concepts: Management Reporter SQL Server Reporting Services SQL Server Analysis Services Cloud vs On Premise Office 365 Power BI Power Query/Map/View/Pivot… Datazen OLAP/Cubes Visualization Extract, Transform, Load BI…

Read More

In Microsoft Dynamics AX 2012 R2 and R3 Time and Attendance functionality can be used to setup in advance to pay a worker for planned company holidays using absence profiles. To setup the Absence Time profile complete the following steps Time Registration: Time Entry for Holidays The profile calendar is used to apply a specific…

Read More

In Microsoft Dynamics AX 2012 R2 and R3 Time and Attendance functionality can be used to apply rules for overtime calculations based on actual hours worked and can include or exclude holiday hours based on configuration. With the Labor Day holiday coming up next week let’s review how to account for Holiday pay and overtime…

Read More

What happens when you have hundreds of different users updating and modifying records at the same time? What if multiple users are changing customer’s information in different instances and were left with 4 slightly different addresses? How do we know what data we should keep and what data is duplicates? This is what master data…

Read More
sales order defaults dynamics ax

When creating a Sales or Purchase order, Microsoft Dynamics AX 2012 (AX) can auto populate Site and Warehouse information on the order header and lines. Today we will discuss the business logic hierarchy of how the Site and Warehouse fields are filled in on Sales or Purchase orders (and associated order lines). Site and Warehouse…

Read More
Select Service Operations Dynamics AX

Many businesses that use Microsoft Dynamics AX 2012 use third party vendors for their payroll processing and have a requirement on a weekly, bi-weekly, or monthly basis to import the General Ledger entries related to Payroll into AX 2012.  A simple solution for importing the Payroll ledger data is to use Microsoft’s Excel Add-in tool…

Read More