Crystal Reports

SUGGESTED

I am writing a report in Crystal used JC_JobBillingHistory. In SAGE 2017 this report used JC1???file and worked fine. In SAGE 2020 it will not give me the jobs if they have not had activity. I believe it has to do with the Fiscal Year and Fiscal Period. I need it to populate all the jobs. Any help is appreciated greatly.

Parents
  • 0
    SUGGESTED

    If you look in the mascrcw.ini file (located in the home directory) you can see the mapping of tables and fields.  There are other ways to get this information, but this is the easiest for me to search.  JC1 is now the JC_Job table.

    JC0_Parameters=JC_Options
    JC1_JobMaster=JC_Job
    JC2_JobCostDetail=JC_JobCostCodeDetail
    JC3_TransactionDetail=JC_JobTransactionDetail
    JC4_JobFieldRptEntry=JC_JobFieldReportHeader
    JC5_JobFieldRptEntry=JC_JobFieldReportDetail
    JC6_TransactionDataEntry=JC_JobPostingHeader
    JC7_TransactionDataEntry=JC_JobPostingDetail
    JC8_DailyJobTransaction=JC_JobDailyTransactions
    JC9_OverheadAllocation=JC_OverheadAllocation

  • 0 in reply to Sage100Reports

    Hi John Luddy, if the above suggested answer helped, please do mark it as verified White check mark for the benefit of others in this forum :). Thank you!

  • 0 in reply to Erzsi_I

    I had the same problem. For the jobs with not activity I did a job posting entry (direct cost) with the amount -0-. When I ran and updated the journal they appeared on my report.

Reply Children
No Data