AX 2012 | Cash On Delivery

In the previous post we had discussed how to process cash sales. Today we are going to continue the second part of the cash sales where customers must pay when they receipt the goods or services. this process what we call cash on delivery.

Dynamics AX provide the functionality to process the cash on delivery. the following steps illustrate how to set up and process the cash on delivery.

AX 2012 | Cash Sales

In this post we will illustrate how to configure and process cash sale within Dynamics AX 2012. Cash sales is one of the common business practice between entities. In cash sales process the customer is required to pay cash on the spot. Dynamics AX create two vouchers when we post sales invoice with cash payment terms as follow:

First voucher

Debit: Customer Account

     Credit : Revenue Account 

Second vouchers 

Debit: Cash Account

     Credit : Customer Account

follow the few steps below to set up and process cash sales:

AX 2012 | Address Book Security Based on Team

In this tutorial we are going to discuss how to set security privileges to party records (Customers, Vendors, Workers, Contact, Prospect, Applicant... etc). Dynamics AX provide three ways as following :

• Secure by legal entity
• Secure by address book
• Secure by both legal entity and address book.

In this post we are going to focus in how to secure Address book based on teams. which means that only workers who are assigned to a team that has access to an address book can view the party records in that address book.

when we select Secure by address book, access to the address books is restricted by team. You must select the teams that have access to each address book. For each address book, you can set security privileges that allow or deny access to specific teams. If you grant a team privileges to an address book, all members of the team can view the records in the address book. If you do not grant a team access to an address book, the team cannot view the address book or its contents.

AX 2012 | Reimburse Customers

This article illustrate how to create reimbursement transactions for customers. Reimbursement transaction used when a customer has a credit balance, if the following conditions is applied you can reimburse customer for the amount of the balance.

1. The customer must have an associated vendor account( If a customer does not have a vendor account, a one-time vendor account is automatically created for the customer).
2. balance amount must exceed the minimum reimbursement amount that is specified for your legal entity.

When you create reimbursement transactions, a vendor invoice is created for the amount of the credit balance. This will remove the credit balance for the customer account and creates a balance due for the vendor account that corresponds to the customer.

Do the following steps to set up and create reimbursement transactions:

AX 2012 | Withholding Sales Tax

In this post we will discuss how to set up and calculate the withholding tax in Dynamics AX. Withholding tax is due on non-inventory deliveries (services), that a supplier delivers.

Buyer is legally responsible for paying withholding tax therefore The buyer is responsible for withholding a certain percentage of the invoice amount at the time of payment. (Net amount = invoice amount - withholding tax) is paid to the supplier. 

The tax withheld posts to a ledger account for withholding tax, and periodically is paid to the TAX authorities.

To to set up withholding tax perform the following steps:

AX 2012 | Import Data From an ODBC Through DIXF

Microsoft Dynamics AX 2012 Data Import/Export Framework provide the functionality to import data from an ODBC data source into Dynamics AX. In this post we will illustrate how to import Vendor data from MS SQL database into AX. First we will create sample database that contain vendors data. Then create an ODBC data source, Set up DIXF to import the data to the vendor entities.

Convert Field Values During The Importing Process Through DIXF

In the last two articles we discussed how to:

• Configure DIXF To Automatically Generate Unique Key Using Number Sequence.
• Assign Default Values Automatically During the importing process through DIXF.

Today we will discuss how we can convert the field values during the importing process.

Sometimes we may need to convert some of the master data values, especially when we planing to import data from a legacy to new system. For example, assume that one of your clients request to reclassify the vendors from a business line to a new one. in this case you can set up DIXF to convert the old business line value to the new value instead of change the business line for these vendors manually.

The following example we'll show how to convert the Vendor Line of Business during data import process.However we can use the same approach to change the values for any other fields.

Assign Default Values Automatically During the importing process through DIXF

During the preparation to import data, we often find ourselves having to fill a lot of values that are often the default values. For example, language, currency, customer group or group of suppliers etc....

In this article i will show you how we can assign default values during the importing process through DIXF.

The following example illustrate how to automatically assign default values for vendor currency and vendor group during the importing process. However we can use the same approach to assign default values for any other fields.

Configure DIXF To Automatically Generate Unique Key Using Number Sequence

Do we really need to manually add the reference numbers in the source file when we planning to importing data through the Data import export framework ? No we don't need to do that anymore :)

In this article i will show you how we can Configure DIXF to automatically generate unique key using number sequence during the importing process.

The following example illustrate how to generate vendor accounts automatically during the importing process. However we can use the same approach to generate the unique key for any entities.

Importing purchase orders using DIXF

In this post we will illustrate how to import purchase orders through data import export framework. we will use one excel file which contain purchase order header in first sheet and purchase order details in another sheet.


to import the purchase order please do the following steps:

AX 2012 | Import Released products using DIXF

This post illustrate how to import released products using the data import export framework in Dynamics AX 2012. We are going to import some of the released products information, you can add or remove fields as needed.

To import the released products please follow the steps below :

AX 2012 | moving average costing method - Part 4

In this part we will discuss production costing with moving average. If you use moving average in production costing, costs can be based on the current costs of raw materials rather than on the cost price that was originally registered for the item master. When the finished good is reported as finished, the cost reflects the estimated product cost calculation that is executed by a release of production orders.

The original cost calculation of the finished good might have happened months ago, and thus it might be outdated. With moving average, the result of a product cost calculation that is executed during the estimation process can be adopted rather than the cost from the original cost calculation of the finished good.

AX 2012 | moving average costing method - Part 5

This is the last part of the  moving average costing method in Dynamics AX 2012. in this part we will discuss the reports which show how moving average was calculated.

If you sort transactions on the inventory value report according to transaction time, transactions are listed chronologically, and you can view the costs from a moving average perspective. This way, you can verify that the cost of a moving average product has not been changed retroactively, even though the product has, for example, been adjusted by using backdating.

AX 2012 | moving average costing method - Part 3

After we discussed the Handling of price differences between a product receipt and the invoice in part 1 and Revaluation for moving average in part 2. in this post we will discuss the Backdating with moving average.

When you backdate a product receipt or an invoice, it is revalued to the current moving average cost. Also, a backdated issue is posted at the current moving average cost. With backdating, you cannot change the moving average going forward.

AX 2012 | moving average costing method - Part 2

In part 1 we discussed how to set up moving average costing method, then we discussed  how moving average is handling of price differences between a product receipt and the vendor invoice.

Today we are going to learn how to revaluate cost for moving average. To proceed with the next example you must read part 1 of this series or at least do the setup which described there.

If your moving average value is inaccurate because of, for example, a posting mistake, you can adjust the unit price of the on-hand inventory at any time.

The moving average cost can only be adjusted as of the current date, so when you adjust the unit price of an item by using the following procedure, the adjustment date is always set to the current date. You cannot change the date when you post the adjustment.

AX 2012 | moving average costing method - Part 1

In this series we are going to discuss the moving average costing method, by covering the following topics:

Part 1: Handling of price differences between a product receipt and the invoice.
Part 2: Revaluation for moving average.
Part 3: Backdating and moving average.
part 4: Production costing and moving average.
part 5: View how moving average was calculated.

first let's introduce the moving average costing method. Moving average is an inventory evaluation method that reevaluates inventory value in the chronological order of posting transactions, and it can be used to compute the average cost of the current ending inventory.

When a receipt transactions are included chronologically in the moving average calculation, according to the order in which the transactions are recorded in the system.

When Issue transactions are assigned the current active moving average cost at the time of recording, and the costs on inventory issues do not change even if the purchase costs (price in vendor Invoice ) change.

AX 2012 | Main account & Dimension value mask

Most likely that you notice the Dimension value mask and Main account mask fields during the setup of financial dimension and the chart of account. These fields give you the ability to enter a format mask to use for creating financial dimension values and main accounts. A format mask limits the amount and type of information that you can enter for dimension values.

the following steps illustrate how to setup and use this functionality :

Microsoft Dynamics 'AX 7' New, Changed, and Deprecated Features

New or changed features

Financial management What can you do?	AX 2012	‘AX 7’	Why is this important?
Export account structures to Excel	Not supported	You can now select an account structure and export that to Excel.	Many customers have requested the ability to export account structures to Excel for easier filtering.
View ledgers and advanced rule structures associated with an account structure on a single form	In AX 2012, the user has to navigate to multiple forms to see the ledger that the account structure is using.	Fact boxes have been added to the account structure form.	This allows for easier access to key information when defining and editing account structures.
Filter Management Reporter (labeled Financial reporting in ‘AX 7’) reports based on dimension, attributes, dates, and scenarios	All filtering of Management Reporter reports was handled through the design of the report. If a user with viewing privileges wanted to view a report for a different date, for example, this required a report designer to make the modification.	Report options have been added so when viewing a report, different filters can be applied and a new report is generated based on those filters.	Consumers of financial reports can apply different filters for dimensions, dates, attributes, and scenarios without the need for updates in report designs.
View Management Reporter (financial reports) within the ‘AX 7’ client	A separate web client was used for viewing Management Reporter reports.	A list of all financial reports can be accessed within the ‘AX 7’ client. The user selects a report to view, and the report is rendered within the ‘AX 7’ client.	You can now view financial reports without having to access a different client/application.

for more Features you can download the New Changed Deprecated Features whit paper from this link 

AX 2012 | Add invoices to payment groups

Dynamics AX give us the functionality to  add invoices to payment groups to group invoices by a common code. If one invoice in the payment group is settled, the other invoices in the group are included in the same settlement.

Invoices that belong to the same payment group must be settled at the same time. If one invoice in a payment group cannot be settled for any reason, no invoices in the same payment group can be settled. For example, if an invoice in the FIRE payment group is not approved, that invoice must be approved or removed from the payment group before the other invoices in the FIRE payment group can be settled.

the following steps illustrate how to configure and use the payment groups functionality:

AX 2012 | Add invoices to invoice groups

Dynamics AX give us the functionality to add invoices to an invoice group so that you can find and update invoices that are grouped together, without using a query. for example we can classify our expenses invoices per department. all what we need to do is add the invoice to custom group code which represent the department.

also we can setup AX to default group code for new invoices: User name, Date, or Custom. For example, select User name to automatically group new invoices by the name of the user who created them. Users can change the code on individual invoices.

the following steps illustrate how to configure and use the Invoice group functionality:

Use the same number with transaction and transaction voucher

In this post i will illustrate how to use same number with transaction and transaction voucher. Microsoft Dynamics AX provide functionality to use the same number for some transactions and transactions voucher in accounts receivable and accounts payable modules as following:

AR Module

1- free text invoice with free text invoice voucher

2- Packing slip with Packing slip voucher

3- Customer invoice with Customer invoice voucher

4- Sales credit note with Sales credit note voucher

AP Module

1- Internal product receipt with Product receipt voucher

2- Internal invoice with Invoice voucher

3- Internal credit note with Credit note voucher

The following steps discus how to use this functionality with free text invoice and the free text invoice voucher.

Speed Up the demo data import | AX 2012

If you try to import AX 2012 R3 demo data you will notice that the importing process take very long time and it may took more than 24 hours. After a little investigation i found that the cause of this problem is due to the small size of the empty database.

Since the import process end with a huge size (around 16 GB for data and 26 GB for log) MSSQL start using the auto growth to expand the DB file size which will take long time and in some cases the expanding will stop when the DB reach the maximum file size. 

We can reduce the import time to 1 hour or less in very simple way. all what we need is to expand the DB file size before start importing the demo data, the following steps illustrate how we can do it:

Vedio | Import main accounts using data import / export framework

Video | Import Assets using data import / export framework | AX 2012

Video | Import Customer accounts using DIF | AX 2012

Video | Import Vendor accounts using DIF | Dynamics AX 2012

Import Projects using Data Import framework AX 2012 R3

Video | Import Financial Dimensions using Data Import framework | AX 2012 R3

If you don't like to read the long steps in my article about how to import financial dimension using Data Import framework in AX 2012 R3. you can just watch the video :)

Create partitions in Dynamics AX 2012

Often we need to create clean environment for training purposes or to prepare  simulation environment Without the need to install Dynamics AX Again. The following steps illustrate how we can set up clean environment using Dynamics AX Partitions.

Import Workers using Data Import framework AX 2012 R3

This post illustrate how to import Workers using the data import framework in Dynamics AX 2012 R3.We are going to import some of the Worker information you can add or remove fields as needed.

Import Assets using Data Import framework | AX 2012 R3

This post illustrate how to import Assets using the data import framework in Dynamics AX 2012 R3. We are going to import some of the asset info you can add or remove fields as needed

Import Vendor Groups using Data Import framework | AX 2012 R3

This post illustrate how to import Vendor Groups using the data import framework in Dynamics AX 2012 R3

Import Main Accounts using Data Import framework | AX 2012 R3

This post illustrate how to import the Main Accounts using the data import framework in Dynamics AX 2012 R3

Import Vendors using Data Import framework | AX 2012 R3

This post illustrate how to import Vendors Accounts using the data import framework in Dynamics AX 2012 R3

Import Customers using Data Import framework | AX 2012 R3

This post illustrate how to import Customers basic information using the data import framework in Dynamics AX 2012 R3

Import Financial Dimension using Data Import framework | AX 2012 R3

This post illustrate how to import the financial dimension using the data import framework in Dynamics AX 2012 R3. Follow the steps bellow to import the financial dimension values to Dynamics AX 2012. If you prefer to watch Video rather than reading the following steps, please visit my YouTube Channel.

Configure and use one-time supplier functionality in Dynamics AX

One-time Supplies is common practice in trade business. one time supplier is a vendor who supply items or service for one time.
Dynamics AX help organization to separate the regular vendors accounts form the one time vendors.
in the following steps we will illustrate how to Configure and use one-time supplier functionality in Dynamics AX 2012.

How To Print a Single Voucher in AX 2012

Sometimes we need to print a single voucher from a journal that have multiple vouchers. To do that we will take advantage of the ability to add new filters to Dynamics AX  reports. The following steps illustrate how we can do it:

Cash discount handling for over payments (Deep inside Dynamics AX 2012 Payment Settlement 3rd Scenario)

   Dynamics AX 2012 give you the ability to handling the customer overpayments through three different ways. 
AX will select the approach depending on the setup of the Cash discount administration and Maximum overpayment or underpayment fields in the Accounts receivable parameters from.

The following cases illustrate how different combinations of these two parameter will generate the three cases.

Case 1: The Cash discount administration value is Specific and the over payment amount is between 0.00 and the amount that is entered in the Maximum over payment or underpayment field. In this case the over payment amount will posted to a cash discount difference ledger account which specified in n the Account for automatic transactions form

Deep inside Dynamics AX 2012 Payment Settlement scenarios (2nd Scenario)

Microsoft Dynamics AX can select the transactions automatically by using the automatic settlement functionality. 
This topic describes how transactions are settled if you select the Automatic settlement check box in the Accounts receivable parameters form. 
You can also customize how automatic settlements are processed by using the Prioritize settlement check box, the Use priority for automatic settlements check box, and the Manage priority link. 

In this article we are going to illustrate how we can confugire Dynamics ax 2012 to Automatically settle customers invoices Using the following Methods:

1. Default automatic settlement
2. User-defined settlement priority

Deep inside Dynamics AX 2012 Payment Settlement scenarios (1st Scenario)

In this series I am going to illustrate 8 scenarios about how we can settle a customer payment with invoice in Dynamics AX 2012.

We will start with the basic scenario, then move on to more complex scenarios each time. the following list illustrate the roadmap for the series:

First Scenario: Settle a customer payment with an invoice.
Second Scenario: Automatic settlement and prioritization.
Third Scenario: Cash discount handling for over payments.
Fourth Scenario: Settle a partial customer payment and settle the final payment in full before the discount date.
Fifth Scenario: Settle a partial customer payment before the discount date with a final payment after the discount date.
Sixth Scenario: Settle a partial customer payment that has multiple discount periods.
Seventh Scenario: Use one customer payment to settle multiple invoices that span multiple discount periods.
Eighth Scenario: Settle a partial customer payment that has discounts on credit notes.

Install Dynamics AX 2012 R3 Step by Step (Step 5) (Install AX DIXF)

In this Article i am going to illustrate how we can Install Dynamics AX 2012 R3 Data Import Export Framework.
The Microsoft Dynamics AX 2012 Data Import/Export Framework is an extension that helps you import and export data in Microsoft Dynamics AX. 
Examples of the data that you can migrate include master data, open stock, and balances.

Please Complete the following steps to learn how to install Data Import/Export Framework

Troubleshooting insufficient permission to Preview Dynamics AX Reports

The report has a rendering error. When you try to run the report you receive an error like the following: 

"Error while setting report server parameters.Error Message The permissions granted to user are insufficient for performing this operation". 

This issue appears because the user account don't have permissions to view AX reports folder on the SSRS. To solve this issue we need to grant the permissions to the user account.

To fix this issue please complete the following steps:

Troubleshoot "Failed to log on Microsoft Dynamics" During Report Rendering

The report has a rendering error. When you try to run the report you receive an error like the following: "Failed to log in on Microsoft dynamics" Or "An error has occurred during report processing".

 This issue appears because the SSRS Execution Account is invalid. To fix this issue we are going to change the SSRS Service account to be the same as the Microsoft Dynamics AX Account.

please complete the following steps:

Troubleshoot Dynamics AX Report Labels do not Display

 when the report labels do not display, or the report shows label IDs, like Labels!@SYS24426 instead of the label values. this is mean that the SSRS service account is different than the Microsoft Dynamics AX service account. 

To fix this issue we are going to change the SSRS Service account to be the same as the Microsoft Dynamics AX Account.

please complete the following steps:

Troubleshooting "The network path was not found" During AX Report Deployment

During the manual deployment of dynamics AX Reports some errors could occur, one example of this issues when the system return that the Network path was not found. To fix this issue you need to start the Remote Registry service. please follow the below steps to know how you can do it.

Deploy Dynamics AX Reports Manually

In many cases, the user does not deploy Dynamics AX reports during the installation he only installed the reports extensions,then later on he deploy the reports manually.

To know how you can do it please follow the below steps:

Install Dynamics AX 2012 R3 Step by Step (step 4)

In the previous articles we discussed how to install AX basic components, we also discussed how to complete the initialization checklist and the partition initialization chick list after that we were imported dynamics AX Demo Data. Today we are going to install Dynamics AX 2012 R3 Reports.

Install Dynamics AX 2012 R3 Step by Step (Step 3)

In the previous articles we discussed how to install AX basic components and initialization checklist.  Today we are going to discuss how to import AX Demo Data. Before we can import the demo data we need to prepare the prerequisites. Two prerequisites are required. Download the demo data, and Test Data Transfer Tool.

Install Dynamics AX 2012 R3 Step by Step (Step 2)

In the previous article we discussed how to install AX basic components today we are going to discuss how to complete the initialization checklist and the partition initialization chick list.
Please follow the following steps:

Install Dynamics AX 2012 R3 Step by Step (Step 1)

In this series we will discuss how to install dynamics AX 2012 R3 step by step. we will start by installing AX Basic Components after that we will move to initialization checklist then we will discuss how to import the demo data.

Today I am going to illustrate how to install Dynamics AX 2012 R3 from scratch
first we are going to make sure that the AX prerequisites is installed. Then we will start the installation process by installing the AX basic components which include the Database, Application Object server, Client.

Install Dynamics AX Without Having Real Domain

The problem started when I resigned from my previous job. After rest for a couple of days. I format my laptop. but since I am working as Dynamics AX consultant I had to reinstall Dynamics AX on my laptop. Then misfortune befell the laptop must be associated with domain in order to install Dynamics AX. After several failed attempts to overcome  this issue an idea spangle in my mind. Why not to use the Dynamics AX Virtual Machine Domain. Guess what? ....I succeeded.

Speed up Dynamics AX Virtual Machine

After we discussed How to Setup Dynamics AX VM and How to Rearm the VM Operating system. Today we are going to illustrate how to speed up Dynamics AX VM.

Unfortunately most of users don't have enough memory to run the dynamics virtual machine in convenient way. However there a simple steps we can do to save more memory. all what we need is to stop some services.

Rearm Dynamics AX Virtual Machine

Last article we were talking about how to setup the Dynamics AX Virtual Machine. Today I am going to show you how we can reactivate the Dynamics AX VM operating system license to maintain the VM up and running without any obstacles.

Once you have activated the VM Windows you are given 180 days of evaluation period. After 180 days are over, you can extend the evaluation period for the same number of days – maximum Three times. Rearming the windows will prevent the virtual machine shutdown every few minutes.

Setup Dynamics AX 2012 Virtual Machine

Please follow the following steps to setup the dynamics AX Virtual Machine.