Dear Readers,
Rarely, I do marketing or campaign posts on my blog, but I'm thankful to Packt Publishers as they have in the past always reached me out to review some of the latest AX Technical books and it's content so on their 1000th Title celebration they are offering few surprises...
Read more..
Packt Publishing reaches 1000 IT titles and celebrates with an open invitation
Birmingham-based IT publisher Packt Publishing is about to publish its 1000th title. Packt books are
renowned among developers for being uniquely practical and focused. Packt books cover highly specific tools and technologies which IT professionals might not expect to see a high quality book on.
Packt would like you to join them in celebrating this milestone with a surprise gift – to get involved you just need to have already registered, or sign up for a free Packt account before 30 th September 2012.
Packt published their first book in April 2004. One of the most prolific and fastest growing tech book
publishers in the world, they now have books on everything from web development to web graphics, e-learning to e-commerce, IT architecture to games, and app development.
Packt supports many of the Open Source projects covered by its books through a project royalty
donation, which has contributed over £300,000 to Open Source projects up to now. As part of the
celebration Packt is allocating $30,000 to share between projects and authors in a genuinely unique
way, soon to be disclosed on their website.
Dave Maclean, founder of Packt Publishing explains, “At Packt we set out 8 years ago to bring practical, up to date and easy to use technical books to the specialist tools and technologies that had been largely overlooked by IT publishers. Today, I am really proud that with our authors and partners we have been able to make useful books available on over 1000 topics and make our contribution to the development community.”
For more information about Packt, the kind of books they publish, and to sign-up for a free account
before the 30th of September, 2012, please visit their website: www.PacktPub.com.
Tuesday, September 25, 2012
Wednesday, August 15, 2012
Troubleshooting Dynamics AX incorrect cost posted on Partial Project Purchase Orders
Issue:
We had an issue where Partial Purchase Orders (Project) was
not posting proper cost amount to the Project accounts.
Solution:
Note, the hotfix was in form of dis<layer>.aod file. I
extracted the .aod file and merged it on the local AX instance running on my
laptop, identified the classes which is required for the above fix, Did a
compare and imported only the code which fixes the issue.
Just a FYI on the classes which were impacted:
\Classes\InventMovement
\Classes\InventMov_Virtuel
\Classes\InventUpd_Estimated
SSRS Format Date tips
Hi there!
Recently, I was working on a SSRS Report wherein I need to use the Format function of SSRS for date formatting.
e.g. Format(Parameters!Date.Value,"dd-MM-yyyy")
Note here, if you use "mm" (lowercase), then it won't produce the proper results, as it's case sensitive and we need to pass "MM" (uppercase)
I found the below link useful which describes more on Format function in SSRS - (A good read)
http://thavash.wordpress.com/2007/04/10/working-with-dates-in-reporting-services/
Recently, I was working on a SSRS Report wherein I need to use the Format function of SSRS for date formatting.
e.g. Format(Parameters!Date.Value,"dd-MM-yyyy")
Note here, if you use "mm" (lowercase), then it won't produce the proper results, as it's case sensitive and we need to pass "MM" (uppercase)
I found the below link useful which describes more on Format function in SSRS - (A good read)
http://thavash.wordpress.com/2007/04/10/working-with-dates-in-reporting-services/
Saturday, August 11, 2012
World Vision Implementing Microsoft Dynamics AX
Another feather in cap, for Microsoft Dynamics AX :).. Read more here...
http://www.microsoft.com/casestudies/Microsoft-Dynamics-AX/World-Vision-International/Humanitarian-Group-Enhances-Children-s-Lives-with-Advanced-Supply-Chain-Management/710000001227
http://www.microsoft.com/casestudies/Microsoft-Dynamics-AX/World-Vision-International/Humanitarian-Group-Enhances-Children-s-Lives-with-Advanced-Supply-Chain-Management/710000001227
Monday, July 30, 2012
SQL Server CTEs and Recursive Parent Grouping in Advanced Mode Group Properties in SSRS
Hello!
Few weeks ago, I was developing an interesting report in SSRS which pulls out data from AX - Projects module.
It was interesting for 2 reasons:
1. I learned to use more effectively SQL Server CTE's (Common table expressions) while developing this report.
From a layman's perspective, CTEs were introduced since SQL Server 2005 and it’s more useful to do a recursive search (display hierarchical data e.g. employee-manager, BOM etc). In my scenario, I had to do a recursive search for Project-Parent Id in my Stored proc)
Below sharing some links, which will explain further more in detail about CTE's and how to implement them.
2. The second concept was about recursive
parent Grouping (in SSRS)
In SSRS, we can group the child field based on the
recursive parent key (There’s an option in the Edit Group > Advanced Section
to key in the Recursive parent field) – explained here in this blog - http://sql-bi-dev.blogspot.com.au/2010/08/recursive-hierarchy-group-in-ssrs-2008.html
Few weeks ago, I was developing an interesting report in SSRS which pulls out data from AX - Projects module.
It was interesting for 2 reasons:
1. I learned to use more effectively SQL Server CTE's (Common table expressions) while developing this report.
From a layman's perspective, CTEs were introduced since SQL Server 2005 and it’s more useful to do a recursive search (display hierarchical data e.g. employee-manager, BOM etc). In my scenario, I had to do a recursive search for Project-Parent Id in my Stored proc)
Subscribe to:
Posts (Atom)