Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
2403 Prikazi

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. 

Avatar
Opusti
Avtor

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

Best Answer

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


Avatar
Opusti
Avtor


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.

Related Posts Odgovori Prikazi Aktivnost
1
mar. 24
4064
2
okt. 23
7329
2
mar. 25
3092
1
maj 23
6647
1
maj 23
7849