27 May 2015
Posted by: Ricardo Pichler in: X++
Hello,
Very often I see developers doing a lot of code just to retrieve the keys and values of Financial Dimensions. To do that, you just need to list the values of DefaultDimensionView view, like you can see below.
1 2 3 4 5 6 7 8 9 10 11 12 | static void showFinancialDimensions(Args _args) { PurchTable purchTable = PurchTable::find("INT-000060"); DefaultDimensionView defaultDimensionView; ; while select defaultDimensionView where defaultDimensionView.DefaultDimension == purchTable.DefaultDimension { info(strFmt("Dimension's name: %1 - Value: %2", defaultDimensionView.Name, defaultDimensionView.DisplayValue)); } } |
Thank you Pedro!
[]s
Pichler
5 Responses
Sasha Nazarov
28|May|2015 1Hi
Thanks for the post. I had to use Google Translate to understand it, though.
Please consider writing in English, so more people could benefit from reading your blog.
Thank you.
Diego Araujo
06|Jun|2015 2Boa! tão útil que vou até dar um reblog!
Obrigado!
Ricardo Pichler
18|Jun|2015 3Thank you Sasha Nazarov.
Sasha Nazarov
18|Jun|2015 4Great, thank you!
Anderson Joyle
24|May|2016 5Just one advice: although this view is great to retrieve values from a exists DefaultDimension, it doesn’t show all dimensions in the system (only those in use, or used once).
For example: if a new cost center dimension has been inserted and yet not used, it won’t been displayed in the view.
Leave a reply
Search
Tags / Categorias
RSS
Arquivo
Blogroll
A design creation of Design Disease
Copyright © 2007 - Dynamics AX Brasil - is proudly powered by WordPress
InSense 1.0 Theme by Design Disease brought to you by HostGator Web Hosting. (Modified by Ricardo Pichler.)