SAP Business One 9.2 and Excel in Powerplay
27 Jan

SAP Business One 9.2 and Excel in Powerplay

SAP Business One 9.2 comes with a new integration of Excel on the market that allows fast data analysis. A good reason to use integrated business software such as SAP Business One In addition to controlling the processes, the most important thing is to build up a database that allows illuminating analyses.

0

Does the analysis of data in order to present them in reports, many reflexively turn to Microsoft Excel. On the one hand, this is understandable, since spreadsheets are a tool that almost everyone has had to use at some point. On the other hand, it is well known (and has been written about here and elsewhere) that this is not always the best choice and is associated with some risks.

SAP Business One 9.2 now gives Excel a helping hand, so to speak. With the help of a special Excel plug-in, it uses the Microsoft Office tool where it has undisputed strengths. From the ERP package, the data structures can be called up in Excel in order to use them for building reports.
The query can then in turn be saved in SAP Business One 9.2 and retrieved again with the data that is always up-to-date.

The whole thing works with the SAP HANA version of the SME software and thus guarantees the well-known rapid processing of the data. An exemplary example is demonstrated in the video.

Business Intelligence

BI360 Webinar – Excel docks with SAP Business One

We already reported on the successor to the XL reporter for SAP Business One last year...
Continue reading ?
webinar

Webinar: Evaluate data from SAP Business One with Excel

Somehow obvious: SAP Business One mostly uses an MS SQL database. Instead of accessing the data via the application to ...
Continue reading ?
Excel_Data_ERP

The dangers of Excel: Why collecting data with Excel becomes a problem

In 1985, Microsoft Excel was introduced for the Apple Macintosh - almost 40 years later, the spreadsheet programme is one of the most important ...
Continue reading ?
SAP B1 and Excel

SAP Business One 9.1 – Use Excel

A new detail function in SAP Business One makes editing tables easier. You can now from table views in SAP ...
Continue reading ?
Export SAP Business One data easily to EXCEL with SAP 2 Excel

Export SAP Business One data easily to EXCEL with SAP 2 Excel

Excel is still the preferred tool in many offices for working with data in some way. Of course there are ...
Continue reading ?
Excel_Data_ERP

Excel data via copy 'n' paste in SAP Business One

Sometimes you run out of imagination what to do with a new add-on idea for SAP Business...
Continue reading ?
XL_Reporter_SAP_B1

XL reporter successor to SAP Business One

Some SAP Business One users have been missing a tool that was delivered with earlier SAP Business One versions for some time: ...
Continue reading ?
0

Leave a Reply

Your email address will not be published. Required fields are marked *
You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>