Custom JC Formula

Hello.  I'm very new to SAGE and am trying to create a Custom Total in Job Cost using a Public Formula, however, when I try to insert the formula in the Custom Total Settings window, I can only see the JC formulas.  The Public Formulas button is greyed out.  I assume it is in settings somewhere to allow me to use it, however, I cannot find it.  Thank you!

  • 0

    Hi David.  The program will only display formulas that are valid for the task, so in other words if the formula isn't created using the appropriate records to calculate the total, the formula won't display in the public formulas.

    If you are Tracking categories in Job Cost the formula must use fields from the category record. If you are not tracking categories the formula must use fields from the Cost Code record.

    Check in File, Company Settings, JC Settings to see if you are Tracking categories, then review the records used in your formula to determine if the fields used in the forumula are from the correct record.