We already reported here 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
Somehow obvious: SAP Business One mostly uses an MS SQL database. Instead of accessing the data via the application to generate reports, it is of course also possible to tap directly into the SAP Business One database using Microsoft Query.
Read MoreThe dangers of Excel: Why collecting data with Excel becomes a problem
Evaluations, analyses and calculations? Excel go!
However, Excel is used to record hours from projects, collect orders, purchase orders or sales data. But why is this problematic?
SAP Business One 9.1 - Using 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 SAP 2 Excel tool 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 plugs into Microsoft Excel and makes it possible to import journal entries and budgets directly.
Read MoreCopy 'n' paste Excel data into SAP Business One
Sometimes you run out of imagination about what you can do with a new add-on idea for SAP Business One. However, this new extension will give some people a few ideas.
Read More