[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] 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;

-

Scheduled Automatic SQL Database Backup using SSMS and Using Stored Procedure

There are two ways to schedule the DB backup in SQL for SAP Business One DB. 

Option 1 : Using Store Procedure - Follow the Below Steps

1: Create a Store procedure in master DB. - Check Link for Query

2: Run the Query in master

3: Open Object Explorer > SQL Server Agent > Jobs > Right Click (New Job)..

4: Left side > General > 

  > Set Name " Auto Backup"

  > Set Owner "sa" 

  > OK

5: Left Side Steps 

  >  New

  >  Sub Window > set StepName