Reason Code Functionality on POS -Ax 2012

In today’s post, I would like to share Reason Code functionality on POS. We often conduct transactions that need a reason or comment. Microsoft Dynamics AX has come up with reason codes in which we can define reason behind of the transactions. I would like to share how we can use this functionality over AX POS

Step 1:  Go to Retail > Setups > Reason Codes


Step 2: Create new Reason Code

Step 3: Type reason Number, description and input type sub codes to associate more sub codes in reason code or you can go for text to if you just want write something as a reason.


Step 4: Create Sub Codes


Step 5 : In General mark the check box


Step 6 : In Printing mark check box if you want to Print the reason code on the receipt


You can define where you want these reason code to be apply:

Go to Retail > Setup > POS > Profile > Functionality Profile



Step 8: now run the JOBS

You can see over POS reason code will be applied


You can also review on HQ which transaction has been perform on that particular reason Code

Go to Retail > Setup > Reason Code > Reason Code Transaction



Mix and Match Discounts in Dynamics AX 2012

Retail generally has a large amount of discount scenarios of each of which must be catered to through Dynamics AX 2012. One of our customers was looking to apply some discounts that needed to be mapped in the system as well. I have mentioned a scenario that I faced and the solutions I came up with this


Case 1:  Buy 1 item 000004 and get 1 item 000016 free throughout the year. And these items can sell separately too with their respective prices

Case 2: 10% discounts to all products in spring season.

(In spring season both discount cases need to be apply)


Case 1 Buy one Item 000004 and get item 000016 free

Step 1: Go to Retail > Common > pricing and discounts


Step 2 Create New Discount

Step 3: In price/ Discount Tab go to Line Spec


Step 4: In lines; I have selected the item 000004 with 0.00% Discount and for item 000016 I have mentioned 100% discount as this item is going to be free with the item 000004 ( this will be apply through out the year)


But problem occurs when the we have spring discount (CASE 2) also Applying In item 000004 and 000016 so what I did is; in item 000004 I have mention discount 10% in lines, if I don’t mention 10% discount over here then Case 2 will be not apply for 10% discount on item 000004 while 000016 Item has been taken at 100% discount as it is going to be free with 000004 item



Step 6 : Change the Status



CASE 2: Get 10% discount on all products in Spring Season

Step1: Go to Retail > Common > pricing and discounts > Discounts


Step 2: Create New Discount

Step 3: Select Retail Price Group and in Concurrency select Compounded from Top Down list


Step 3: Select Discount 10%


Step 4: Select Validation period


Step 5: In lines select products which you want to apply 10% discount


Step 6: Change the Status


Now run the discount JOB and Check POS Applying both discounts in spring season


#TipADay: Credit Note Functionality On POS in Dynamics AX 2012

Here is little tip how Credit note functionality works on Microsoft Dynamics Ax 2012 POS

Following are the few steps required to apply credit note in AX 2012

Step 1: Go to Retail > Setups > Payment Method

CN -1

Step 2: Create method of payment for Credit note and associate appropriate Posting account in it

Issue Create Note

Step 3: Now go to POS Select Return transaction


Step: 4 Click Issue Credit Note


Credit Note will be issued and transaction will be done

Step 5: Now we can check if credit note has been issued or not

Go to Retail > Inquires > Credit Memo

new 1

Apply Credit Note:

Step 1: Enter Sales Transaction and then Select the payment option; that is pay with Credit Note


Step 2: Select settle balance with cash or settle with new transactions

In this example I have chosen Settle balance with cash



Step 3: Enter the credit note Number


Step 4: Now we can check if Credit note has been applied or not

Go to Retail > Inquires > Credit Memo

new 2

You will notice that applied check box is now marked.

#TipADay: Copying Data Between Companies using Excel Add-in

Hello everyone

Here is little tip on how to migrate data through Excel Add-In  . Through Excel Add-in you have the option of selecting what instance, partition, and company that you want to upload and publish to.

Let us work on how we can use the Excel Add-In to copy data between entities.

I have not loaded all of my base data, so we will use our main company as the template to load the data.


From the Dynamics AX tool, select the Options button and select your base company from where the data will be copied

To create a linked worksheet within Excel, select the Dynamics AX bar, and then from the drop down menu of the Add data button, click on the Add Tables option


This will open up a table selection dialog box. Then select the table that you want to add in sheet


You will initially have no records showing. To view all of the data that is in the company, select the Refresh button


Now change the Legal Entity that will be used just by selecting it from the drop down list.


Then we will save the data from  original company for reference. This will make it easier to cut and paste the data back into the new company. So we just select all of the original table, and then copy it.


Now that we have the template data saved we can continue on. Return back to the linked table, and then select the Refresh All option there is no data in the other company then the linked table will be blank.


And  now you can see in the below image, there is no data in the other company so linked table will be blank. Select the template data that you saved and then paste it into the linked table.


Now from the Publish menu, select the Publish All option


Now you can check the Publishing Status ,Your data will be copied from one company to another.

Try this tip, Copy a lot of the base data from another existing company, and  save your time

Enjoy Reading!

#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!