Stuart Blackler

.Net Software Engineer

© Stuart Blackler 2013

SAP Business One V9 Version Strings

Today I had to figure out what the current version of SAP Business One is. In order to do this, I looked at the table SFMD inside of SBO-Common and found the following results:

Version |   Patch Level
-----------------------
900046  |   00
900052  |   01
900053  |   01 Hotfix 1
900055  |   03
900056  |   04
900058  |   06
900059  |   07
900060  |   08
902000  |   09
902001  |   09 Hotfix 1
902002  |   10

Note: I added the Hotfix 1 to clarify. I believe these are correct, I can't find a definitive source to verify these results.

Then in order to check the target databases version, I ran the following against the target database:

SELECT [Version] FROM [CINF]

There might be a better way of doing this. This article proposes a single solution. If you have an alternative solution, please notify me through social media or the comments below.

Comments

Developer Links (Feb 2014)

Here are the things that I have found most interesting during the last month (It's late as I've been on holiday)

Code

Html/Css/Javascript

Projects/Frameworks

Mobile

Other

SQL

Web

Comments

Adding to Technorati

BJ5S6VR5ADGE - This is my Technorati shortcode. This verifies that I am the owner of the blog. I have decided to claim my blog at Technorati in order to extend my reach. To this effect I will start posting links to the relevant places in reddit and slashdot.

Adding your blog to Technorati

To add your blog in Technorati you will have to sign up first at Technorati, update your profile, and at the end of page you will get an option to claim your blog.

Enter the details to claim your blog and you will be provided a short code which should be present in a post on your blog by email and on the profile.

Login in your admin area of blog, add new post or edit any existing post and add the short code provided by Technorati in the body of the post like in this post.

That's it.

Comments

Post Archive

11 Jan 2014
Website Optimisation 2014

05 Jan 2014
Developer Links (Jan 2014)

04 Jan 2014
2014 - A year ahead

23 Nov 2013
HTML 5 API's 3/5 - Drag and Drop API (Exam 70-480 Prep)

23 Nov 2013
Codename RyuJit - The future of JIT compilation on .Net

10 Nov 2013
HTML 5 API's 2/5 - Geolocation API (Exam 70-480 Prep)

09 Nov 2013
Nokia Lumnia 1020 First Impressions

05 Nov 2013
HTML 5 API's 1/5 - History API (Exam 70-480 Prep)

10 Jun 2013
Becoming A Microsoft Certified Professional

30 May 2013
Correctly Raising Events in C#

06 May 2013
Using IDisposible correctly

11 Mar 2013
Semaphore vs SemaphoreSlim - A performance benchmark

11 Mar 2013
Introducing BMark Version 0.1 - A .Net Micro-Benchmarking package

07 Mar 2013
Implementing The Observer Pattern

25 Jan 2013
System Databases and Backups

13 Dec 2012
SQL Server - Notes on SARGability

13 Dec 2012
DELETE vs TRUNCATE

30 Nov 2012
SQL Joins for Beginners

29 Nov 2012
Website Update - Almost there now

18 Nov 2012
Website Update

15 Jun 2012
Tempdb Health Check Queries

30 May 2012
SQL SERVER Fix - Token-based server access validation failed with an infrastructure error

22 May 2012
SQL Server 2012 - Training and Update Kit Freebies

06 Apr 2012
Indexing SQL Server - Clustered Indexes

29 Mar 2012
Reflection vs Caching

25 Mar 2012
Resetting the Windows Search service to default using Powershell

08 Mar 2012
Quick SQL Server research notes

08 Mar 2012
MVC 4.0: Bundling and Minification Bug

18 Feb 2012
Introduction to Functional Programming

18 Feb 2012
Basic Programming in Haskell

30 Dec 2011
Flicker Free Forms and ListViews in .Net

01 Dec 2011
Extension Methods In .Net

15 Nov 2011
Using XML in SQL Server 2008

12 Nov 2011
Asynchronous File IO in .Net

01 Nov 2011
Protect Files and Folders Using HttpHandlers in ASP.NET