Where are the Job to Date fields that use to be in the JC1 Table?

Before the Job Cost module was rewritten, the Job to Date information for Costs, Revenue, and Payment was located in the JC1 Job Cost Table. That information is now stored in the JC_JobBillingHistory Table.

However, they have now broken this out by Fiscal Period and Fiscal Year. To get this information, you might need to add a grouping to your report or add a subreport to add up all the costs, revenue, and payment across all periods.