Does the report use any of the other fields from JC0?

The other fields from JC0 are CostType 1-12 and CostTypeDescription 1-12.

What value is in the new system field?

What value is in the new system field?

This field appears to be a flag to designate if job cost has never been set up before.  If the field is set to "Y", then you probably can't do anything with the job cost module until you configure its options in the setup screen.

If the field is set to no, then this indicates that the module's setup options have been configured.

What value is in the new system field? = 2

Job cost is setup as we have been using it for years, I did not find a Y or N in the selection expert or any where else.

The reason for the questions, this report is used for billing info. If I run the report before time card data entry I get a report with all the jobs. After time card entry any new jobs will not be on the report until after I process payroll and time card job cost selection. Been trying to figure this out.

Thanks!

According to the file layout for the JC0 file, the new system field should contain a "Y" or "N".

Anyway, I don't think this is the underlying problem.

What tables are being used and by what fields are the tables joined (Database menu - Database Expert - Links tab)?

JC1 Job number to JC2 job number

JC1 AcctMethod to SY0 Companycode

JC1 Divisionnumber to AR_Customer ARDivisionNo

JC1Customernumber to AR_Customer CustomerNo

SY0_ Companycode to JC0_ Companycode

{JC1_JobMaster.JobStatus} = "O" and

{JC1_JobMaster.JobType} = "BTM" and

{JC2_JobCostDetail.CostType} <> " " and

{JC1_JobMaster.BillingMethod} = "T" and

{JC1_JobMaster.RevisedEstimate} >= 0.00 and

{JC0_Parameters.NewSystem} = "2"