In this chapter we have used some changes to the job functionality in order to make it work for Cronus International Ltd. to sell Microsoft Dynamics NAV.
For some companies it is important to know the total number of hours required for a job and the number of hours used rather than the exact amounts.
For this we have created new flow fields in the Job Task table:
The flow field definition is special.
Sum("Job Planning Line"."Quantity (Base)" WHERE (Job No. = FIELD(Job No.), Job Task No. = FIELD(Job Task No.), Job Task No. = FIELD(FILTER(Totaling)), Contract Line = CONST(Yes), Planning Date = FIELD(Planning Date Filter))) ...