Monthly Archives: April 2014

#TipADay: Day 2: Importing Data to Microsoft Dynamics AX 2012 using Excel Add-in

Excel is a great spreadsheet tool and the AX 2012 Add in is even more wonderful. It allows to publish information/data back to Dynamics AX 2012 without any changes in AX 2012  configuration.  In this functioned example, I will show how you can use the Dynamics AX Excel Add-In to update your data. 

Before we start working on Microsoft Excel, we need to make sure that we have the Dynamics AX Excel Add- in installed. If you open up Excel and there is a Dynamics AX tab, then you are fine. If not, you will need to install it.

Lets try and import Chart of Accounts in Dynamics AX 2012. To do that, follow these simple steps:

Step 1: Go to Dynamics AX Excel Tab in the Excel


Step 2: Select Add Data > Add table


Step 3: Select Main Account Table


Step 4: Drag important columns that you want to update


Step 5: Enter your data in the fields


Step 6: Select Publish to import the records in AX


It will also create a new sheet called Dynamics AX Status which will show you how many records were updated, and also any errors –if they occurred.

Step 6: If we return back to Dynamics AX, then we will see the data  has been uploaded.


Hope this little tip helps you. Leave me your feedback and comments!

Customer Advance Payment Process

In today’s post, I would like to bring another functionality of Microsoft Dynamics Ax 2012 which is customer advance collection transactions:

Step 1: Click Accounts receivable > Setup > Accounts receivable parameters.


Step 2: Click the Ledger and Sales tax tab. 

Step 3: Select the Sales tax on prepayment journal voucher check box to specify that sales tax must be deducted from payments with advance payment

Step 4: In the Posting profile with prepayment journal voucher field, specify the posting profile for the advance payment.


Step 5:  Go to Account Receivables > Journals > Payment > Payment Journal


Step 6: Click New and then Select Journal

Step 7: Click Lines


Step 8: Make your advance Entry and then go to Payment Tab. and mark prepayment check box, MS Dynamics AX 2012 will change the posting profile according to the prepayment setup on the module parameter


Step 10: Click Validate to check if the entry is correct

Step 11: and then click post

Step 12: Go to Sales & Marketing > Common > Sales Order > All Sales Order

Step 13: Create Sales Order, Invoice

Step 14: Select Open Transactions.


Step 15: Select the customer advanced collection.



Does this help you? Do leave me a comment to let me know!

Post Dated Checks in Microsoft Dynamics AX 2012

I wanted to introduce functionality of AX 2012 to your knowledge , and I am sure this is a a widely accepted and used practice in business.

Post-dated checks are checks which are delivered now with a date in the future, so that it cannot be cashed until that date.

Checks are one of the primary ways to make and receive payments and issuing of PDC is a very widely used practice across many businesses today. A post dated check is one which has a future date on it Microsoft dynamics AX 2012 brings the PDC functionality in both AR and AP modules with the financial dimensions, check printing, banking functionality and the settlements functionality.

In today’s post, we will take a look at the setup and processing of the PDC in AX 2012.

  1. First step is Enable PDC in Cash and Bank management parameter form.

pdc 001

Post journal entries for postdated checks: If this check box is marked, then financial transactions will be posted to the clearing accounts for vendor/customer using the account.

General journal for clearing entries: Select the journal which will be used to settle postdated transactions.

Transfer postdated checks to this payment journal: This vendor payment journal will be used to record the postdated transactions.

Now that we have done the required setups to enable PDC  in AX 2012, let us take a examine  at the transactions and other impacts by a PDC from a vendor.

Step 1:  Create a new method of payment under AP module and Mark the Bridging posting  for thismetg

Note**  when you select the Postdated check clearing posting checkbox, the bridge posting gets automatically checked and the bridging account defaults from the cash and bank Management > Setup > Clearing account for issued checks

Step 2: Create an AP payment journal and select the PDC method of payment


Notice that when you select PDC as the method of payment, the offset account automatically defaults which is the clearing account for issued checks.

Also see that the postdated check tab is enabled, when you click on it, you can enter other additional information related to the Check such as the maturity date, received date, check number, issuing bank and branch


After you post this journal, below is the financial voucher.


Users can view and track all the Vendor Post dated checks  in the AP > Common > Post Dated Checks form. When the check maturity date reaches, you can click Settle clearing entries button, and system automatically posts the general journal for this clearing entry. Screenshot below.


Note * – You can also click the Checks to send to bank button and system will automatically filter all the checks which have reached the maturity dates and needs to be sent to the bank.

You can also process and verify this in the AR module.

If you have questions, be sure to leave me a comment!