09电竞官网赛程查询
Business Intelligence (BI) Part 1: Microsoft Dynamics AX 2012 BI Out of the Box
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 MoreMaster Data Management in Microsoft Dynamics AX 2012 R3
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 MoreSite and Warehouse Defaults for Order Lines in Microsoft Dynamics AX 2012
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 MoreMicrosoft Dynamics AX 2012 Import Payroll General Journal (GL) Entries
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 MoreMicrosoft Dynamics AX 2012 Accounts Payable Invoice Registration and Invoice Pools
Invoice registration in Microsoft Dynamics AX 2012 is used to record the arrival all vendor invoices received by your organization which then allows the invoice to be transferred to the invoice pool, giving an opportunity to approve the invoice before it becomes an official accounts payable. Described below is the AX 2012 process of registering…
Read MoreMicrosoft Dynamics AX 2012 Intercompany Project Timesheets
In Microsoft Dynamics AX 2012 R2 and AX2012 R3 Project management and accounting intercompany project timesheets allow a worker from a “lending” legal entity to book time against a project in a “borrowing” legal entity. By allowing the “borrowed” worker to book time against projects in other legal entities all project costs and revenues are…
Read MoreProcurement and Sourcing: Alternative Items in AX 2012 R3
As a purchasing agent, you might want to know about available alternate items or services when working with a Request for Quotation (RFQ). A new feature has been released in Microsoft Dynamics AX 2012 R3 for both AX client and vendor portal. If the requester allows it, all vendors can submit an alternate item on…
Read MoreImporting Currency Exchange Rates in Microsoft Dynamics AX 2012
Many businesses that use Microsoft Dynamics AX 2012 R2 and R3 use third party vendors for obtaining currency exchange rates and then manually maintaining them for a given time period in Microsoft Dynamics AX. Beginning with the release of Microsoft Dynamics AX R2 a new framework was introduced to allow exchange rates to be imported. The…
Read MoreSales and Purchase Price Trade Agreements in Microsoft Dynamics AX 2012
In Microsoft Dynamics AX 2012 the Trade Agreements feature allows predetermined pricing agreement prices to be automatically populated on the sales order or purchase order line. This document will also discuss groups which can be used to simplify and expedite the Trade Agreement creation process. Sales Price and Purchase Price Trade Agreements 1. In order…
Read MoreAccounts Payable Wire Reversal in Microsoft Dynamics AX 2012
The purpose of this blog is to assist in the reversal of AP payments in AX 2012 that do not have check numbers such as Wire, Electronic Payment or ACH. It may be necessary for a payment to be reversed in order for corrections to be made. In order to reverse a wire payment the following…
Read More