Skip navigation

One of the great things about SAP Business One is how easy it is to build queries using the Query Manager andget access to the information you need thats stored inside your SAP Business One system.


But when you migrate to HANA, those queries need a little bit of maintenance to help them work with SAP HANA and the way it expects SQL queries to be formatted.


The good news is that theres some resources to help smooth the way for you put together by SAP (remember that many of these tools are provided "as is" and are not supported directly by SAP).


Heres a tool and some documents that will explain the process.

How to Convert SQL from the Microsoft SQL Server Database to the SAP HANA Database


This tool enables you to convert structured query language (SQL) in the Microsoft SQL Server database (using T-SQL grammar) to SQL that can be used in the SAP HANA database (using ANSI-SQL grammar).

The zip file includes the tool, a configuration file, a token file, an API example, necessary libraries, and a guide.



I know that our community members all have different ways to keep up with the content and updates that we share here on ONE.Source. With that in mind, i am pleased to start offering a new way to get your news - the ONE.Source Podcast.


Please let me know what you thought of this format and of course, what you would like us to cover to make the community even more valuable for you.


ASUG ONE.Source - SAP Business One Community Podcast - January 2018 by Richard Duffy | Free Listening on SoundCloud




Lately I have been getting quite fixated on SQL queries with SAP Business One, and looking around to see what queries are out there and where I can find them. (You've probably seen me blogging about them on our main blog. These posts were inspired by our most popular community post Useful SAP B1 queries which dates back to 2009.)


The good news is that there are a lot of queries that have been written and posted on various sites on the Interwebs.



But why go looking when you have ONE.Source and Richard Duffy as my personal information butler I hear you ask?



Good point - so here's a few useful ones I found from long time social collaborator, SAP Mentor and SAP Business One community member, Tim Guest.


You'll also find some additional tips about using the Golden Arrows for drill downs.




and kudos to Tim Guest (and Zal Parchem) for sharing their knowledge!



Open Invoices Not Emailed:

This query shows all AP Invoices added to SAP that are Open but have not been sent. It’s easy to forget to send invoices and this report has helped us be more efficient. Please note we are using Boyum Print and Deliver module:


SELECT t0.DocEntry, t0.CardCode, t0.CardName, t0.DocDueDate as ‘Due Date’, t0.DocCur, t0.DocTotal




WHERE t0.DocStatus = ‘O’ and (t0.Printed = ‘N’ and (SELECT count(*)


FROM [dbo].[@BOY_85_DEL_LOG]  s0


WHERE s0.[U_BOY_id]  = t0.DocEntry and  s0.[U_BOY_OBJECTID]  = ’13’ and  s0.[U_BOY_ACTION]  = 4) = 0)


Partial Stock Take

We needed a way to list items in stock AND items not in stock for stock taking so we can run an inventory report between locations. The Bin Locations Content report in SAP only shows items in stock:


select t0.ItemCode, t1.ItemName, isnull(t3.OnHandQty,0) as ‘In Stock’, t2.BinCode, t2.SL1Code, t2.SL2Code from OITW T0

inner join OITM t1 on t0.ItemCode = t1.ItemCode

inner join OBIN t2 on t2.AbsEntry = T0.DftBinAbs

left outer join OIBQ t3 on t0.ItemCode=t3.ItemCode and t0.WhsCode = t3.WhsCode

where t2.BinCode between [%0] and [%1]

order by t2.SL1Code, t2.SL2Code, t0.ItemCode


Items with No Default Bin Location

We want to report on all items in SAP not assigned a Default Bin Location. This has helped our Warehouse Manager to ensure ALL stock has a Default Bin:


SELECT T0.[ItemCode], T0.[WhsCode], T0.[DftBinAbs] FROM OITW T0 WHERE T0.[WhsCode]  = ‘main’ and  T0.[DftBinAbs]  is null


Purchase Invoice Analysis

The SAP Purchase Analysis report is in System Currency, mine is GBP. No use to me when I buy in EUR. This report shows all AR Invoices for a set period for a particular Business Partner in the currency on the Invoice (FC):


SELECT T0.[DocEntry], T0.[CardCode], T0.[DocDate], T0.[DocTotalFC]




WHERE T0.[DocDate] BETWEEN [%0] AND [%1]  AND T0.[CardCode] =[%2]


If you want to run the same report but on Purchase Orders, simply substitute OPCH for OPOR


Top 10 Customers (Thanks to Zal Parchem for this)


SELECT TOP 10 T0.CardCode, MAX(T0.Cardname) as Customer,  SUM(T0.doctotal) as “Amount(LC)”


WHERE t0.docdate BETWEEN [%0] AND [%1]

GROUP BY T0.CardCode

Order by SUM(T0.doctotal) DESC


Sales History by Item Group

Yes I know this exists in Sales Analysis reports but I prefer my layout:


SELECT T0.[DocEntry], T0.[DocDate],T0.[CardName], T2.[ItmsGrpCod], T2.[ItemCode], T2.[ItemName], T1.[Quantity]


FROM ORDR T0  INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode


WHERE T2.[ItmsGrpCod] = [%0] AND T0.[DocDate] BETWEEN [%1] AND [%2]


Sales Orders with no SLP Code

Some of our Sales People forget to enter their name when adding a Sales Order. This handy report helps me identify these quickly and easily


SELECT T1.[DocNum], T1.[CardName], T1.[DocDate], T0.[SlpCode]




WHERE T0.[SlpCode] = ‘-1’


ORDER BY T0.[SlpCode]



In addition, Barbara Peterson asked on the Q and A Forum about getting the Golden Arrow to show up on her queries - I gave here an aswewr and you can view the thread here


Formatted Seach


But I thought you might find these tips from SAP handy as well when you aren't getting the love you need from the Golden Arrows in your queries


Your Golden Arrows may not show when one of these conditions occurs:


1. The field does not represent keys of a table.
2. Queries that contain groupings.
3. Queries that are based on Archive tables ("A" tables).
4. Queries that contain UNION clause.
5. Queries that contains temporary tables.
6. Queries for Formatted Search.
7. Queries with parameters declared.
8. Queries with certain restricted names in comment section

Also add the "FOR BROWSE" statement at the end of your query.

FOR BROWSE means that the result displays the orange arrow to navigate into the master record or document behind it.





Other terms



Orange arrow, query, missing, drill, browse, golden arrow, link buttons, hide, foreign keys, SQL, appears,



It goes without saying that when you are building queries and reports that you need a good reference to the database structure of application and of course SAP Business One is no different.



There are a couple of ways to determine the database structure of SAP Business One but as I was doing my regular trawling around the internet looking for handy resources to share I happened to stumble across this little gem.



SAP Tables - SAP Business One/ERP Table Definitions



This site allows you to select the B1 version and gives you a breakdown of the tables and fields.



A great resource to pin to your Bookmarks Bar in my opinion.



i hope you agree


At the recent BizONE Conference in Anaheim, I had the opportunity to catch up with Rob Burke from McCroskey Mattress Company, a long time user of SAP Business One and we got to chatting about performance tuning SAP Business One on SQL Server and what were the basic things that should be done to keep your SQL Server running at its optimum.



In prior years you would need to set up a number of manual SQL Maintenance jobs to re index and compress the databases as a starting point, not to mention running the regular backups of the data.



The good news is that now, with the Remote Support Platform you can set up those tasks based on downloaded tasks that come in from SAP as well as a number of other repair and system validation checks.



Theres also a number of other things to look at with the setup of your SQL Server deployment that I wrote about a few (actually more than a few) years back so i thought I would post them here as Rob dropped me an email following up on our conversation yesterday.




So here's the links for you Rob and for anyone else that may find them well as some other blogs and contributions from others in the general B1 community



Rob also was asking about the impact of increasing the number of cores on their SQL Server and whether or not this would force them to generate a new license key.

This one is open to conjecture - my understanding is that if all you are doing is allocating more cores to SQL Server (from the SQL Management Console) then it wont impact it - the disabling of the license key when there are major changes was introduced to prevent moving from one machine to another so this shouldn't really have an impact.


But if it does, of course, you can generate a new license key immediately as long as you have an S number and access to the rights to generate a key, which your partner should have given you.


Here's a short video that shows you how to do it


Between 2009 and 2013 I had the opportunity to build a lot of videos designed to introduce the various functional capabilities of SAP Business One - I started when Version 8.8 was the current release and continued through until Version 9.x.


In that time, I built quite a lot of content covering the majority of  functions in SAP Business One and over time, I got a lot of feedback that the videos were helpful not only for learning about B1 when deciding if the solution was the right one but partners and SAP Business One users all around the world used the videos to help them learn SAP Business One and deploy the solution.


So that's why in a lot of these videos, I refer to myself as a member of the SAP Business One Global team...



SAP Business One Video Content Central


So now that I am here helping out the ASUG team with the SAP Business One Community, we thought it would be a great idea to bring all these videos in and centralise them into a single access point - that's the purpose of this page - over time all of the various videos I have built will be indexed and catalogued here for you so that you can use them as a resource to find the answers you need and the guidance on using and deploying the solution.



A quick point to note, even though some of these videos go back as far as Version 8.8 they are all still relevant - in fact in many instances the functionality is exactly the same, only the look and feel of the Business One menus and cockpits have changed as well as some background plumbing that of course made the solution more robust and faster.


So there's a very strong chance that even though the "skin" of B1 may look different these videos will still apply - so we hope you enjoy having access to these and of course, give me your feedback if theres a topic that is missing - if its not on the drawing board to produce already i'll see what I can do to get it there for you!

Video TitleVideo Link
Quick Synopsis
Date Published
General Topics
SAP Business One IntroductionIntroducing SAP Business One

A quick introduction to the background of SAP Business One

and the overall solution

SAP Business One CloudSAP Business One CloudAn introduction to SAP Business One Cloud using Ericom Connect as the web client
SAP Business One Workflow and ApprovalsSAP Business One Solution - Workflow, Approvals, & AdministrationAn overview of the Workflow and Approvals features of SAP Business One
SAP Business One AlertsSAP Business One Alerts Functionality (Overview Video) Alerts are now standard in most solutions - here's how it works in B1
SAP Business One AuthorisationsSAP Business One Authorization Functionality (Overview Video) Limiting access to functionality is a key requirement for many businesses and this video explains how
CRM Topics
SAP Business One Campaign ManagementSAP Business One - Campaign Management An underappreciated area in SAP Business One - build marketing lists and execute campaigns via B1 or external tools
SAP Business One Service ManagementSAP Business One Solution Service Management Service management is about more than just servicing equipment - if you have customers you can use this module
SAP Business One Sales Opportunity ManagementSales Opportunity Management Why buy Salesforce when you have Sales Opportunity Management inside SAP Business One?
Logistics and Production Topics
SAP Business One MRPSAP Business One Solution - Material Requirements Planning (MRP)MRP can be complex and hard to understand - but in SAP Business One its straight forwards once you get the basics
SAP Business One InventorySAP Business One Solution Inventory Management More than 60% of all SAP Business One customers buy and/or sell inventory so its a key component of the solution - heres the basics

SAP Business One Light Manufacturing

SAP Business One Production Management A growing function in SAP Business One, this video looks at the basics of the manufacturing functions in B1
SAP Business One InvoicingSAP Business One Automated Invoice Management (Overview Video)
SAP Business One HANA
SAP Business One Analytics powered by SAP HANA

SAP Business One HANA: Interactive Analysis


SAP Business One HANA: Dashboard 1
SAP Business One HANA: Dashboard 2

SAP Business One HANA: Dashboard 3

Purchasing Topics
SAP Business One Purchasing Management
SAP Business One Purchase Request
Finance Topics
SAP Business One Finance OverviewSAP Business One Financials Module (Overview Video)Almost every transaction ends up in the Finance module - this overview video explains the components of the module
SAP Business One BankingSAP Business One Solution Banking Management (Overview Video)Managing and recording cash and banking transactions is critical for all businesses - we'll take a look at the functions in SAP Business One
Reporting Topics
An overview of SAP Business One ReportingSAP Business One Solution Reporting Management (Overview Video)Reporting is always a hot topic for any ERP solution. Here's the core of reporting in SAP Business One
SAP Lumira: BI for SAP Business OneSAP Lumira (Overview Video)SAP Lumira allows you to prepare and visualize your SAP Business One data

And more...


Here is a list of other videos that we will add into the matrix above with more details:



Often times you need to track different activities in SAP Business One, manage KPI's or generate ad-hoc data sets for further analysis. The SAP Business One Query Tools are great to do this but sometimes it can take a while to master the process of building queries and understanding the different concepts of table joins asnd also the data structures in SAP Business One.


This is where the assistance of your peers can be invaluable to help you understand how something is achieved. If you are like me, when you are trying to understand how a technology works it's helpful to have examples to refer to and its even better when those examples can be leveraged in day to day operations of the solution.



Fortunately I found a recent scenario on the Facebook group I moderate ehre a member of the group wanted to find out  which suppliers were late with their deliveries and two other members stepped up and provided the necessary queries to assist and they agreed to share them with you here.



Heres the first that shows the deliveries that were late written by John Eduardo Alfaro Vivanco from Cartagena in Bolivia



SELECT A.DocEntry , A.DocNum , C.DocDueDate AS FechaEntrega , A.DocDate
INNER JOIN OPOR C ON B.BaseEntry = C.DocEntry

WHERE A.DocDate > C.DocDueDate
GROUP BY A.DocEntry , A.DocNum , C.DocDueDate , A.DocDate


And another variation that shows deliveries not yet received that are running late written by Joerg Aldinger from SAP Business One partner Consultoria in the Dominican Republic


SELECT T0."DocNum", T0."CardCode", T0."CardName", T0."DocDate", T0."DocDueDate" FROM OPOR T0 WHERE T0."DocDueDate" < CURRENT_DATE AND T0."DocStatus" = 'O'

For MS SQL instead of HANA exchange the string CURRENT_DATE for GETDATE()..


Thanks to both John and Joerg for their willingness to share their work.

One of the core challenges that many organisations face is managing their SAP Business One implementation in a cost effective and time efficient manner.

SAP are continuing to focus on this area and I will talk more about that in my upcoming webinar on the SAP Business One Roadmap and you'll see this as we drill down in to the new 9.3 release.

I wrote a couple of LinkedIn posts on the SAP Business One Cloud Control Center and I got the feedback that people would like some detailed training on how to deploy the technologies behind that and so I have gone down that path and built the sessions (and continue to do so).

So here are the sessions that I have built and I would encourage you to come along to my Moving to the Cloud session at the upcoming Biz.ONE Conference to learn more about how you can continue to leverage these technologies.

Session 1Session 2

For many small businesses, the deployment of an ERP system is done in response to a specific set of challenges that exist in the business at a given point in time.


With the problem solved, they then move on to other pressing issues but in my experience there is a big opportunity that is going begging and that is around the concept of what the Japanese call Kaizen - constant improvement.


A great approach is to stop and review what has been achieved as the result of deploying SAP Business One and what are the other ways that you can utilise the solution to help drive efficiency in your business.



Often times, it's an area that you may not want go to as there's a concern that there will be additional money that needs to be spent on licenses and consulting services and of course, thats an option and you'll do a cost-benefit analysis to determine if it makes sense but there are many ways that you can potentially utilise your existing investments to greater effect.



A big area is the under-utilisation of the CRM and sales force automation capabilities of the solution - quite a few organisations have gone out to market looking for a best of breed CRM solution to plug in to their SAP Business One solution because they may not have really mapped out what they are looking to achieve and end up focusing on the tools that are available and what they claim they can do.




Many times, particularly with organisations that deploy Salesforce as an example, they end up only using 25% of the available functionality - and apart from some of the benefits of the web and mobile UI of Salesforce, the functionality that gets deployed is already existent inside SAP Business One.


This coming November, we are going to have a focus month where we'll deliver a few sessions and a focused webinar designed to specifically help you build  your strategy and systems alignment plans for 2018 so mark your diary to attend the sessions and if you're heading to the upcoming Biz.ONE conference in Anaheim, make sure you plan to attend my 2 sessions on moving to the cloud and reporting as both of these sessions will align to this concept of mapping your systems, strategy, skills and staff to drive better business outcomes.



I am a big fan of the McKinsey 7S Model for business planning and alignment of strategy and tactics - we used it at Great Plains Software in the 90's and the approach helped to contribute to the exponential growth of the company and the team's ability to adapt to and drive that growth - so I would encourage you to take a look at this document that talks in more detail about the model - I'll be referring to this quite a lot as we discuss this process and its a good primer to focus your thoughts and start the 2018 planning process.



One of the benefits of your ASUG membership for our ONE.Source community is access to our series of 15-Minute Fundamentals sessions, offering basic training videos for SAP Business One users.


These are primarily focused on new users, but should also be helpful to experienced users if you need a quick reminder of how the core functionality in the solution works.


Bookmark this page,  because as the sessions are published they will be added on to this page so you have a single place to go to get access to all the sessions grouped according to the functional area.


If you have any questions or would like to see a session done on a particular topic in more detail, remember to ask your questions in the Q&A area of our community forum.

Introductory Sessions for all users



Session Title

Video LinkSummaryDate Published
User Interface and Navigation - Part 1SAP Business One 15 Minute Fundamentals - User Interface, Cockpit and Navigation- Part 1In this session you'll get an introduction to the basics of navigation and working with the SAP Business One User InterfaceAugust 25th 2017
User Interface and Navigation - Part 2SAP Business One 15 Minute Fundamentals - User Interface, Cockpit and Navigation - Part 2In this session we'll continue the introduction to the basics of navigation and working with the SAP Business One User InterfaceSeptember 1st 2017
Reporting BasicsSAP Business One - 15 Minute Fundamentals - Reporting BasicsIn this session you'll get an introduction to the basics of accessing, running and editing reports with the SAP Business One Print Layout designer and we'll touch briefly on Crystal Reports.September 8th 2017
Business PartnersSAP Business One - 15 Minute Fundamentals - Business PartnersBusiness partners are one of the core building blocks of your SAP Business One solution and in this session we'll look at the process of creating and maintaining themOctober 31st 2017
Sales QuotesSAP Business One -15 Minute Fundamentals - The Sales Process - Part 1In this session we'll look at the Sales Quotation Process and using and tweaking the User Interface in all the sales screensSeptember 26th 2017
Sales Quotes to Sales OrdersSAP Business One 15 Minute Fundamentals - The Sales Process - Part 2In this session we'll finish the Sales Quotation Process and start to look at the Sales Order ProcessSeptember 27th 2017
Sales Orders - DetailedSAP Business One 15 Minute Fundamentals - Sales OrdersYou'll find a slightly more detailed look at the Sales Order process where we start from the Sales Order and not from a Sales QuoteOctober 9th 2017
Delivery and a quick look at the Pick and Pack ManagerSAP Business One - 15 Minute Fundamentals - Delivery Process and the Pick/Pack ManagerIn this session we'll push the Sales Orders in to the Delivery Process, look at the Document Generation Wizard and the Pick and Pack managerOctober 9th 2017
Inventory Master DataSAP Business One -15 Minute Fundamentals - Inventory Master File BasicsIn this session on Inventory Management we'll look at the basic block of Inventory - the Item master fileNovember 12th 2017
Pick, Pack, and Production ManagerSAP Business One Functionality In Detail - The Pick, Pack and Production Manager | Tutorial VideoThis video examines the SAP Business One logistics functionality in more detail. After walking through the Pick Pack and Production Manager, Richard also demonstrates how to generate a Pick List directly via the Sales Order.February 5, 2018
General Ledger - Chart of Accounts15 Minute Fundamentals - General Ledger: The Chart of AccountsGeneral Ledger is the center of any FInancial application - the Chart of Accounts is the framing structure. This video looks at the basics...February 20, 2018
BudgetingSAP Business One -15 Minute Fundamentals - The Basics of BudgetingIn this session we'll run through the basic building blocks of Budgeting in SAP Business OneMarch 7, 2018
General Ledger TransactionsSAP Business One - 15 Minute Fundamentals - General Ledger TransactionsThere are a number of ways of entering transactions in to the General ledger - in this video we'll take a look at them.March 12th, 2018
Financial Reporting BasicsSAP Business One 15 Minute Fundamentals - Financial Reporting BasicsTo get started with Financial Reporting in SAP Business One there are some prebuilt options - we'll start off by looking at these for the Profit and Loss, Balance Sheet and Trial BalanceMarch 19th, 2018
Dunning and Debt ManagementSAP Business One 15 Minute Fundamentals - Dunning and Managing Debt CollectionA longer look at the process of setting up and managing the dunning and debt management processApril 6th, 2018
Project Accounting and Management Functionality15 Minute Fundamentals - Project Accounting and Project ManagementAn overview of the Project Management features in SAP Business One 9.2/9.3 and the basics of using Projects in FinanceApril 18th, 2018
CRM and MarketingSAP Business One 15 Minute Fundamentals - CRM and Marketing A little more than 15 minutes covering the CRM and Marketing capabilities in SAP Business One and how to use them.May 23rd, 2018

Often times, it seems like people in the SAP world use a completely different language, full of esoteric and important sounding acronyms like ABAP, iDocs, FICO, PLM and others.



In fact when I was at SAP I often heard it referred to as SAPanese.



But when someone uses it on you, it's no laughing matter as its usually as part of an explanation on how to solve a problem and your stress levels are already high enough with people adding to it.



So as time progresses I will try to explain some of these that you may encounter as an SAP Business One user to help clear the confusion and give you something to talk about at parties.



So, many of the systems and portals at SAP are locked down so that only Authorised users can access them.




The codes that are provided can be a number of different ones - for example if you are an SAP employee in Germany, you are given a D-number, International employees get I-numbers, contractors get C-numbers and customers and partners get S-numbers.


If you need to access the SAP Help Portal and many of the Customer only documents, you'll need an S number and the place to go to get that is your partner - as an SAP customer you are entitled to access these resources (don't let anyone tell you differently) as long as you are current on your SAP annual maintenance.


Once you have an S-number you can access the areas that SAP have determined are appropriate for you as an SAP Business One customer including the software downloads area.


To make it easier you can also apply for an SAP Passport which is a digital certificate that you can install in your browser and use instead of remebering your S-number and password.


I'll cover that process in another blog shortly - oh and by the way I was only joking about talking SAPanese at parties - unless its an ASUG party, if you do it you'll most probably not get invited back  


On August 28, 2017, SAP announced that the Early Adopter Care Program for SAP Business One 9.3 (both on SAP HANA and MS SQL) has started.



Submit your nominations for the Early Adopter Care program via your partner or via this link


SAP's recommendation is that you should participate in the Early Adopter Care program if you plan to implement SAP Business One 9.3 or SAP Business One 9.3, version for SAP HANA in a productive environment.


As has been the case with previous Early Adopter releases you will benefit from accelerated problem resolution and special attention from SAP.




What can you expect with release 9.3?

  • With core expansion, SAP Business One will support new business processes and round out key areas such as:
       - simple production routing,
       - return merchandise authorization management (RMA),
       - project management updates,
       - simplifying and streamlining CRM processes,
       - authorization management,
       - price list enhancements.
  • Leveraging the SAP HANA platform and building on the semantic layer, SAP plan to offer new cockpit templates. With a new analytics portal, end users will be able to schedule and consume reports without the need to log into SAP Business One.
  • With add-on solutions playing a key role in shaping the SAP Business One solution, SAP have also announced plans to make it easier for partners (and customers) to develop add-ons with the support of XML methods for user defined tables and the latest visual studio 2015 suite.
  • Deployment and management of SAP Business One will be simplified with a centralized approach. SSO will be utilized for apps for SAP Business One, version for SAP HANA making partner and self developed add-ons easier to manage and consume.
  • SAP have also re-committed to continuing to focus on building for optimal performance, making SAP Business One 9.3 more stable and easier to support.

You can learn more in the ASUG upcoming webinars focusing on the SAP Business One Product Roadmap and the 9.3 In Focus sessions due shortly as well as reviewing the 15 minute fundamentals sessions built using SAP Business One 9.3
Note: All enhancements mentioned are subject to change Software Download & Technical Prerequisites
For SAP Business One 9.3, version for SAP HANA, ensure that the following components are installed on the Linux server:
  • Operating System: SUSE Linux Enterprise Server (SLES): 11 SP3, 11 SP4, 12 SP1
  • SAP HANA Platform Edition: 1.0 SPS 12 Revision 122.05

For SAP Business One 9.3, install one of the following Microsoft SQL Server versions:
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016


Please refer to the Administrator’s guide for SAP Business One 9.3  and the Administrator’s guide for SAP Business One 9.3, version for SAP HANA in this recent blog post -
Get a Jump Start on deploying SAP Business One 9.3 with the Administrators Guide .

: SAP Business One 9.3 is delivered together with remote support platform 3.2, which must be installed if you wish to avail from support services such as GoToAssist.

Integration tools are a critical component of most ERP solutions - in fact, as the functionality to automate the business processes inside your organisation become commonplace in most solutions there are really only a few remaining areas where products can differentiate themselves.

Some integration tools are designed to be used by your existing end users and in SAP Business One these are tools like the Query Designer, Formatted search and the Data Transfer Workbench or DTW.

Other tools require a greater level of technical skill and capability such as the DI-API (Data Interface Application Programming Interface) which enables you to write your own software with tools like Microsoft Visual Studio and languages such as Java but these are definitely tools for the experienced programmer.

Other tools exist such as the SAP Business One Integration Framework which is designed to enable consultants and experience technical users to build workflow based integrations between SAP Business One and a number of other solutions - these are commonly referred to in integration scenarios as "endpoints".


But how do you learn these tools without spending large sums of money to gain the pre-requisite knowledge to make them work their magic?


Well, for some time SAP have been publishing courses on their HANA technology on their Open Learning site at - now the very first SAP Business One related course has been published and its focused on the SAP Business One Integration Framework and its a free course available to anyone that wants to sign up.


You can find it at and its a great place to learn about the technology and how to apply it.


Of course you'll need some pre-requisite skills and for this course they are :

  • General understanding of IT
  • Basic knowledge of SQL
  • Knowledge of XML/XSLT
  • And of course, SAP Business One knowledge is useful


The course runs over a 5 week period and requires you to attend 4 hours of course content each week so its not overwhelmingly time consuming and you'll need access to an SAP Business One deployment with the B1if components installed.


Take a look at the course, learn the Integration Framework and then go out and apply your new skills to build an even better SAP Business deployment for your organisation - its free and the functionality is robust and that makes it a great tool to use.


At the upcoming BizONE Conference in Anaheim, I will be presenting a workshop entitled Taking your SAP Business One deployment to the Cloud - Why the discussion should not be if but when and how


We'll be covering a number of SAP Business One specific topics relating to utilising the cloud as part of your deployment as well as looking at various technology options but this session isn't a sales pitch.



It will be your opportunity to understand the different factors that will impact on your business and whether or not cloud computing will be a part of your IT mix.



As a hands on session, you should also come along prepared to do some work - I'll be leading you through a couple of exercises (mental not physical) that will help you build your business strategy and determined when you should move to the cloud, what components you'll put in the cloud and what cloud models are best for you.



To get you started - here's a nice little explainer video from the team at Common Craft on cloud computing that will help you get the basics straight in preparation to dive deeper at the Conference as well as a preview of what we'll cover at the Conference




A Cloud Computing Primer from Creative CommonsTaking your SAP Business One deployment to the Cloud - BizONE Conference Session Preview