Sumit Potbhare

Microsoft Dynamics AX for Retail

Archive for the month “May, 2017”

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…

Post Navigation