[Solved/Solution] Invalid file path - Preview Crystal report in SAP Business one

Getting this error message: "Invalid Report File Path" while previewing the SAP CR Layout 

Solution : There is no issue in SAP or crystal report; This system, user permission issue. Don't belive me, try to open the SAP B1 Clinet  > Run as administrator and try to preview the same error layout, it will open perfectly.

Check and change the permission os System user will full access to SAP and SAP related folders in C drive.

[Solved/Solution] Error while connecting to Crystal Runtime; Check the Installation

Error while connecting crystal report runtime, is common which we can see while previewing a layout in the SAP business environment.

The error occurs because there is a runtime is installed with the higher version in your system.  there are multiple solutions you can  find in Google and SAP SCN  like installing SAP crystal report runtime

Solution: Uninstall SAP B1 Client and Install it again from the Setup or from the B1_SHR folder.

This will reinstall the runtime required for the client to preview the CR Layout

 

[Solved/Solution] Error with libOCAHelperw-5-0.dll when viewing a Crystal Reports report in SAP Business One

Advertisement

SAP Business One 9.3 PL06 + and trying to view a Crystal Reports report. I get this error:

The procedure entry point ??0DHKeyAgree@BCM400@@QAE@II@Z could not be located in the dynamic link library C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\libOCAHelperw-5-0.dll

Consider that the specified DLL does exist.

This occurs with any report, both made with my Crystal Reports for SAP Business One 14.2.5.2618 or other versions.

It happens just on one machine, while the report works on the others.

SOLUTION :

Close SAP Business One, Delete this file libOCAHelperw-5-0.dll, open SAP B1.

This Work for me. Lets check and revert me.

[Solved/Solution] Form Mode automatically changed from OK Mode to Update Mode

Form Mode automatically changed from OK Mode to Update Mode while click on Customized Tab in system form; 

Created new tabs along with the existing tabs in SAP Default Screen. This works fine in Add Mode. 

But in Ok Mode, while click on the newly created Tab, Form Mode got changed to Update Mode.

That can happen because, one of the controllers of your tab gets changed, there's value when it get focus. (May be a text box or any controller)

Advertisement

If that behaviour is compulsory, then consider to change that Item's (controller's) 'AffectsFormMode' property as below.

YourController.Item.AffectsFormMode = false;

-

Authorization for User Defined Window/Form in SAP B1

Is it possible to give Authorization for Addon Form/Window so that it will work exactly like SAP Authorization ??

This is a common question and Answer is YES. Follow the below steps..

1. Goto >> Administration >> System Initialization >> Authorizations >> Additional Authourization Creator

2. In Left hand side,  There defaultly XL reporter autorization will be there select the any one and click add same level button in bottom of the screen.

3. Select how you want the Authorizations as Below

4. Then set 

Authorization ID >> Give some unique id

Name >> Description of Authorization

In Option >> Select Full/read/None

Item >> Tick as Item

Level >> 1,2,3....

5. Then Come down you can find big text box, near to that you can find edit button, just click that it will open a popup window. In that window you please enter the Form Id (form ID of User defined form) .

Note : To find the form ID >> Just Enable the system information menu in menu bar and move the cursor to any item in your user screen, you can find the form id.

Just type that form id in that pop up box, then Add the window.

Advertisement

6. Now Open the General Authorization. There in last row you can find the user authorization. just expand that you can find your authorization id and name there which you have created.

Give your authorization there.

To Deleted this new additional Authorization..

1.  Goto >> Administration >> System Initialization >> Authorizations >> Additional Authourization Creator

2. Select the new Authorization You have Created, Right Click

3. Right Click menu >> Advance >> Delete Authorization.

[Solved/Solution] " Cannot update while another user is connected to the company " - SAP B1

Advertisement

When users try to update some of the General Setting like Decimal point increase.. Users used to get the following error.

"Cannot update while another user is connected to the company"

Try the following Steps :

1 . Check all the users are disconnected from system and Only manager is login-ed.

2. Stop all Integration related process if any(Integration to any other system).

3. Stop All Add-on(Make it Manual start for all add-on for Temporally).

4. No SQL Query editor is open in the server.

5. All SQL jobs should be stopped.

Above steps you may have done, but still getting the same error; Please follow the below steps..

SOLVED  - SOLUTION Is

>  Stop all SAP services, only "SAP Business One Server Tools Service" is running and all other service is Stopped and DISABLES (not Manual) as of now.

   

Note : Do not try to make SAP DB single user DB Access, this may cause DB crash if anyone is connoted or any service is connected.

Above steps work for me. Please check and let me know.