Past week I had a really an simple task a head, I have to find the Dynamics SL version from Database as I have written different logic in Sales order integration for each version.
I thought how hard could be that to get Current Version, I was wrong.
1. I tried to check setup Tables for column name "Version" in Dynamic SL System Database e.g. Custom, CustomVBA, Registration and few more. No success
2. Then tried to find column Name "Version" in SL Database, which also did not helped as there are few table in SL Application and System Database Column name as "Version" but no way related to Dynamics SL build Version.
3. In SL7.0, I found a glimpse of hope when I found a procedure "GetVersion" , which return Current build Version on System Database, Immediately realized that this Procedure have a select Statement with hard code build version. But the problem was, this Procedure does not exists in SL5.5, SL6.0 and SL6.5. I need a Solution which works for any Dynamics SL Version.
4. Solution :
Dynamics SL Current Version is maintained in Column "S4Future01" in Table : "GLSetup". Nice Place to hide.
Query:
"SELECT S4Future01 FROM GLSetup"
Hope this will be helpful, rather than trying trail and error methods I have been through.
No comments:
Post a Comment