![]() Enter Label as ‘Partner’, Related Model as ‘Contact’ and click on the Save icon on the new screen. Let’s apply a Relation Filter by selecting the Relation icon. Users can add Filter based on Date, Relation and Text, as portrayed in the screenshot below. A Filters window appears on the right side of the spreadsheet, and you can develop different filters from here. For that purpose, choose the Filters icon in the right top corner of the spreadsheet. So, we apply Filters to access the required data in the spreadsheet in Odoo 15. To find specific data based on a company is quite tricky in some scenarios. Right-click on the left upside cell in the spreadsheet and select the Re-insert Pivot option with your Invoice Statistics number.Īll the data shows up in the cell by clicking on the Re-insert Pivot option.Īpply Filters in your Spreadsheet Quickly At that time, you can refine the data quickly with Odoo features in a spreadsheet. In some situations, we delete data from the spreadsheet by mistake. Refine the Lost Data inside a Spreadsheet in Odoo 15 We can easily access where the data come from and the pivot properties inside a spreadsheet in Odoo 15. It shows the information such as Pivot name, Model, Measures, Domain, Dimensions, and more aspects. Hence, the Pivot properties are viewable at the right end of the window. You can access the Pivot properties by right-clicking a cell and choosing the Pivot Properties option. In the same way, you can analyse the pivot order of each cell data separately. It shows the pivot view with subtotal price for partner ID number 26 (means Azure Interior, Brandon Freeman), and the Invoice date per week means the 15th week of 2022. The integration helps in many ways to develop and manage the spreadsheet in Odoo 15.Įasily Access the Pivot Properties of a Spreadsheetīy clicking on a cell in a spreadsheet, you can see the formula of a specific cell at the suitable top space. Later, go back to the Odoo 15 Documents module, and you can see the created spreadsheet in the Documents dashboard, as depicted in the screenshot below. We can set it as your favorite one by clicking on the Star icon. Let’s rename the spreadsheet as ‘Demo Spreadsheet Invoice’, as shown in the screenshot below. The new spreadsheet is created on Odoo 15 Documents by clicking on the Confirm icon. Here, we create a New Spreadsheet and click on the Confirm button. In the new window, you can develop a New spreadsheet, Untitled spreadsheet, text spreadsheet and more forms. Once created, the data is, click on the Insert in Spreadsheet icon as displayed in the screenshot below. ![]() Here, you can arrange the Pivot table based on your data requirement. The Invoice Analysis window is viewable in Pivot and Graph view. Go back to Odoo 15 Accounting module, and select the Invoice Analysis menu from the Reporting tab. ![]() In the Odoo 15 Documents window, select the Spreadsheet option from the right side, and all created spreadsheets are visible here, as displayed in the screenshot below. Let’s look at how the spreadsheet in Odoo 15 Accounting is integrated with the Odoo 15 Documents module. The integration provides excellent results, and it does not waste your time. The spreadsheet is integrated with some applications in Odoo, and you can edit/create it. Assists in the Integration of Odoo modules ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |