SAP Business One SDK Support

Add QR Code in Crystal Report - Method 2 - SAP B1 Patch

There is an Option other than SAP Patch - Method 1(Click Here)

Or the Below SAP 10 PL02 Patch method

QR codes became popular also outside the automotive industry, and used in applications to include product tracking, item identification, time tracking, document management, and general marketing.

You just have to scan it. But, before you scan it, you have to generate it… for that, SAP Business One introduces new functionality allowing you to assign QR Codes to marketing documents. Enter all relevant values in the General Settings > QR Codes tab:

No alt text provided for this image

In the marketing documents, a new field is added in the Accounting tab, where you can either enter text or use formatted search for generating the required value:

No alt text provided for this image

Add QR Code in Crystal Report - Method 1 (Need to Buy the DLL)

There is patch available  in SAP B1 10, which have in-build solution for this process. You can check this HERE (Method 2).

The below method is used for SAP B1 9.3,9.2 all patches. This is a paid method, Client need to buy the required DLL for this method.

Please check the website : https://www.morovia.com/

 After installing the above link software you can follow the below 5 steps :

1. Open the Crystal Report with all the Relevant data and Design.

2. Create a formula Filed and Past the below code

// Crystal Reports impose a constraint on UFL string length: max 255 characters.
// To get around this limit, use the code below
// This workaround requires Crystal Report Version >= 9

StringVar DataToEncode := {BarcodeHD_DTL};

        StringVar CompleteBarcodeString:="";

NumberVar i:=0;
NumberVar Segments:=
QRCodeEncodeSet(DataToEncode, 0, 0);
For i:=0 to Segments Do
(
   CompleteBarcodeString := CompleteBarcodeString +
             QRCodeEncodeGet(i);
);
CompleteBarcodeString

3. Set you filed by replacing BarcodeHD_DTL 

Advertisement



Browser Access installation for SAP Business One


A lot of partners can’t wait to test and work with the Browser Access function in SAP Business One 9.2.
The installation is straight forward and simple! It will be explained in this document in a few steps:

Step 1 : Installation files:

The 9.2 version contains the installation files to set-up Browser Access. During an upgrade you can choose to install it directly (then it will be installed on the machine where you executed the upgrade, if that is the database server it doesn’t make sense in a lot of cases) or you can install it on a later moment.
Once your installation is upgraded the shared folder contains as usual a Client folder, in that folder a new component is added: SAP Gatekeeper Installation.
Step 2: Installation:

Advertisement




Go to the specific folder and execute the setup.exe. During the installation you will be asked to connect to the SLD. A connection string will be created and will be saved also in the SLD. If you would like to use a certificate, enter it during the installation otherwise a self-signed certificate will be created.

SAP Business One 9.2 contains the installation files to set up Browser Access. During SAP Business One 9.2 Installation or upgrade, you can choose to install it directly, or you can install it later.

 
Step 3 : Post Installation Steps:
In the SLD a new tab is added:


The line with Browser Access Server is added automatically when installing it on a Presentation Server. Here you also find the link to access SAP Business One in the Browser.

Per Browser Access server you can setup some parameters, select and click on edit:

The Initial Process Pool Size means the number of client already running in a kind of silent mode, to improve the logon time. (you can see them as active processes on the presentation server even if users aren’t logged on to the system)
The Max. Process Pool Size means the maximum number of clients running on a presentation server.
SAP Business One Browser Access Supported Browser:
  • Google Chrome version 47 or later
  • Mozilla Firefox version 41 or later
  • Microsoft Edge
  • Apple Safari (MAC, iPad, iPhone)
Details on Web Browser Access/supported Web Browser per version are documented in the recent SAP Business One Platform Support Matrix: (S-User Id Required)


Advertisement



Use SAP Business One in the Browser:

Open the browser and navigate to the URL listed in the SLD, a verification will happen against the SLD (a pop-up can appear with the message you have to accept the website as trusted). The login screen will appear:
Enter you credentials and click log On, the client will be available in the Browser in a few seconds:

Setup External Access

In System Landscape Director (SLD) under “External AddressMapping” tab,  You can register an external Address to map the internal Browser Access Server to an external IP address for public visit.
Update: Hostname and IP address are both supported
The external access URL must have the format
<protocol>://<Path>:<Port>

Example: http://10.58.9.100:8080

In a Web browser, navigate to the external URL of the Browser Access service. For example: http://10.58.9.100:8080/dispatcher


More Info about the cloud hosting with Browser Access. Open PDF link below.


Trouble Shooting
Browser Access is written in Java and running on tomcat server. You can find all log files under “C:\Program Files (x86)\SAP\SAP Business One BAS GateKeeper\tomcat\logs” and provide them to SAP


As of release 9.2 PL02, you can also monitor the Browser Access processes in a Web page using this

URL: https://dispatcherHostname:port/dispatcher/serviceMonitor/


You can kill the threads as needed.

Common Errors People are getting on this and the solution mentioned by experts in SCN

Running Add-On
Through Web Clients common Add-Ons will not run at the moment. For that you need to open SBO Common from any usual client machine and execute the query:

EName is the EXE file name of Addon.
UPDATE SARI SET ClientType = 'A' WHERE EName = 'YOURADD-ON.exe'
The Add-On will be available in Browser Access.

File  Dialog Box for Browser

  The normal dialog doesn't work in browser access. You can use SBO_Application.GetFileFromBrowser() to send a file to the server.

Note that GetFileFromBrowser should be used only when in Browser mode. You can use the ClientType property to check.

Marketing Documents

Relationship Mapping between Marketing documents not shown in Browser Access. This is not an error, rather this feature is not available with Browser Access.

No Excel Import

This is a known limitation, might be resolved in next Patch Level.

SAML2Response issue instant is not valid

This is a login issue. Database Server and Presentation Server might have different date and/or time.

HTTP Status 404-/Dispatcher

Possibly port issue, uninstall browser access and reinstall it with the alternative port 8100. Also check if Tomcat is conflicting with browser access. In that case you can try to switch off Tomcat.

Error 1633- This Installation package is not supported by this processor type

Installation Error, possibly you tried to execute 64-bit Gatekeeper in a 32-bit system. SAP Business One 9.2 PL00 doesn’t support 32 Bit System.