I need to export timesheets with reference numbers | Community
Skip to main content
Level 3
July 20, 2023
New

I need to export timesheets with reference numbers

  • July 20, 2023
  • 2 replies
  • 460 views

I really need to find a way to export timesheets that show the coinciding Project's reference number alongside it. We don't have fusion - and although i know that's the way to go for this, it's not in the cards right now so i'm trying to find a workaround. I have about 10 users who need to track time and I need to get that time into our SAP system. WF automatically generates the reference number with every project, so my plan was to export the timesheet with each reference number and use those numbers to add a few additional numbers in the excel and into a format (10 digits) that SAP likes. If anyone has an ideas I'd greatly appreciate it!

 

2 replies

VicSellers
Community Advisor
Community Advisor
July 21, 2023

Hi @oliviacl - Would you be able to just pull an hour report and add in the related Project Reference Number there? It might be easier to manipulate the report then to match the spreadsheet that you need to upload into SAP and would also show there work items, admin, etc. Just a thought, maybe you already tried that and it didn't fit your use case!

OliviaClAuthor
Level 3
August 7, 2023

That's a thought @vicsellers - Definitely worth me trying it out! Thanks for the idea! Will report back 🙂