timesheet line hours

(0) Share

Report

Posted on by agus

1,174

hi expert,

I'm exporting to excel the timesheet line, I need hours column also be extracted to excel, but it does not show in the excel. is there any table should be define ?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

MarkB45 755 on at

Like (0)

Report

Hi Agus,

Usually you would use the Dynamics Office app to edit the form (https://appsource.microsoft.com/en-us/product/office/wa104379629?tab=overview) and then edit the template https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/office-integration/office-integration-tutorial

However, the entity for Timesheet line doesn't include the hour quantities.

To export those select the "export to excel" option and the hours are exported as static data.

If you wish to edit the timesheet for upload through excel I would suggest using an project hour journal instead as this will contain the correct fields for upload, or, activate the mobile app on the settings menu to enter time through a mobile/tablet device.

KR

Mark

Was this reply helpful? Yes No