Sage 100

I need to recreate a simpler version of the ""Job Transaction Detail Report"" using MSQuery. Anyone know what tables are used to make that?

JC3 is the main one

Thanks @BethBowers

Also include JC0, JC1, JC2, JCC, SY0. There's probably a file in the Reports folder called JCW003.RPT. You should be able to make a backup of that report and modify the original.

This could be an overload of tables for MSQuery. If you find that it is, it might be easier to use Access PTQ's and then create a select query table to join the table and include just the records you need. THEN use Excel to pull the data.

Yeah, I had a flood of memories after the Job Cost Master report changed (3.71 to 4.x) and how difficult is was to recreate because of the record types dynamically changing what fields were used.