Sumit Potbhare

Microsoft Dynamics AX for Retail

Archive for the category “AX for Retail”

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.



ePOS | AX 2012 R3 | Declare starting amount using multiple currency

Hi Guys, Hope you are keeping up with RetailDAXing. In last few weeks I got many questions on “how to declare start amount in multiple currency“. Although this is not something which is provided out of box at POS, but I will show you how to achieve this with minor customization.
NOTE: We will only go through the functional side of this enhancement. You need to discuss this with your DEV team for Customization.

Read more…

AX 2012 R3 | Statement Posting| Part IV: Hotfixes

Hi Guys, Hope you are keeping up with RetailDAXing. I hope you might have gone through my previous post on Statement posting where we have covered various setup and process. This is the 4th part of my Statement posting blog series. In this blog I would like to share different hotfixes that has been introduced in the latest CU12 update. Below is the list of all such issues that you might encounter in the previous updates that is fixed in CU12. Read more…

AX 2012 R3 | Statement Posting| Part II: Retail Parameters and Batch Configuration

Hi Guys, Hope you are keeping up with RetailDAXing. I have started a blog series where we will go through different setup and ultimately the operation about Statement posting which is a key operation in Retail module. This is the 2nd part of my Statement posting blog series. In this blog we will see, few more setups required in Retail parameters and batch configuration.

Retail Parameters

The posting section in Retail parameters form is used to specify parameters that are used to post discounts, inventory updates, settlements, and other retail operations.

Discount specific posting

Read more…

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…

Retail Configuration | Copy from Source to Destination environment in AX 2012 R3

Hi Guys,

In this blog, we are going to see, how can we copy different setups from one environment to another, without any development. You might have come across the different tool to transfer the data from Test to PROD environment, but here we will have a look at the most simple tool i.e “Definition group”.

With “Definition groups”, you can export a single table or group of tables (for a particular set of configuration), that can be directly imported in the destination environment. The “Definition groups” when exported create DAT and DEF file which is required at the time of import. However during import you only select the DAT file. Read more…

Post Navigation