Hello, I'm using Odoo V14 Enterprise. In the attendances app, we have been able to setup filters by date for each work week to show a report in List view. We need to review in report form the total hours worked, check in and check out per date for each employee. We would like to store this under the HR Workspace in the Documents App. We can do this with a pivot table by sending it to a spreadsheet however can't get the check in and check out date to display on the pivot table. We also have the Studio App to make any modifications we need but I haven't been able to come up with a solution. Any assistance would be helpful.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
Hello,
We can activate pivot view on Attendances using studio (Attendances >> Manager >> Attendances) after that we will get those fields (Check In and Check Out) on pivot view.
https://drive.google.com/file/d/1iwwL4LUUvER9wng8-Iw5eFq__QnbjfG0/view
Siddharth, thank you for your response but we need the report to show the actual check in and check out and not just the worked hours. Will post images to show what we need to accomplish.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
1
Mar 24
|
2794 | ||
|
2
Oct 23
|
5376 | ||
|
1
Dec 23
|
2128 | ||
|
1
May 23
|
5148 | ||
|
1
May 23
|
6817 |
To help clarify. This is the report we can show in list view that can be downloaded into an Excel file. https://drive.google.com/file/d/1iupIqwSnH5O_bFn6EJzqxRXdGffmF6yf/view?usp=sharing . In order to get it into HR under the Documents App, we have to download the excel file and then copy and past it into a native Odoo created spreadsheet. This is the result we need in Documents HR . https://drive.google.com/file/d/1Pn021BQOmZz-r1axzGZXicCab-jW4yY7/view?usp=sharing