Category: Configurations

Intercompany integration solution for SAP Business One – Financial Consolidation

Financial Consolidation Processing Operational visibility and risk management are key considerations for any business with multiple operational units. The corporate financial controller needs an accurate and timely rollup of GL accounts for financial consolidation. Intercompany Solution provides in-depth insight in to consolidated financial data across the organization without intensive manual reconciliation or duplicate data entry. […]

SAP HANA Database auto backup to FTP server daily

There is nothing more important than securing your data. Although SAP HANA studio provides a way to auto backup your database but it is better to have those backup saved off site. Here we provide a way to back your HANA database and save it to ftp server. the file structure is here. /usr/sap/NDB/HDB00/backup/autobackup/MTC   […]

SAP Business One Browser Access Installation

Browser Access is an important feature in SAP Business One 9.2. The installation is pretty easy and can be explained in a few steps: Step 1:Installation files: 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 […]

SAP Business One SBO Mailer resend failed Emails

Note: it is not recommend by SAP to manually change system table fields value but besides use Diapi or Service layer to resend those emails, this is the only way to do that for customers. For some reason, SMTP server could reject those Email you sent by using SBO Mail service. Those Email will be […]

sap business one office 365

Office 365 SAP Business One SBO mailer configuration

Recently, one of our customer want to use office 365 in SBO mailer service. Exchange will check the SBO user’s email address to see if it match the email address setup in SBO mailer service, if it doesn’t match, the authentication will be failed. (Google work app wont have this issue) and you will see the […]

Create Company Database in SAP Business One

For SAP Business One customers who are new to SAP Business One or has new business expansion requirements, creating a new company database in the SAP B1 system is an essential operational step for financial officers or system administrators. Creating new company account set does not need to do the relevant background database action, generally only […]

SAP Business One on Hana database Backup and Restore

Although in SAP Business One System Landscape Directory (SLD),  it is easy to can easily backup a company database by simply click the backup button, but in HANA Studio,  it is easier to backup and store a SAP Business One company database or even clone a company database with different name for testing. Backup： chown […]

SAP Business One on HANA workbench widget editor

The Workbench widget is available as of SAP Business One 9.1, version for SAP HANA and standardizes and visualizes the most common business processes. It not only simplifies the complex functions by grouping common functions together according to different business purposes, but also provides you with a consolidated entry to perform various kinds of jobs. […]

Reset the HANA SYSTEM User password

Reset SAP HANA Password

Recently, one of our customers asked us to reset its Hana SYSTEM user password. There are several articles on the Internet regarding how to reset HANA SYSTEM User password, but most of them are not working due to Hana Platform version difference. Here I listed the steps just work for me. Prerequisites : You need have […]