Somehow obvious: SAP Business One mostly uses a 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.
0The best way to do this is to output the data with Excel as the front end.
Carl Lewis demonstrates how to do this and more about Excel integration with SAP Business One in a webinar.
Error: Contact form not found.

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 ?
Continue reading ?

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 ?
Continue reading ?

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 ?
Continue reading ?

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 ?
Continue reading ?

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 ?
Continue reading ?

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 ?
Continue reading ?

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 ?
Continue reading ?