Sage 100

 View Only

  • 1.  Job Cost "Future Cost" fields?

    Posted 06-28-2019 00:03
    Anyone know what happened to the "Future Cost" field that used to be in JC2_JobCostDetail (legacy)?
    I know all the YTD, PTD, and JTD fields were eliminated, but future costs? The only thing I can find close is "UnbilledCost" in JC_JobCostCodeDetail (framework). Is that it? I don't know enough about Job cost to go back through and track it down! Help please! 
    TIA
    -M

    ------------------------------
    Michelle Forsey
    Eide Bailly, Inc.
    801-456-5470
    ------------------------------


  • 2.  RE: Job Cost "Future Cost" fields?

    Posted 06-28-2019 02:12
    Future Cost and Future Units in JC2 are gone b/c in Framework you can post to any future period (instead of being lumped into a single future bucket). When you go to Job Maintenance > Cost Code button > choose Cost Code & Cost Type, the YTD, PTD, and JTD are still there but in the Framework style. They are "screen fields" (not database fields) that reflect a summary calculation of Cost and Units from JC_JobCostCodeHistory based on the Fiscal Period and Fiscal Year dropboxes on the screen. 

    To get the old "Future Cost" and "Future Units" on a report, you'd have to do a subreport to JC_JobCostCodeHistory which includes FiscalPeriod and FiscalYear as part of the key. It's purposely structured just like AR_CustomerSalesHistory, IM_PeriodPostingHistory, and GL_PeriodPostingHistory. From there you sum up Cost and Units fields for the future Fiscal Years / Fiscal Periods you identify and return it to the main report.

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------



  • 3.  RE: Job Cost "Future Cost" fields?

    Posted 06-28-2019 10:07
    Thanks @Alnoor Cassim and @Doug Higgs this information is incredibly ​​​helpful!

    ------------------------------
    Michelle Forsey
    Eide Bailly, Inc.
    801-456-5470
    ------------------------------

    Original Message


  • 4.  RE: Job Cost "Future Cost" fields?

    Posted 06-28-2019 07:05
    Edited by Doug Higgs 06-28-2019 07:13
      |   view attached
    I created a Job Cost report in v2018 recently that contained PTD and JTD cost and billing.  I joined JC_JobBillingHistory to JC_Job.  I used the following Crystal syntax selection formula:  cstr({JC_JobBillingHistory.FiscalYear}) + cstr({JC_JobBillingHistory.FiscalPeriod}) <= cstr({JC_Options.CurrentFiscalYr}) + cstr({JC_Options.CurrentPeriod})

    Field Formulas:
    PTD_Actual_Cost
    If {JC_Options.CurrentFiscalYr} = {JC_JobBillingHistory.FiscalYear} and {JC_Options.CurrentPeriod} = {JC_JobBillingHistory.FiscalPeriod} then
    {JC_JobBillingHistory.ActualCosts}
    Else
    0

    JTD_Actual_Cost
    {JC_JobBillingHistory.ActualCosts}

    PTD and JTD Actual Billing is the same structure as the above costs


    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 5.  RE: Job Cost "Future Cost" fields?

    Posted 06-29-2019 13:32
    @Doug Higgs what field did you use to join JC_Job and JC_Options?  ​

    ------------------------------
    Michelle Forsey
    Eide Bailly, Inc.
    801-456-5470
    ------------------------------

    Original Message


  • 6.  RE: Job Cost "Future Cost" fields?

    Posted 06-29-2019 13:50
      |   view attached
    JC_Job.JobNo joined to JC_Options.ModuleCode

    Inner join
    Not enforced
    !=


    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


Related Content