O'Reilly logo

Microsoft Dynamics NAV 2009 Application Design by Mark Brummel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Changing jobs

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.

Quantity budgeting

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:

Quantity budgeting

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))) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required