GEN - Create Excel files with SAP B1 Data

Important Notes

The samples and information below is provided without a warranty of any kind. This post is for informational purposes and coresystems ag assumes no responsibility for errors or omissions in the information provided.

Purpose

The Export Excel plugin allows you to create automatically Excel Files with Data exported from SAP Business One. With the help of coresuite customize you can automate the data export from SAP Business One for further analysis or transfer the data to a different system.

This sample rule attached here fills an Excel with the results of sql queries stored in the SAP Business One Query Manager under a certain category. With the help of coresuite customize this export can be automated according to the customers Business Rewuirements. For example whenever a certain report is viewed or whenever a certain user logs in to the system or whenever certain documents or data is entered in the system.

Requirements

The sample requires coresuite Version 3.70 or higher, and SAP Business One 8.82 or higher. Excel installed on the System.