SAP Business One mobile app for Android

Installation:

- Go to Play Store
- Search SAP Business One
- Select SAP Business One (SAP AG)
- Press Install
- Start SAP Business One
- Configure the logon information or just start the Demo

Quick and easy.

Crystal Reports 2011 has stopped working when trying to save or preview the report in SAP Business One

I am not able to save or at least preview my new crystal reports in SAP Business One. I hope this is just a installation issue, but hard to find out how to fix it.

If you have the same issue, at least you can test your reports using the "Tools / Preview External Crystal Reports File" menu.

Funny workaround, but at least it works, and it looks it works even faster than using the preview function under the add-in menu.

Crystal Reports freezes and closes in Database Expert when trying to Create New Connection (resolution)

After I installed the new version of Crystal Reports (version 14.0.4.738) and I tried to use Create New Connection in Database Expert my Crystal Reports crashed.

After a few hours of suffering, installing, and uninstalling, searching Google, reading forums, and so on about the issue, finally I found a good resolution by myself.

Step 1:
run the Crystal Setup again, and choose: Modify

Step 2:
remove (uninstall) the unnecessary data access components under Data Access.

For me it helped. I hope it helps you as well.

What is SQL Native Client?

The SQL Native Client contains the SQL Server ODBC driver and the SQL Server OLE DB provider in one native dynamic link library (DLL) supporting applications using native-code APIs (ODBC, OLE DB and ADO) to Microsoft SQL Server.

Link to the official home page on microsoft.com: http://msdn.microsoft.com/en-us/sqlserver/aa937733.aspx

SAP Business One blogger

I found a SBO blogger, his name is Mike Taylor. Here is a link to his blog: http://www.battleshipcobra.com/category/sap/

Cheers.

Sales Analysis dashboard development with SAP BusinessObjects Dashboards

I had time to play with the SAP BusinessObjects Dashboards 4.1 this afternoon. As I remember this product was formerly know XCelsius.

The result: Sales by Region chart is interactive, if you click on the map, the values of the pie chart changes. This is only a picture of the dashboard. It would be easy to link. I will add the link later.

To be continued..

Is Remote Desktop not going back to full screen?

Here is the hotkey: CTRL + ALT + BREAK

Enjoy.

Fixing the issue - when add-on starts in SBO - Internal error (-131) [131-183] message pops up

Step 1

Rename file "..\SAP\SAP Business One DI API\Conf\b1-local-machine.xml" to “b1-local-machine.xml.original”

Step 2 

Copy the file from "..\SAP\SAP Business One\Conf\b1-local-machine.xml" to "..\SAP\SAP Business One DI API\Conf\b1-local-machine.xml"

I found this solution on the SAP portal, and it worked for me.

Crystal reports Add-in menu is missing?

You are using Crystal reports and with one of the SAP Business One, or Crystal Reports upgrade you lost your Add-in menu, and you are not able to save your reports back to SAP Business One?

Try this:
Step-1
Go to Crystal reports installation package, and find the directory "SAP CRAddin Installation"

Step-2
Run the application "SAP Business One Crystal Report Integration Package" as administrator

Once you are ready, enjoy your Add-in menu again, and Save your nice reports to SBO.

SBO function: Online Request for Quotation

Online Request for Quotation is a further extended core function to enhance supplier collaboration based on the integration framework.

Step 1: Before you create Request for Quotation in SAP Business One tick the Create Online Quotation under the Logistics tab

Automatic Step 2: SBO sends email in your name to your supplier

Automatic Step 3: you receive a message from B1i: RFQ Document: 10002  has been created and emailed to Your Supplier Ltd

Automatic Step 4: sales representative of your supplier receives your email with a link to a "web-page" and on that page he can offer as filling in your online form, and pressing the OK button

Automatic Step 5: The existing purchase quotation automatically updated in SAP Business One with the offered price, and delivery date given by your supplier. Simultaneously you receive a message alert in your inbox with a golden arrow linking to your original purchasing document. 

Do you like this feature? Did you know you have this function in your system?

Counting the total number of transactions returned by the Stock Audit Report

To determine the total number of records returned by the Inventory Audit  Report for all the items and warehouses without any specific date run the following query:

SELECT count(*)
  FROM [dbo].[OINM] T0
  INNER  JOIN [dbo].[OITM] T1 ON T1.[ItemCode] = T0.[ItemCode]
WHERE (T0.[TransValue] <> 0 OR 
       T0.[InQty] <> 0 OR
       T0.[OutQty] <> 0 OR 
       T0.[TransType] = 162)