SAP Business One Consultants | IT Support | 0843 886 1449

All posts in SAP Business One HANA

SAP Business One – Improving The Speed Of Reports

Along with general consultancy, system implementations, training, interfaces and development of SAP Business One, one of the most requested jobs is to improve the speed of reports. Reports can be written in SQL Queries, Crystal Reports or any other reporting tool. As a rule of thumb, if a report is running slowly, it is due to either the way it was originally written or the data it is reporting on. With some out of the box thinking it is usually possible to massively reduce the way a report runs by approaching it from a different view point.

I have personally managed to reduce report run times from 90 minutes to 30 seconds with a slight rewrite of the report – anyone who has been in a situation where there screen is frozen for 90 minutes will know how frustrating it is and what a massive improvement this is.

Ways to improve your reporting:

  • Is it possible to improve the Joins?
  • Is it possible to reduce the data calls?
  • Will a database View reduce the run time?
  • Can a temporary table(s) be created to reduce the run time?
  • Is the report written in the best possible way?
  • Are there unnecessary joins?
  • Can the data be accessed from ‘better’ sources than already used?
  • Are you able to create a better report from multiple sources rather than a nested, cascading report?

If you still have slow reports after addressing the above points then contact us and we will help you reduce the run time.

SAP Business One SQL Prompt Variables

/* SELECT FROM [dbo].[OSLP] T1 */
declare @slpName as varchar(155)
/*WHERE*/
set @SlpName = /* T1.SlpName */ ‘[%0]’

/* SELECT FROM [dbo].[OCRD] T2 */
declare @CardCode as varchar(15)
/* WHERE */
set @CardCode = /* T2.CardCode */ ‘[%1]’

 

SAP Business One HANA Prompt Variables

/* select from [dbo].[OINV] T0 */

/* select from [dbo].[OSLP] T1 */

Declare FromDate timestamp;

Declare ToDate timestamp;

Declare SALESEMP char(155);

 

SALESEMP := /* T1.”SlpName” */ ‘[%0]’;

FromDate := /* T0.”DocDate” */ ‘[%1]’;

ToDate := /* T0.”DocDate” */ ‘[%2]’;

 

!! Remember to end your HANA SQL Script with a semicolon and replace the single and double quotes above which are enforced formatting !!

Locked Business one license SAP multiple users

SAP B1 Version 9 and above users – take note!

SAP Business One users who are temporarily locked out whilst another machine is logged in as the same user isn’t an error! It is new, core functionality to stop license over usage (read as abuse!).  Once the second machine has logged off the first user unfreezes.

Please note:
If a SAP B1 named user is being used for interfaces/ APIs then there are possibilities that locks or blocks will occur! Not good for an interface and there are better ways of overcoming this.

A bit about the SAP Business One license model.

SAP Business One licenses are based on a named user licensing model. Each user name needs to have a license granted to it.   A named user is an employee who is authorized to access directly or indirectly the licensed SAP Business One software, which is enforced by License Policy Technical Enforcement features in version 9.0.

Employees may not share a single user name to logon to SAP Business One. Licenses assigned to a named user are not specific to a single company database.

Locked Business one license SAP multiple users

So What/Why has it changed?

In prior releases of SAP Business One up to version 8.82 using the same user name, a named user can log on to SAP Business One twice, for example to access a second company. In reality however, this is not the case. Up to the 8.82 SAP Business One version level, even with a clear emphasis of a named user licensing model (one named user utilizing/assigned one SAP Business One license)   the system allows 2 possible login to the same database company using the same user name and password. This then allows customers to have a work around of having two employees using the same login and password to process things within an SAP Business One database company. The drawback in this case is that instead of one license needed for the two employees it now only requires each user to have their own login and password.

Now with the release of SAP Business One version 9.0, inquiries started to pour in as more customers from the SAP Business One 8.8 versions started upgrading to the latest release of SAP Business One. The scenario where the same name user and password logging in as two separate instances to the same database does not work anymore. This has led to many customers asking the questions “Why I have been allowed to do this in SAP Business One 8.82 version and earlier why not now?”.

What to do?

Basically, if you are under licensed, you will need to purchase more licenses!

If you don’t currently benefit from SAP Business One (err, why on Earth did you find this page??!!) but would like a powerful and easy business system to use for your business, get in touch!

 

Your Name (required)

Your Email (required)

Your Telephone

Your Company

Subject

Your Message

 

 

Business Partner Email Report SQL HANA

Want a list of your Business Partners email address for marketing? Email your business partners from your favourite email marketing site by using this report query. It’s SQL that you run from within Query Generator or SQL Server.

Simply copy the code between the /* … and … */ for your version of SAP B1 and paste into the Query Generator.

Here’s something for free! Have a great bank holiday weekend!

 

SAP Business One SQL Server version –

/*

 

–Start. Marketing Email List V1.1

select t1.CardCode, t2.cardname, t1.E_MailL

from ocpr t1 inner join OCRD t2 on t1.CardCode = t2.cardcode

and t2.cardtype = ‘C’

–End. Author Stuart Folley www.1dash1.co.uk  0843 886 1449

 

 

 

 

SAP Business One HANA SQL version –

/*

 

–Start. Marketing Email List V1.1

SELECT T1.”CardCode”, T0.”CardCode”, T1.”E_MailL”

FROM OCRD T0  INNER JOIN OCPR T1 ON T0.”CardCode” = T1.”CardCode”

WHERE T0.”CardType” = ‘C’

–End. Author Stuart Folley www.1dash1.co.uk  0843 886 1449

 

 

 

Your Name (required)

Your Email (required)

Your Telephone

Your Company

Subject

Your Message

 

 

Sage Line 50 Upgrade

Most young or Start Up businesses buy Sage Line 50 but soon find that they outgrow the functionality available. Not to fear!

Upgrade from Sage Line 50 to SAP Business One and save 15%

If your small or medium sized business is running on Sage Line 50 then you can upgrade to the functionality rich SAP Business One software suite which will grow with your business as it grows… and grows. With integrated accounting (incl multi-currency, advanced nominal structure), stock control including Serial and Batch numbering and multiple warehouses, customer relationship management, production, sales and purchasing (plus much more!).

Sage Line 50 Upgrade

A Slice of life

If we could, we’d give you the software because we know it will help your business. That’s quite a statement but you can benefit and we can show you how.

With an amazing offer like this, is it worth missing out on something so good?

This offer has a limited time period so get in touch now!

…maybe you’d like SAP Business One HANA? Instant processing with In-memory computing. Want to know more?

Your Name (required)

Your Email (required)

Your Telephone

Your Company

Subject

Your Message

 

SAP Business One on Hana leaves every other Small to Medium business software behind with it’s instant in-memory computing!

So what does it mean for you?

SAP Business One on Hana

Speed, accessibility and reporting within seconds for your business; Locally or Globally! Reports that take you days in other ERP software systems will take seconds on SAP Business One on Hana. This means that you will save money and time on the reports themselves but will also give you the edge over your competition.

How? You ask.

Let’s say a trend begins for one of your products that one of your competitors sell. You see the trend instantly and can react to the increase within minutes, maximising on sales and profitability. It will probably be at least a week to a month before your competitor even sees the increase!

What could this mean to your business? Find out by contacting us.

Get ahead, get SAP Business One on Hana.


 

SAP Business One on Hana

SAP’s announces that HANA powered versions of its ERP Business Suite range has gone on general sale.

The new version (Version 9) of Business One, which runs on Microsoft SQL and was announced yesterday at the Sapphire NOW conference in Florida, can be deployed on premise or in the cloud and is accessible from mobile devices.

The latest version of Business One also includes new capabilities for business partner and warehouse management, infrastructure and inventory management.

SAP Business One Powered by HANA

  • Run your entire business with a single solution that will scale as you grow
  • Drive measurable performance gains in all of your key business processes
  • Use analytics to get up-to-the second information on purchasing habits and more
  • Generate insightful, interactive reports in seconds – no delays, no waiting
  • Enjoy the power of the SAP HANA platform, priced specifically for small business
  • Access real-time business insights – for faster, smarter decision making
  • Empower employees to create standard and ad hoc reports with ease
  • Generate interactive reports in seconds – no delays, no waiting
  • Enjoy the power of the SAP HANA platform, priced for small business
  • Reduce your reliance on consultants and IT for reporting needs

The HANA in-memory database is currently SAP’s biggest technology initiative, and SAP co-CEO Jim McDermott, in a keynote Tuesday, said HANA would be the platform for all SAP product development going forward.

Version 9 SAP Business 1 powered by HANA

In a keynote Wednesday, SAP co-CEO Jim Hagemann-Snabe re-emphasized that point when he announced the general availability of Business Suite on HANA.

“I would claim that HANA is the biggest innovation in 20 years in business software,” Hagemann-Snabe said. Along with the technology’s ability process huge volumes of data, it also greatly speeds up the performance of Business Suite, SAP’s ERP and industry application set for bigger companies, he said. “This idea of putting data in main memory is a quantum leap.”

 

Find out more about the cost of SAP Business One.

Contact 1 Dash 1 to find out more about SAP Business One powered by HANA.

Your Name (required)

Your Email (required)

Your Telephone

Your Company

Subject

Your Message