Sumit Potbhare

Microsoft Dynamics AX for Retail

Archive for the tag “Ax 2012 R3”

ePOS | AX 2012 R3 | Income account transaction

Hi Guys, Hope you are keeping up with RetailDAXing. In my previous blog we have seen the Expense transaction at POS. In this blog we are going to see the Income account functionality at POS and how it post to Trial balance. Income account transactions are done when we put cash into the cash drawer for a reason other than a sale like selling of piled up Daily newspaper, magazines, local community club uses the parking lot for car wash and provides you with payment etc.

Setup Income accounts

To start with, we need to setup Income accounts on store card. There is no centralized setup for defining Income account because each store might want to reflect the postings in separate account.

  • Go to Retail >> Common >> Retail Channels >> Retail Stores.
  • Select the store and click Setup tab.
  • Under Setup action pane >> Income/expense account.

Snap 2017-06-05 at 14.47.17

Field Description
Account number Enter a unique identifier for the income account or expense account, such as “sales,” “COGS,” or “returns.”
Name Enter a name for the income account or expense account.
Search name A simple name that can help you find the income account or expense account when you search.
Account type Select Income or Expense to specify the type of account that you are setting up.
Ledger account Select the number of the general ledger account for the income account or expense account.
Name The name of the ledger account that you selected.

Setup Income account operation button on screen layout

Snap 2017-06-05 at 14.49.02.png

  • Once setup is done, run 1070 and 1090 scheduler job to replicate the setup to POS.

Operation at POS

Click on Income account button.


Select from different Income type setup on the store.Snap 2017-06-05 at 14.52.47.png

Enter the amount for the Income.Snap 2017-06-05 at 14.53.00.png

Now complete the transaction using the payment method that you receive the amount.Income2.png

Run the P-job to pull the transaction to DAX.

Statement posting & Trial Balance

Snap 2017-06-05 at 15.32.39.png

Retail Store transaction inquiry

Snap 2017-06-05 at 15.32.56.png

Income account transaction

Snap 2017-06-05 at 15.33.08.png

Payment transaction

Now lets proceed for Statement posting.

Snap 2017-06-05 at 15.38.55.png

So we have account number 112100 defined on the Cash account for the store Cash payment method and 401100 defined as Income account.

Snap 2017-06-04 at 16.28.41.png

After Statement posting –

Snap 2017-06-05 at 15.41.00.png

Snap 2017-06-05 at 15.41.54.png

Snap 2017-06-05 at 15.44.31.png

Feel free to reach out for any clarifications. If you like my blog posts then comment and subscribe to the blogs.

Please follow me on Facebook | Google+ | Twitter | Skype (sumit0417)

Enjoy RetailDAXing.

Disclaimer: The information in the weblog is provided “AS IS”; with no warranties, and confers no rights. All blog entries and editorial comments are the opinions of the author.



AX 2012 R3 | Statement Posting| Part I: Introduction and Setup

Hi Guys, I hope you are keeping up with RetailDAXing. This blog is my another effort for sharing information about the most important part in the Retail module which is Statement Posting. I have kept this in multiple parts for better understanding.

In this blog, we will go through some Introduction and setups required to drive Statement posting.

What is Statement?

  • Retail documents that contain a collection of inventory and financial transactions from POS for a given store over a specified period of time.
  • Transactions can be posted in detail or aggregated.
  • Posting of a statement will create and invoice Sales orders, create payment journals and settle against the Sales invoice.
  • Provides consistent tracking and referencing of sales across channels

Read more…

AX 2012 R3 CU12 | Cortana Intelligence Service management module

Hi Guys, In this blog I would like to share some information on Cortana intelligence services (CIS) management which is a new module that introduces machine learning capability in Microsoft Dynamics AX 2012 R3 CU12. This might have a positive impact in changing the way Retailers provide meaningful up-sell capabilities, generate related products to attract customer and also send email for product recommendation using Customer purchase history.

CIS.png Read more…

Retail Scheduler Job – Apply failed | The given value of type String from the data source cannot be converted to type datetime of the specified target column

Hi Guys, Hope you all are keeping up with RetailDAXing. In this blog, I will help you troubleshoot one of those many scheduler job errors which annoy everyone. Sometimes it gets very hard to troubleshoot and find the exact reason for the cause. This is my small efforts to help you with these error.

This blog is about the error you get in the Download session form under message column-

ApplyFailed.png Read more…

AX 2012 R3 Benchmark | Retail and Distribution

Hi Guys, I have been working on POS performance from last couple of days and found few interesting information that I would like to share with you.

Microsoft conducted a 24-hour “day in the life” benchmark of Microsoft Dynamics AX 2012 R3 to measure the application’s performance and scalability characteristics when running retail and distribution workloads. The benchmark ran a variety of functional scenarios that use different client and integration technologies, thereby providing a broad view of enterprise resource planning (ERP) workload performance on AX 2012 R3.


Read more…

Loyalty program in Dynamics AX for Retail R3

In this post I will focus on the enhanced Loyalty program feature in Microsoft Dynamics AX 2012 R3. AX 2012 R3 gives the flexibility to configure the loyalty tier and complex earning and redemption rules. In this blog we will have a walk-through on the loyalty tier configuration where in the Loyalty Customer has to earn few designated loyalty points to reach to the next loyalty tier. In Retail business, Tiered loyalty programs are customer loyalty programs that give various benefits based on tier a customer is in.

The tiers are set with milestones that a customer must achieve to proceed to the next tier. These milestones are usually amount spent on Retail sales by the customer, but they can be anything. I have seen retailers using the number of orders, number of quantity purchased, and an increasingly popular one is total loyalty points earned.This is one of the requirement for loyalty program that is widely used by many of the Retailers. These types of programs can have an impact on bottom-line results if executed successfully. Few Customers increased their spending or changed other purchasing behavior in order to achieve a higher tier status in a rewards program. This can benefit the Retail in terms of more sale in their pocket.

To start with we will first look at the loyalty program structure in Microsoft Dynamics AX 2012 R3.

Read more…

Renaming field name text (RetailLanguageText) on POS screen in AX 2012 R3

Hi Guys, I am here with a new information on Dynamics AX for Retail. Most of us might have encountered a scenario where we require to rename the text for few of the fields on AX 2012 POS screen. For instance if you want to change the text which is above the numpad – Search or enter quantity to Entry (as shown in screenshot)


This can be achieved through the Customization from backend with the help of a developer. But here I will tell you how to do this without any technical help and simply through configuration.

So to start with, you have to first make the field numbers visible on the POS screen. This field numbers are very helpful when changing the field names. On the POS desktop shortcut, right click and click on Properties. Read more…

Inventory Lookup screen and Store locator group assignment in AX 2012 R3 POS

Hi Guys, this blog is related to the most simple form in POS. Untill now I was under impression that the Inventory lookup just utilize the Real time service to show the Inventory for the Retail stores, but I discovered a new feature in AX 2012 R3 to restrict the number of stores in the Inventory lookup screen. You might have experienced an issue that the stock is not showing up for other stores on Inventory lookup screen at POS. The Inventory lookup screen is blank.

You might have seen the Store locator group form under Retail >> Setup >> Store locator group , this form can be used to restrict the number of stores on the Inventory lookup screen at POS.


Read more…

Configure & Troubleshoot “Modes of delivery” on shipping and delivery screen on AX 2012 R3 POS

Hi Guys, this blog is meant for mode of delivery control on the Retail channel. As in previous versions of AX 2012 RTM, where all the modes of delivery were used to get populated on the shipping and delivery screen, which has been improved now to have a control over modes of delivery on the basis of products, country/state and Retail channel combination. This is a everyday requirement for all the Retail Industries to ship the products out to the customers out from the Retail channels. Also to identify which type of products and from which country are being shipped by what mode to the customer. This makes it easy for the salesperson to select the modes that are being used by that particular store and should not end up with wrong selection of mode of delivery.

After creating the modes of delivery under Retail >> Setup >> Distribution >> Modes of delivery, its time to setup the Retail channel, products and Address. Lets create a new mode of delivery 88 – Non standard and proceed with the setup.

S1 Read more…

Post Navigation