Integrated Spreadsheet – BI Reporting (Instant Business Intelligence)
Odoo 14 has launched a very useful feature to maintain the ease and comfort of users to work in excel spreadsheets. Sometimes it becomes untidy and hectic to produce and analyse data on ERP screens/reports. Initially, users had to download the pivot view of any report to edit in excel spreadsheet. After editing they had to re-upload it in the respective screens. The new feature facilitates us to produce and store excel sheets in ERP itself. This brings ease at analysing reports and its intelligent pivot table relationship with dashboard helps to fetch live data. User can perform all possible actions and input formulae just like ordinary excel spreadsheet. User can add columns, remove columns, insert new formulae, apply conditional formatting etc. Also, it is extremely fast. The Documents application was used to upload, maintain and share all company related documents. This app is upgraded with a new feature to ‘CREATE SPREADSHEET’ which will be in .xls format. The sheets can be saved in module-wise folders to bring ease at finding it as shown below.

