QCommission Integration with MS Dynamics AX
Overview
Sales commission programs are possibly the most variable programs conducted by a firm. These programs tend to vary significantly from industry to industry, and many times within companies in an industry. Sales commission programs tend to be different by employees even within a single firm. Because of the highly variable nature of commission calculations, solutions attempting to solve the problem must be highly sophisticated. At the same time, they should not burden the user with additional complexity in their operations. One key area of complexity is allowing data interchange between the customer's existing accounting systems and the commissions system. A commission system that can understand the structure of the accounting system data and seamlessly bring in the appropriate data necessary for calculating commissions can be a huge benefit in reducing the inherent complexity in that process.
QCommission is a powerful, flexible sales commission software tool. It calculates sales people's compensation accurately, quickly and professionally. QCommission is integrated with QuickBooks® but can also be operated stand- alone.
Microsoft Dynamics AX is the ERP solution for enterprises. Microsoft Dynamics AX combines a rich set of core capabilities with an innovative approach to enterprise resource planning (ERP).
Technology
Microsoft supplies the MS Dynamics AX SDK to allow third party products to work with MS Dynamics AX. The SDK ensures that
- The third-party software complies with security access to the data
- Provides strong error recovery and data logging to make sure data is protected
SDK uses .Net libraries to access various AX objects. QXchange uses the AX SDK to access MS Dynamics AX objects
MS Dynamics AX Data
The AX SDK exposes all the data objects available in the AX. Some of the various objects available are listed here and there are more objects accessible.
Data formats including notes and activities can be accessed using QXchange.
Objects
The following lists are available for access:
| Lists | Objects |
| Entity |
Customer, Vendor, Products and other master objects |
| Transactions | Sales Order, Payments etc.… |
Source Data
MS Dynamics AX can be defined as source data and the various objects can be accessed. Field level data from the objects can be extracted and mapped to destination objects and fields in different data formats. Data from multiple objects can be extracted. Multiple profiles can be set up to extract data from various objects.
Source data can also be filtered using various expressions. Prior to executing extract, the source data can be viewed to make sure the right records are getting selected.
Target Data
MS Dynamics AX can be defined as target data and the various objects can be updated. Data can be updated to multiple objects. In some cases update may have to affect multiple data objects at the same time, for example: Invoice Header and Line.
Data can be updated in various modes: Insert, Update and Upsert. Insert expects the record being updated to be new and unique. Update expects the record to already exist. Upsert, tries to insert first and if that fails tries to update.
Exporting Data
QCommission enables effective transfer of the data to the databases of SQL Server. Facilitates precise view of the data after filtering process. The System also facilities data size validations before initiating the export.
Conclusion
QCommission does a tremendous job, understanding the intricacies of the MS Dynamics GP data structure as well as the complications inherent in the data integration process. With this ability it integrates the two systems in such a manner that the complexity to the customer is reduced to a minimal level.
Customer Testimonials
"The QCommission team did an excellent job at handling our needs for a new sales commissions program. They took the time to review our initial needs for the program and then worked with us until we resolved all the "if this, then that" issues we were working with. The program uploads to QuickBooks and automatically does the calculations. You are then able to do adjustments, if necessary, and export very professional reports and e-mail them. We are extremely pleased with the QCommission team and highly recommend them “.
