Sage 100

In version 2018, Job Cost module I am looking for JTDActualCosts, JTDInvoiceBilled and JTDPaymentReceived that used to be in JC1 for a report I'm recreating. Anyone know what table these fields are in for 2018? I have looked thru the Cross Reference information. @AlnoorCassim

It looks like the same data can be derived from JC_JobBillingHistory.

Appears to me a custom report will be needed to pull from JC_JobCostCodeHistory and JC_JobBillingHistory. Running totals would be effective. These history files are updated with current open jobs not just when they get ""moved"" to history at period end. They must be what is being used to populate the Job Status screen values. The Period to Date, YTD & JTD summaries appear to now be calculated values and not values pulled from pre-populated fields.

@MicheleHerzog I had to recreate the same fields in a subreport from Job BIlling History. I did a subreport because not doing a subreport created multiple lines to appear and LOOKED like I billed 3-4 times more. Subreport took care of it.

This is really inconvenient. All reports that use those fields need to have a subreport when they upgrade to 2018. I am running into this now with an upgrade.

Thanks to all. The reports I'm recreating are in Sage Intelligence. I will let you know if I have to create 2 containers and then a union report or if I can get everything to work in 1 container and a standard report.

thanks guys I just got tasked with solving this problem today!

If anyone has a sample Crystal subreport they want to share with JTDActualCosts, JTDInvoiceBilled , PTDActualCosts, and PTDInvoiceBilled calculations it would be greatly appreciated.

This report focuses on jobs in history. The subreport is the same for both jobs in history and in open status.

Thanks a million @CooperBlack !

Attached is a Sage Intelligence report for Job Transactions that includes JTDActualCosts, JTDInvoiceBilled and JTDPaymentReceived. I did not have to do a union report (equal to a sub-report). If you import into Sage Intelligence you can see the filters and then look at the container. I prefer Sage Intelligence any day over a Crystal report as it goes directly to excel and then I create pivot tables.