Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6500 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:“Alias” in Analytical Accounting

Hi all

Wish you all a wonderful new year and may the new year brings in joy, prosperity, happiness and satisfaction to all of you.

Today, lets have a sneak peek into a little functionality in Analytical Accounting, which I believe would benefit many people using Analytical Accounting for the purpose of their analysis reports.

As all of you are aware, during transaction entry, we enter the transaction dimension codes in the analytical accounting window as we enter the transactions. When the analytical accounting window opens, the focus of the cursor is placed in the Alias field. Most of the users generally transfer the focus into the Transaction Dimension code in the scroll window below and start entering the dimension codes relevant for the specific distribution line. I have even seen requirements coming from users to write a simple customization to shift the focus into the dimension code field when the analytical window opens up. This negates the whole purpose of the Alias field. Lets analyze it a little on this.

If there is just one transaction dimension defined in the system, it might not be a big issue. But assume the case where there are many transaction dimensions defined and we need to enter values for each of these dimensions for every distribution line of a transaction. It definitely becomes a cumbersome and a lengthy process. This is where the Alias comes into effect and can drastically improve the efficiency in the way the analytical accounting window is used in transactions.

The Alias Maintenance window opens from Cards >> Financial >> Analytical Accounting >> Alias.


Once we specify the alias name and tab off, the system displays all the dimensions defined in the system in the scrolling window below. The user can then specify the dimension code (if applicable) for the dimensions listed on the scrolling window. We can define as many alias with as many combinations of the dimension codes. We can copy existing alias into a new one (or) we can also import the alias information from an excel file which has been setup in the required format.


The format of the excel file should be as shown below.


Once all the required aliases have been defined, we can use them at the transaction level. When the Analytical Accounting window is opened for the distribution lines, the focus is at the Alias field. We can enter the appropriate alias manually (or) selected from the lookup. Once the alias has been picked up, the application defaults all the dimension codes setup in the alias for the specific distribution line.

This way, we can also speed up the data entry time for entering dimension codes and also make sure that the probability of errors is minimized since the dimension codes are pre-defined in the alias and once the alias is picked up correctly, the dimension codes are defaulted for the distribution line.

This is a really cool functionality which I have noted in Analytical Accounting and I have decided to share it with you folks. I hope this tip is helpful for many people who are actively using analytical accounting to track multi-dimensional information.

Until next post…

Category:TIPS AND TRICKS BY MODULES: AA (Analytical Accounting)
Link Owner:
Date Added:June 21, 2010 04:09:36 PM
Number Hits:18
RatingsAverage rating: (0 votes)

No Reviews Yet.