From simple lists to complicated reports – we all use spread sheets. So basic and yet so powerful… no wonder that exporting data to spreadsheets has become a standard feature. SAP Business One has been supporting export to Microsoft Excel since forever and recently the option to export from the regular client to Microsoft 365 using OneDrive was made available as well. Now, taking another step forward, the integration to Microsoft 365 is supported also by the Web client:
When clicking the Export to Excel button, the given file opens in a new browser tab:
You can export list views, search results and the detailed views of sales documents to Microsoft OneDrive as Excel files using templates which are similar to ones used by the regular client.
Available in SAP Business One 10.0 FP 2105 and SAP Business One 10.0 FP 2105, version for SAP HANA. This tip and all the other tips are available on SAP Community. You can also visit the Implementation Arena for useful implementation tips.