[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