Here we already reported last year on the successor to the XL Reporter for SAP Business One.
Read MoreXL reporter successor to SAP Business One
e versions were delivered: the XL-Reporter. With this you could create Excel reports on the data basis of SAP Business One and manage and distribute them within SAP B1.
Read MoreWebinar: Evaluate data from SAP Business One with Excel
Kind of obvious: SAP Business One mostly uses an MS SQL database. Instead of accessing the data via the application to generate reports, you can of course tap directly into the SAP Business One database with Microsoft Query.
Read MoreThe dangers of Excel: Why collecting data with Excel becomes a problem
Evaluations, analyses and calculations? Excel go!
However, with Excel, hours are recorded from projects, orders, purchase orders or sales data are collected. But why does this become problematic?
SAP Business One 9.1 – Use Excel
A new detail function in SAP Business One makes it easier to edit tables. It is now possible to copy the contents out of table views in SAP Business One and into Excel (or another spreadsheet programme).
Read MoreExport SAP Business One data easily to EXCEL with SAP 2 Excel
The tool SAP 2 Excel wants something more. The programme is actually an Excel add-in that makes it possible to dynamically retrieve data from SAP Business One from the Microsoft programme.
Read MoreXL - Importer for SAP Business One
The SAP Business One ADDON hooks into Microsoft Excel and makes the direct import of journal entries and budgets possible.
Read MoreExcel data via copy 'n' paste in SAP Business One
Sometimes one runs out of imagination about what can be done with a new add-on idea for SAP Business One. However, this new extension will give some people some ideas.
Read More