Posting operational work (resource costs/price calculation) – part 6

Using NAV4Construction, we can use specific resource cost or price models. When we post resources, we have next quantity fields:

  • Quantity – total time of resource engagement
  • Waiting time – time when resources do not make usage, because poor site organization
  • Extremely Stagnation Time – time when resources do not make usage, because force majeure
  • Effective Time – calculative field = Quantity – (Waiting time + Extremely Stagnation Time)

In NAV4Construction, we use Cost field for actual resource cost and Price form internal resource cost (transfer price for internal needs). Cost and Price are not calculate in the same way. Definition of them are placed on:

  • Quantity:
    • Cost – ‘Direct Unit Cost’ on Resource Card
    • Price – ‘Unit Price’ on Resource Card
  • Waiting time:
    • Cost – same as Quantity Cost
    • Price – ‘Standby Unit Price’ on Resource Card (using of this price depends of setup)
  • Extremely Stagnation Time:
    • Cost – no
    • Price – no

Cost Calculation

Cost Calculation is always the same. This calculation is based on resource usage and we calculate it by next pattern: Direct Unit Cost X ( Quantity – Extremely Stagnation Time )

If we want to use total quantity in calculation, we need to put ‘Extremely Stagnation Time’ blank.

Price Calculation

Price Calculation is more complex and depends of setup in ‘Res. Utilization Margin %’ field at Construction Setup. In this field we need to configure what is ‘acceptably utilization’ for us. In our example I will define that it is 70%. That means that if (Quantity-Waiting Time) is 70% or more in regard to total Quantity, this is good usage. Based on this, we have two different models of price calculation (we will use factor 0,7 instead of 70%):

Model 1: ( Quantity – Waiting Time ) >= 0,7 X Quantity

( Quantity – ( Waiting time + Extremely Stagnation Time ) ) X Unit Price

Model 1: ( Quantity – Waiting Time ) < 0,7 X Quantity

( ( Quantity – ( Waiting time + Extremely Stagnation Time ) ) X Unit Price ) + ( Waiting time X Standby Unit Price )

These Costs and Prices are the base of Construction Position cost and price calculation, based of their actual consumption.

Posting operational work (Position Journal) – part 2

If we decide to use Position Journal, we will get easier operational work, but less of analysis quality (we cannot get COGS and resource cost per position). In some other post, I will detail explain different between Output Order using and Position/Job Journal posting. Also, posting results are not in posted documents, but there are only in Position Entries.

Position Journal is standard journal as all other journals in NAV. As standard NAV journals, Position Journal also has Journal Batches. This table contains the batches we set up for our position journals. Batches let us group entries in a posting session and place a unique stamp on that session. This provides an additional measure of audit control. Whereas, source codes and reason codes tell us the source of an entry and why the entry was made, batches tell us when the entry was made and in what group of entries it was made.

Entering data in Position Journal is simply and fast. Data are the same as Output Order header, but we can put them for many different Projects, Construction Positions and Dates. When we start to fill Position Journal, we need to input:

  • Document No. (automatic from No. Series or manually)
  • Document Date and Posting Date (there are usually the same)
  • Project No. and Project Task No.
  • Position No. (system will make automatic filter for positions and we get only positions we define on Bill of Quantities, as on Output Order; if we eventually must post position out-of-BoQ, we can press ‘Show All’ and we will get complete Construction Position code list.)
  • Quantity (in Cons. Position UOM)
  • Dimension Values and some other groups

All other data (UOM, Costs, Prices, Posting Groups…) will be entered automatically from setup. If this is not first posting for this position on this project, we can see previous posted quantity for this position. We also can see contracted position quantity from BoQ. On this way, we have control before posting this values. All of that data are placed in bottom statistic area.

There are some another small additional functionality, but globally, this is all for input. After that, we only need to post journal. Posting is easy, by press Post or Post and Print button. Posting result will be placed (only) in Position Ledger Entry.

All posting of COGS and resource cost, we must do with Job Journal. About Job Journal in my next post.

Posting operational work (Construction Management) – part 1

In NAV4Construction, we can post the operational work on next ways:

  • Using ‘Output Order’ – posting of Construction Position output work and Resource and Item consumption per Project in the same time;
  • Using ‘Position Journal’ – posting only Construction Position output work per Project; we need to post consumption separately;
  • Using ‘Job Journal’ (standard NAV functionality with some specific customizations) – posting only Resource and Item consumption per Project; we need to post output separately;

Advantage of the first method is that we can post all entries with the one document. We get posted document with ‘Navigate’ functionality. Also, this method enables us to have complete statistic of cost per every Construction Position for each Project. Failing of this method is that if we have many complex position works per day, it is too complicated to make evidence and post it.

If we choose posting without ‘Output Order’, we get simply procedure for posting. We use ‘Position Journal’ for evidence of work per all Construction Position we have and separately we use ‘Job Journal’ for evidence of consumption all Items and Resources, not linked with Construction Positions. On this way we get simpler method, but we lose connection of consumption with Construction Position output. We cannot get all things and we must to decide what method we want. Good thing is that we can choose different method for each project, depend of complexity and project requirement.

Output Order

New ‘Output Order’ we get with ‘New’ command on the ribbon. We need to put Project and Task we work on them and choose Construction Position for posting. System will make automatic filter for positions and we get only positions we define on Bill of Quantities.


If we eventually must post position out-of-BoQ, we can press ‘Show All’ and we will get complete Construction Position code list. After that, we need to fill ‘Quantity’ field with output quantity for this position in presented Unit of Measure. If this is not first posting for this position on this project, we can see previous posted quantity for this position. We also can see contracted position quantity from BoQ. On this way, we have control before posting this values. If we want to see what we post for this position previous, we can press on ‘Position Executed Quantity’ field and we will get complete evidence from Position Ledger Entry.


We can fill another specific filed, depend of construction type (civil-engineering, building construction, road, maintenance…), but I will explain this in some other posts.

When we fill all necessary header fields, we have to fill lines with consumption data. We can fill lines automatic or manually. Results is the same, but automatic can make work easier if we have good normatives for construction positions.

Automatic fill process can be started by the ‘Import outputs’ command. System will use all normative lines for position in header, recalculate consumption quantity with position quantity on header and fills it. I have to notice, these are planned quantities and I am sure, we need to change some of them.

If we have manually input of data, we need to choose line Type (Resource or Item) and choose desired Resource/Item. After that, process is different depend of line type:


For Item, we need to fill ‘Location Code’. We can get default location code for project if we make this setup on Project Card. We need to fill item quantity, as well and this is all. All costs and prices for the item will be filled automatically.


For Resource, we can fill more fields. There are not all mandatory and this depend of setup for company and/or project. It is necessary to fill quantity per Unit of Measure and we can choose ‘Work Type Code’ for different Unit of Measures/Cost/Price. If this is people type of resource, this is enough and as items, costs and prices will be automatic filled. But if we choose machine resource type, we can fill more fields.

First of them are ‘Waiting Time’ and ‘Extremely Stagnation Time’. ‘Waiting Time’ is time when resource did not work because bad organization. System will be calculate cost for all quantity time, but price for (‘Quantity’ – ‘Waiting Time’) if ‘Waiting Time’ is acceptable. If this time is not acceptable, system will calculate price based on specific formula (this is very complex setup, and I will explain it in independent post). ‘Extremely Stagnation Time’ is time we use only for evidence. This is a time when we was prevented for work (nasty weather or some other force majeure).

We can fill ‘Mechanization Resource Code’ if we know exactly what machine is worked. System can propose only machines for choosing resource. If we in advance know what machine worked, we can fill this field, and ‘Resource No.’ will be filled automatically. If we have configured machinist for mechanization resource, this field will be filled automatically, but if we have not it, we can choose ‘Employee No.’ for machinist from filtered employee list only from departments who use machines.

Know we know what time machines spend for making position, but we don’t know what they are worked exactly. Because of that, we have ‘Ongoings Code’ where we can define what our machine really do. ‘Ongoings Code’ list has Unit of Measures and they are configured depending resource types. When we choose this code, we need to fill ‘Ongoings Quantity’.

If our machine is the vehicle, we can fill additional fields: ‘Mileage’ and ‘Tour Quantity’.

This is only base story about this process and I will detailed explain some specifics in some new posts.


Before posting, we need to change status. Changing status make checking of all necessary fields input. NAV will make evidence of username, date and time for making document and for status changing, because these are very important data.

After that, posting process is simply. For each posted document, we can make storno (correction) document very easy, but I will explain it in later posts.

Construction Position and Norms – cost analyze I (4/7)

If we have minimum one line with Work type, we need to set Price Analyses for this work. We can do that with Price Analyses command. System will open new specific page with top lines and bottom lines. Top lines present normative lines and bottom lines represent planned consumption for each line.


For each top line with Work type, we must to configure consumption. Consumption represent resource and/or item consumption. When we set item and choose ‘Cost’ as Cost Source, we will get actual cost for this item. If item is material, cost is Actual Cost with all charges, and if item is finish-good we get actual cost from automatic Cost Accounting (see my old posts about Mfg. Cost Accounting). If we choose resource, we will get Actual Cost of resource (see my old posts about Resource Cost Accounting). We can use Work Type Code for resource (different unit of measures or specific works) also and system will use Actual Cost for this Work Type. We have ‘Inside Costs’ also and these represent Unit Price for resources and items. We have not use that, but this is additional possibility. System will recalculate costs and add them to the top lines.

We can use different Cost Sources, but about that in next post. This post describe only simplicity of configured normatives using really actual costs of resources and items in different modes.

If we use non-Work type of normative lines, we cannot configure this. If we use subcontractors, we need to put direct subcontractor cost. If we use (sub)normatives, cost already configured on used (sub)normatives.

Construction Position and Norms – norms creating (3/7)

…I forgot…there is function for massively creating of Construction Positions, but this function runs from Bill of Quantity page. We will discuss about this function in some later themes. Now, we will continue…

Normative is place where we make specification of planned consumption for Construction Position. If we compare construction with production, Normative is as BOM and Routing altogether. But construction is more complex than production. You can find Construction Positions on: Quantity Surveyor Section->Normatives->Normative List.

If you want to see existing Normative, you just need to double-click on some of them. If you want to create new, you have to press ‘New’ command. I will explain creating process.


You need to set Normative No (manually or automatically using number series) and normative description if you want it (is not necessary).

After that you have to configure Unit of Measure. There are the specifics. You can choose only Unit of Measure which is configured on Construction Position. Does not matter is this this Unit of Measure the same as Base Unit of Measure on Construction Position. But it must be same as one of all Unit of Measures from Construction Position. If we use not-Base Unit of Measure, system will use ratio defined on Cons. Position for all quantities and costs.

When we fill Normative Header, we must define Normative Lines – Price Analysis Lines. We can use three types of line entries:

  • Work: It used for configure resource and/or item consumption. For this type, we must to configure precisely consumption and this will be explain in next posts.
  • Subcontractor: It used for subcontractor work. We can choose vendor number (if we know them, but is not necessary), but we must to fill cost. This cost is value from quote or expected cost from subcontractor contract.
  • Normative: It used if we have complex normative, combined from more different normatives. In this case, we have not repeat all consumption entries, but we need fill existed Normative Numbers.

Very important is we can use combination of all three types for each Normatives, because we often have case where partially use our resources and partially resources from subcontractors.

If we have minimum one line with Work type, we need to set Price Analyses for this work. In next post, we will explain this process. When we set all parameters, we must to change status to Released using Apply command and after that we must to connect this Normative with Construction Position.

Cost Accounting for Resources (reporting) 4/4

Resource Cost Accounting has stay in many reports and analysis. These reports from Quantity Surveyor Section (in Bill of Material calculation), to Construction Management (actual costs per project) and Mechanization Management (detail costs of finer level of resources – each mechanization/vehicle resource).

The most of reports can make cost breakdown from total amount or amount per unit to amounts per cost types (depreciation, fuel, oil, maintenance…) for each capacity plan or usage in Job Ledger Entry or Resource Ledger Entry. System present complete breakdown cost structure, but present separately usage cost and standby cost also. We can see all deviations from G/L to calculated and applied entries.

Depends of options you choose, the most of these reports can give analysis with less or more details. Solution has many and many analysis, but I will recommend BI tools we have.

The best of these reports is that they can give you “smart” analysis and you can make right business decision, e.g. are you need to buy new resource or keep old one with maintenance. You can compare credit/leasing installment costs (with fuel/oil consumption for new machine) with maintenance costs (with increased fuel/oil consumption for old machine). Of course, you can use actual costs, not planned.


Cost Accounting for Resources (calculation) 3/4

Applying Calculated Cost automatic calculation process recalculate evaluated Resource Costs to actual Resource Cost. Actual resource costs are the really costs bookkeeper posted as payables costs on G/L accounts (energy, fuel, oil, tires, maintenance, depreciations, payrolls…).

Complete Applying Calculated Cost automatic calculation process is based on next steps:

1)     Setting the actual mapping

2)     Starting the calculation

3)     Configure date rang

4)     Getting Resource Cost Calculation results

5)     Applied Costs to entries and choosing model of applying

We will discussed about all of them:

Setting the actual mapping

We can make more resource mapping variants in the same time. When we want to apply specific mapping to entries, we must to set mapping name on Resources Setup, on Default adj. res. Name field. This name, we must configure on all mapping line on Adjust Resources Cost table.

Starting the calculation

We need to start Calculate Resource Cost command. When we start this function, we need to choose calculation variant:

  • based on actual quantity in entries
  • based on planned quantity


Configure date rang

System make calculation for specific date rang. To get correctly data, we always have to set start date as first day in year. End date is the last date for calculating period. As this setup, system will always make cumulative calculation.

Resource Cost Calculation results

When function finish procedure, system used value in Cost Posted to GL, and depend of choice calculated next:

  • Actual Quantity: value in Cost Posted to GL divide with actual resource quantity for period in field Resource Quantity on the same table
  • Planned Quantity: value in Cost Posted to GL divide with planned resource quantity configured on Resource Card

This results was multiplicity with percent in Share of Cost on G/L Account % field and put it value in Calculated Cost field.

We have choice in calculation because these costs is used in offering process. Sometimes, resources did not works at specific period. If we calculated with actual quantity we can get abnormal resource costs for desired period (e.g. civil-engineering machines on winter period). Later in same year, we can recalculate complete costs for complete period with actual quantities.

Applied Costs to entries

When calculate process finished, difference from Calculated Cost and Unit Cost placed in Adj. Direct Unit Cost. This is value for update existing value in Resource Ledger Entry and Job Ledger Entry.

We can look up values and analyze them. We can continue to use planned values in Unit Cost field or apply calculated values. If we want to apply calculated values, we need to start Apply Calculated Cost command.


What and where to apply?

When we start this command, we must to choose method of applying or we can cancel job:

  • Apply cost calculation: NAV will only update calculated values to Direct Unit Cost and Unit Cost; new entries will be using new costs.
  • Apply cost calculation and post to entries: NAV will update values to Direct Unit Cost and Unit Cost and update all values in Resource Ledger Entry and Job Ledger Entry on desired period.

When process is done, NAV will marking field Applied Calculated Costs.

What else?

Usually, we don’t use the same Unit of Measures for all resource usage. Sometimes, we use kilometers for vehicle usage, but sometimes we use work hours or transported volume, or combination of them, or…

We have standard solution for posting this solution, we can use Work Types with configured additional Unit of Measures. But, how to calculate cost of them? There no exist completely exact way to do this, but we can get “enough exact” way. First, we need to use Unit Price for internal reason (or external, it doesn’t matter). We must to use this for standard resource price and for all work types.

We have to set that we want to use that calculation system on Resource Setup and Default Cost Type (Fixed, % Extra, LCY Extra). When we start this functionality, NAV will automatic calculate cost per work types using Unit Price for work type and Price/Profit Calculation and Profit % values on Resource Card fields.