Here is how you figure it out. Open the report in designer mode and see what the work table is.  Then go into Custom Office and try to add a UDF to that work table.  Select the drop down for Data Source and it will list the tables that are read to go into building the works table. This will be the tables you need.

HI the tables below are used to populate the data for the "Time Track Report".  When you state the "the data does not export in a user-friendly format" can you provide details of what you expect to export, what is not user friendly and how you are exporting the data? 

John Nichols

Sage

PR_TimeTrack
PR_Employee
PR_TimeTrackHistory
JC_Job
JC_CostCode
PR_Department
PR_EarningsCode
PR_LaborCode
PR_TaxProfile
PR_TaxState
PR_TimeTrackShift
PR_WorkersComp
PR_Options

Hi BigLouie, I'm new to SAGE. Can you tell me how to open a report in designer mode?

I jcnichols. When I'm in Sage and run a TimeCard report a job, the excel export data is not easy to manipulate for analysis. When I try to create a Microsoft SQL query and select the time card tables (i.e. TimeCard masterfile, etc), no data is returned. I'd like to create a query that includes: Job #, cost code, employee name and #, date worked, department worked. Any help would be greatly appreciated! I'll try your above suggestion. 

One item to note, we don't use Sage to process payroll, but employee hours are manually entered into the system.

HI What version of sage 100 are you using? Thx John

Sage 100 Standard 2017 V 5.40.0.0

Hi,

Legacy ODBC File Name to Framework File Name

TC0_TCParameters-> PR_TImeTrackOptions
TC1_TimecardMasterfile -> PR_TimeTrack
TC3_TimecardMastefile -> PR_TimeTrackHistory
TC6_EarningsCostCode  -> JC_CostCodeEarningsCode
TCA_EmployeeMasterfile -> PR_Employee
TCG_ShiftMasterfile   -> PR_TimeTrackShift
TCJ_JobMasterfile   -> JC_Job

Hope this helps. Via Excel MS Query create your SQL statement using the legacy ODBC file names.