In essence, project cost control is concerned with the difference between a job’s budgeted and actual values. It helps ensure that the revenues you earn and the expenses you incur match estimates as much as possible. Comparing these figures over multiple periods is crucial for timely, effective project management.
The cost control functionality in Microsoft Dynamics 365 Business Central uses job ledger and account entries to show you how close your projects are to being cost-effective. Whereas job ledger entries record revenues and expenses related to day-to-day operations, such as item consumption or hours spent on a job, the work breakdown structure and the budget contain the expected sales and costs and form the basis for creating account entries from a chart of job accounts.
The accounts are linked to both the job ledger and the budget. This means that, like in Finance, you can use the account chart to create budget-to-actual comparisons for multiple cost types and generate a variety of business insights.
For even more insights into project performance, you can set up views to analyze the dimensions stored with job ledger and account entries. You can then set filters on budgeted and actual values, or on their variances, to specify what to include in a view.
The chart of job accounts is the most important component of cost control. It covers the key values used for tracking cost performance, that is, the types of revenues and expenses you might encounter, and can be as compact or large (detailed) as you want.
Both the job ledger and the job account entries are created based on this chart. They are later consolidated in a financial report.
Chart of job accounts and account setup#
Not unlike G/L entries in Finance, entries related to projects are linked to accounts with the help of Job Accounts Setup.
All accounts are identified by their general product posting group, job type, work package, and phase code. Any combination of these can be assigned to a sales and a cost account from the account chart. See the following table for more information.
|Gen. Prod. Posting Group||Represents the general product posting group of an item, a resource, or a G/L account for which you specified usage or consumption, budget values or revenues. This group is the only mandatory field on the Job Accounts Setup page.|
|Job Type||Specifies the type of job.|
|Work Package Code||Specifies the work package from the WBS line on which you posted or budgeted usage or revenue.|
|Phase Code||Specifies the phase code from the WBS line on which you posted or budgeted usage or revenue.|
You can use this information, for example, to determine
- resource expenses when managing research projects with internal resources.
- the cost of small items for onsite assembly.
- travel times of external employees for major projects.
- follow-on orders (=phase code) for customer projects.
You must set up the chart of job accounts and fill in the Job Accounts Setup page based on what you want to analyze later.
You can add an account more than once to Job Accounts Setup. To see if and how often an account is used:
- Choose the search icon, enter Chart of Job Accounts, and then choose the related link.
- Select an account. On the ribbon, choose Related > Account > Where-Used List.
The page that opens also shows where to find the account in templates created through the job measurement functionality.
Switch to setup with phase codes#
Previous project365 releases didn’t include phase codes in Job Accounts Setup. You need to switch to a newer version to make use of this feature.
- Choose the Search icon, enter KUMAVISION Module Setup, and then choose the related link.
- On the ribbon, choose Actions > Setup > project365 App Setup.
- Turn on the Use Phase Code in Job Accounts toggle. This opens a dialog. Choose Yes.
Existing entries are now copied to a new setup page and deleted from the old one.
The setup without phase codes has been discontinued. Newer versions no longer support this feature.
Job ledger entries = actual values#
Each posting that goes toward a job creates a job ledger entry. These entries are the basis for billing, that is, they show job usage and consumption and store the revenues generated from invoices. They are also used to measure job progress.
When you post to a job, an account is assigned to the created job ledger entry based on what you entered in Job Accounts Setup. This gives you access to the latest data on job usage and sales so that you can track revenues and expenses throughout the lifecycle of a project.
Job account entries = budget figures#
Job account entries store the quantities and values from planning. They are created based on the planning level of a WBS line. They originate with budget line entries if you selected the Copy Budget checkbox on available budget lines or with the WBS line itself if planning is set to that level.
You need to run a function to create job account entries:
- Choose the Search icon, enter Update Job Account Entries, and then choose the related link.
- Set filters as necessary. If you don’t set filters, account entries are created for all jobs.
You can also update entries for a single work breakdown structure. Open a WBS and choose Actions > Functions > Update Job Account Entries on the ribbon.
If you rerun the function, the account entries are deleted and recreated from scratch. This gives you greater flexibility when budgeting a job, as the dimensions, prices, and planning level of a project might be subject to constant change.
See the following table for an explanation of the Job Account Entries page. You can view this page by choosing Related > Job Account Entries on a WBS, for example.
|Date||Uses the planning level to show the starting date of the relevant WBS or budget line.|
|Job Account No.||Shows the number of a cost account from the chart of job accounts.|
|Sales Job Account No.||Shows the number of a revenue account from the chart of job accounts.|
|Work Package Code||Shows the relevant work package.|
|Quantity (Base)||Shows the relevant quantity.|
|Total Cost (LCY)||Shows the relevant cost.|
|Total Price (LCY)||Shows the relevant price.|
|Entry No.||This field is filled in automatically when a job account entry is created.|
As explained earlier, the product posting group is crucial to identifying the correct job account for cost control. If an account is retrieved based on budget lines, the system uses the group of the resource or item stored there to find the account.
If you plan at the WBS line level, the posting group related to the work package billing type and number is used. Typically, this is the group of a billing resource. Because of how account entries are stored in the system, you need to run the update function each time you change planning data.
If a job has more than one WBS, job account entries are created for all structures, but only the WBS that is currently active is shown in cost control.
We recommend you use the job queue to update account data on a regular basis.
Account entries for revenues#
Typically, cash inflow is recorded later than expenses. In fact, project work is often paid for only in subsequent accounting periods.
However, to monitor jobs accurately, the system needs to store expected sales prior to payment. This is what the Sales Job Acc. Entries From field on the job card is for. You can find the field on the Planning tab. It has the following options:
Choose this option if you want job account entries to be created as described earlier. You can still use the Base Date Sales Job Acc. Entries and Formula Sales Job Acc. Entries fields to change the workflow to some extent.
If you choose Planning Date in the Base Date Sales Job Acc. Entries field, the assumption is that you generate revenue when you record job usage, and a date formula doesn’t apply.
If the field is set to Date Formula, the date on which sales are generated is calculated based on the budget date and a specified formula.
The budget line shows 05/15/21. The system then calculates 06/15/21 as the date that needs to be stored with the sales account entry.
(Advance) Payment Plan#
Payment and advance payment plans work in the same way. The only difference is their data source. For more information, see the Advance Payment feature.
If you choose one of these options in the Sales Job Acc. Entries From field, you can no longer enter a base date or a date formula.
From this point on, the job budget is no longer required. Instead, revenue is created according to the payment plan. The plan is used to store all information needed for billing a job, such as posting dates and prices.
Allocating a sales account to a payment plan works in the same way as allocating a cost account when you create job account entries from a WBS line. The system will use a work package, a billing type, and a billing number (usually of a billing resource) to determine the correct account.
For cost control to capture the entire cash inflow, the final invoice must also be part of the plan. However, this invoice must include only the amount that remains after all amounts from partial invoices have been subtracted from the total price.
When you create the final invoice based on an invoice suggestion, the total price is shown on the invoice in addition to the partial amounts applied as credit memos.
If you want to use a payment plan in-house and remove it from billing, clear the Copy to Suggestion checkbox on the payment plan lines.
Set up financial reports for jobs#
You can now use the job ledger and account entries to set up financial reports for analyzing projects based on multiple criteria. The reports have the same purpose and function as those for analyzing G/L accounts and entries in Finance.
You can create more than one financial report, for example, to set up different reporting environments for internal and customer jobs. To create a new report:
- Choose the Search icon, enter Job Financial Reports, and then choose the related link.
- On the ribbon, choose New, and fill in the fields as described in the following table.
|Name||Enter a name for the report.|
|Description||Enter a text that describes the report.|
|Row Definition||Specify the criteria for analysis on the lines. The layout stored in this field is used when you open a financial report but can be changed at any time.|
|Column Definition||Specify the criteria for analysis in the columns. The layout stored in this field is used when you open a financial report but can be changed at any time.|
The report itself is set up in a way that you can add accounts to individual lines. You can also specify formulas or enter lines that total amounts or quantities.
- Choose the Search icon, enter Job Financial Reports, and then choose the related link.
- Select a report. On the ribbon, choose Edit Row Definition and fill in the fields as described in the following table.
|Row No.||Specify a number to sort lines according to your requirements.|
|Description||Specify the area that you want to show on the line.|
|Totaling Type||Choose one of the following options:
Shows the value of one or more job accounts.
Includes total lines from the chart of job accounts.
Uses a formula on the schedule.
Set Base for Percent
Calculates percentages of a total.
|Totaling||Fill in this field based on what you selected as a totaling type.|
|Row Type||Specify the purpose of the line:
Shows only transaction data.
Balance at Date
Totals data up to a given date.
Shows the starting balance of accounts assigned to the line.
|Line Amount Type||Specify whether you want the line to show total prices or costs.|
|Show Opposite Sign||Select this checkbox if you want to show negative amounts as positive and positive amounts as negative.|
|Show||Specify whether the line is shown on screen and on printouts.
Select If Any Column Not Zero, When Positive Balance, or When Negative Balance if you want to include the line only under the specified circumstances.
|Select one of these checkboxes if you want to see text in bold, in italics, underlined, or double underlined.|
|New Page||Select this checkbox if you want to insert a page break after the line.|
To insert an account into a row, choose Actions > Functions > Insert G/L Accounts. The row can then be used immediately.
- Choose the Search icon, enter Job Financial Reports, and then choose the related link.
- Select a report. On the ribbon, choose Actions > Functions > Edit Column Definition and fill in the fields as described in the following table.
|Column No.||Specify a column in this field.|
|Column Header||Enter a name to describe the column on screen and on printouts.|
|Column Type||Net Change
Shows only transaction data.
Balance at Date
Totals data up to a given date.
Shows the starting balance of accounts assigned to the line.
Year to Date
Shows all values created in the current year up to a given date.
Rest of Fiscal Year
Shows all values from a given date.
Entire Fiscal Year
Shows all values created during a full fiscal year.
|Entry Type||Specify if you want to show job ledger entries, job account entries, or one of two commitments.|
|Value Base||Specify if the entry represents an amount or a quantity.|
|Formula||Fill in this field if you selected Formula in the Column Type field.|
|Show Opposite Sign||Select this checkbox if you want to show debit amounts as negative and credit amounts as positive values.|
|Comparison Date Formula||Fill in this field if you want to specify a period for budget vs. actual comparisons in relation to the period set in report requests. You can enter a common unit of time here (D, WD, W, M, Q, or Y).|
|Comparison Period Formula||Fill in this field if you want to compare accounting periods. You don’t enter a unit of time here but a formula.
For example, enter -1P if you want the system to retrieve the same range of dates one accounting period earlier.
|Show||Specify if the column is always or never shown or only shown when values are positive or negative.|
|Rounding Factor||Specify if and how to round for clarity.|
Financial report card#
You can select Edit Job Financial Report on the ribbon to see the card related to the new report. Report values are shown in the rows and columns according to the filters you set.
The header displays the names of the report and the row and column definitions. You can filter data there as well.
All default values on the page can be changed to meet your requirements. You can also use the lookup on a field to see how it relates to the chart of job accounts. On the page that opens, you can then use another lookup if you want to know where an entry originally comes from.
To switch from a report column (or analysis period) to another, choose Column (or Period) on the ribbon, and then choose Previous Column (or Period) or Next Column (or Period).
To copy the financial report to a new Excel worksheet for further editing, choose Export to Excel.
As an alternative, you can use the dimensions posted with job ledger entries to monitor projects. Dimension-based analyses include both global dimensions—posted directly to job ledger entries—and additional dimensions linked to a job. For easy filtering, they’re part of the following aggregated entries:
- Job analysis view entries—created from job ledger entries—to represent actual values.
- Job analysis view budget entries—created from job budget entries—to display budget figures.
Before you start working with this kind of analysis, it might be helpful to get an overview of the potential sources of a dimension linked to a job, a WBS line, or a budget line, as listed in the following.
For a basic overview of dimension capabilities, see Work with Dimensions.
Sources of job dimensions#
- With certain fields in Jobs Setup filled in, the dimension (for example, a cost object) might have been automatically added to the job, with the code of the dimension matching the number of the project.
- The dimension might have been entered on the template from which the job was created.
- The dimension might be assigned to a job type. You can set up one dimension per type of project in Jobs Setup, with the dimension value matching the type.
- The dimension might have been copied when a customer was assigned to the job. Alternatively, it might have been transferred from a contact or a customer template assigned to the job if the project was set to Quote at the time.
- The dimension might have been added when a project manager was entered for the job provided you’ve turned on the relevant feature in Jobs Setup.
- The dimension might have been copied from a main job linked to the project.
- The dimension might be from a responsibility center that was entered for the job.
- The dimension might have been copied from a salesperson if the code of that person was added to the project.
Sources of WBS line dimensions#
- The dimension might be among those that are inherited from the job to the WBS lines set up for the project.
- The dimension might be from the work package master if a work package was validated on the WBS line.
Sources of budget line dimensions#
- The dimension might be among those that are inherited from the WBS line to the budget line during creation of the latter.
- The dimension might have been copied from a resource (group), an item, or a G/L account when the No. field was validated on the budget line.
Dimension sources during job postings#
A dimension that is stored with base data (such as a resource or a vendor) might be passed along to all kinds of documents and journals in the system.
- A job dimension is copied to a document or journal line when the job number has been validated on the line.
- A dimension stored with a work package is copied to a WBS or a budget line when either line is selected for posting. What line must be selected depends on the posting level specified for the job.
- Even WBS or budget line dimensions created manually in planning are copied to job ledger entries if certain fields in Jobs Setup are filled in.
On the Dimensions FastTab in Jobs Setup, you can see the criteria that will be used for job-related dimension transfers. You can also fill in or change fields on the tab to specify, for example, what dimensions the system should set up for job types or for main jobs and how it should copy dimensions from project manager resources.
Job analysis views#
Job analysis views offer insights into project data based on analysis view entries and analysis view budget entries.
Analysis view entries can be set up on the job analysis view card. You can use four additional dimensions per card.
To open a list of all cards, choose the Search icon, enter Job Analysis View List, and then choose the related link.
Each line on the page shows if budget values will be created from the card, when the card was last modified, and what dimensions are available.
Choose a card for editing and then fill in the fields as necessary.
|Code||Specifies a code for the job analysis view. The code must be unique and can reflect the purpose of the view.|
|Name||Specifies the name of the view.|
|Job Account Filter||Specifies the accounts that will be analyzed. If the field is left blank, the job analysis will include all accounts.|
|Job Filter||Specifies the jobs shown in the view.|
|Date Compression||Used to define for which period entries need to be merged, that is, how detailed a view will be.
For example, if you want a monthly summary, you can use this field to total the job ledger entries created during a full month and combine them into a single entry.
The date of the first posted job ledger entry is then assigned to the entire period.
Entries are totaled in a way that no data required for analysis is lost. For example, entries included in the analysis must have identical dimensions.
|Starting Date||Used to set a date from which entries are included in the view.
All job ledger entries posted on or after this date are then compressed to the level you chose in the Date Compression field. Earlier entries are merged into one entry shown on the date immediately preceding the starting date.
|Last Updated On||Shows when the card was last updated.|
|Last Entry No.||Shows the number of the last job ledger entry that was posted before you updated the view. Entries posted since the last update aren’t included in a view.|
|Last Budget Entry No.||Shows the number of the last job budget entry that was entered before you updated the view. Entries specified since the last update aren’t included in a view.|
|Include Budgets||With the toggle turned on, job budget entries are also updated. This creates analysis view budget entries automatically.|
|Blocked||If this toggle is turned on, the view cannot be used at all.|
On the Dimensions tab, choose the four additional dimensions you want to analyze on the card.
To store selected dimension values, choose Related > Analysis > Filter on the ribbon. This ensures that only certain values are totaled on the card.
You can also choose Update to find all job ledger and account entries that match the filters you set and use them to create job analysis view and budget entries.
If card changes affect existing analysis entries, the entries are deleted. For example, if you edit the Date Compression field or a dimension filter, the job analysis view and budget entries are recreated at the next update. This step is necessary because the criteria for creating entries have changed.
Every time you update a view, the system creates data-rich job analysis view and job analysis view budget entries from the job ledger and job budget entries that include the four dimensions you want to analyze.
The analysis view budget entries contain the values shown in the view, the budget name, and the job account, followed by the four dimensions, the posting date, the quantity, and the amount. In short, they represent the link between key data stored with job account entries and the dimensions of a document.
The same is true for analysis view entries. In this case, dimension data is merged with data from job ledger entries.
In the Quantity and Amount fields, you can use a lookup to see where an entry originates.
Analysis views on financial reports#
You analyze by dimensions in the same way you analyze by job ledger and account entries.
Open a row definition and use the Assist button next to the Name field at the top to look at the name of the assigned analysis view. If you chose a view, the report will be filled in automatically with analysis view entries.
You can use the lookups on individual lines to identify what analysis view entry was used to fill in a certain line. Choosing the lookup first opens a page that shows the job account chart related to the account used in a certain column.
When you then select a Quantity or a Cost Amount field, you can see the job analysis view entry and the dimensions stored for the analysis view.
Difference to standard functionality#
At a cursory glance, the added views might not seem to offer anything new. But you can now set flow filters on the four dimensions described earlier.
You can already store these filters when you set up a row definition. To use them, unhide the four columns that show the relevant dimension values.
The benefit of specifying filters on the report instead of each card individually is that analyses will all have the same design and thus remain comparable over time.
Job analysis by dimensions#
Job analysis by dimensions also uses the analysis view and analysis view budget entries described earlier.
- Choose the Search icon, enter Job Analysis View List, and then choose the related link. This shows you list of all views that have been specified so far.
- On the ribbon, choose Analysis by Dimensions to open the setup and filter view. The date, job account, job, budget, and responsibility center filters are included by default.
- Choose the other four dimensions based on the selected analysis view. Each dimension can be assigned to a row or a column. You don’t need to specify a default value for a dimension (as is required for a financial report). To link the dimension to an account, the system will use the job accounts stored with the analysis view card, and you can set filters on them there.
The other fields shown on the card are described in the following table.
|Date Filter||Limits the period for analysis based on a posting date.|
|Job Filter||Limits the number of jobs shown.|
|Budget Filter||Used to include a certain budget. You limit the display of budget values on the Options tab.|
|Responsibility Center Filter||Limits analysis to a certain responsibility center.|
Shows the actual values posted.
Shows the values allocated to the budget on the Filters tab.
Shows the difference between budgeted and actual values as a number.
Shows the difference between budgeted and actual values in percent.
Shows the difference between budgeted and actual values as an index. An index of 100 means that the values are identical. If the percentage is above or below 100, the actual values are greater or smaller than the budgeted values.
|Show Amount Field||Two options are available in this field.
Shows the values as quantities only. For usage entries, these are the actual posted quantities—changes to invoice quantities not included.
Shows the amounts stored with the relevant entries.
|Rounding Factor||This field reduces large values If you want to see more than one column in a view.
Shows values unchanged and with all decimals.
Shows integer values without decimals.
Shows values in units of thousands.
Shows values in millions.
|Show Column Names||Specifies if you want to show the names of individual columns. For example, you can use this field to switch between job account numbers and descriptions.|
|Show Opposite Sign||Specifies if you want to show negative values as positive and positive values as negative.|
To swap line and column views, choose Related > Actions > Reverse Lines and Columns on the ribbon.
To open the analysis by dimensions matrix, choose the Show Matrix action. There, you can choose Export to Excel to copy the analysis data to a new Excel worksheet.
Job analysis views vs. job analysis by dimensions#
Both options create analysis view and analysis view budget entries based on a job analysis view card.
Job analysis uses a view that has fixed lines and columns, created from row and column definitions. For a more targeted assessment of jobs, you can set filters on up to four additional dimensions.
However, job analysis by dimensions puts even fewer restrictions on how views can be structured. Both the lines and columns can show default dimensions, such as the job account and period, and additional dimensions set up on the analysis view card.
Moreover, you can swap the lines and columns and don’t need to create a layout for either. The drawback is that you can only see what has been budgeted, posted, or the difference between those numbers. But, as an example, you cannot use this view to compare budget to actuals by including all three values.
Track ongoing jobs#
You can use multiple functions to assess an ongoing job at the push of a button.
The statistics available for jobs and main jobs can provide you with key insights into project progress and performance. They include budgeted and actual figures and the variance between both. To view the statistics:
- Open a job card.
- Choose Related > Job > Statistics on the ribbon.
You can now see a job’s budgeted and actual values.
This tab shows you the budgeted values at the level of the WBS and the budget lines, that is, detailed planning.
This tab shows you how far the job has progressed.
The fields of both tabs are described in the following table.
|Budget (LCY)||Shows the budgeted total cost based on WBS lines in local currency.|
|Earned Value (LCY)||Shows the result of Budget (LCY) * Job Completion %.|
|Usage (LCY)||Shows the usage total costs in local currency.|
|Cost Variance (LCY)||Shows the result of Earned Value (LCY) - Usage (LCY). This tells you by how much a job deviates from budgeted values because of the percentage of completion.|
|Cost Variance %||Same calculation as for the Cost Variance (LCY) field, the difference being that this field shows the deviation from the budget in percent.|
|Job Completion %||Shows how much work has been completed compared to the total amount of work required to finish the job. The value in this field is determined by comparing the WBS line values entered by the project manager to the job budget.|
|Estimated Total Cost (LCY)||Indicates the total cost of the job if work continues as before. This field is determined by comparing the Usage (LCY) and Job Completion % fields.|
|Posting Progress %||Shows how much of the total budget has been used.|
|Cost Efficiency||Shows the ratio of earned value to usage. A value below 1 indicates a poor result.|
Budget vs. Actual#
Compares job usage to budget figures.
Both the job list and card contain elements of a job cockpit. In some cases, you need to use the Personalize function to unhide these elements.
Except for the color indicators, the cockpit on the job card shows the same fields as the cockpit on the list.
The list cockpit is split into two areas. The indicators are shown directly on the list in the form of columns. Fact boxes that describe the job can be found to the right.
Two list indicators are available to visualize actual usage and profit in percent.
To turn on these indicators, you need to specify in Jobs Setup when you want one of them to go from green to yellow and from yellow to red. This setup will then be used for all jobs.
The symbols you want to show can be imported as a JPG file to the Documents tab on the Company Information page.
The fact boxes provide you with a clear, concise overview of various kinds of project-related information. You can also personalize them to meet your needs. All boxes are available on job cards as well.
Budget/Usage Incl. Commitment#
On the first line below the heading, the job budget is given in local currency. Click this value to see the active WBS.
The remaining values are shown in the form of bars so that you can visually compare job budget and usage, that is, actual usage and commitments.
Budget vs. Actual#
Displays the same values as the previous box but shows them as numbers. Except for Stock Commitment and Remaining Budget, which are determined automatically, you can open the source tables of all lines by clicking the relevant figure.
Broken down by sales, purchase, and job documents, this list shows the number of documents associated with the job. Click a number to view the related documents.
Indicates when the payment plan says you need to send the next invoice. This plan isn’t the same as an advance payment plan, which would show in another box (advance payments are handled by a separate app). Besides a projected invoice date, the plan includes the total price expected for the job.
Provides a visual update on billing. The bar on the left shows—in local currency—the budgeted total price according to the WBS.
The bar in the middle displays the total price invoiced so far and the open job ledger entries. It is the most important bar regarding jobs that are billed based on time and materials. The bar on the right shows what entries remain according to the payment plan. As you can use plans for both fixed-price and time and materials jobs, this bar is relevant in both cases.
Compare budget to actuals for work packages#
To perform a budget-to-actual comparison at the work package level:
- Select a job on the Jobs page.
- Open the active WBS of the job.
- On the ribbon, choose Process > Budget vs. Actual.
On the General FastTab, you can now see the fields of the selected WBS. You cannot change them here. The fields required for comparison can be found on the WBS Line Usage FastTab, near the end of each line. They include fields indicating job progress and those showing the quantities and amounts budgeted and consumed for the job.
Regardless of which WBS version you open, that is, which version is used to fill in the budget figures, the actual values are always the same. This means that you can open any version to compare budget to actuals.
As the Budget vs. Actual page is just another kind of WBS view, only fields that aren’t explained in the WBS portion of this documentation are described in the following.
|Budgeted Quantity||Shows the budgeted quantity totaled from all work packages assigned to the job.|
|Usage Qty. (Base)||Shows the total quantity consumed by a specific work package. The field is related to the Job Ledger Entries page and totals the quantities that are stored there.|
|Time Commitment (Qty.)||Shows the quantities not yet copied from time entries to the job. This means that hours were posted by staff but haven’t been transferred to the job by the project manager.|
|Outstanding Budg. Quantity (Base)||Shows the result of Budgeted Quantity - Usage Qty. (Base) - Time Commitment (Qty.).|
|Budget Value (LCY)||Shows the budget in unit costs.|
|Usage Cost (LCY)||Shows the total quantity consumed by a specific work package. The field is related to the Job Ledger Entries page and totals the unit costs that are stored there.|
|Purchase Commitment (LCY)||Shows the outstanding amount from purchase orders that have been created from a specific WBS line. This field is related to the Purchase Line table and totals the outstanding amounts that are stored there.|
|Time Commitment (LCY)||Shows the amounts not yet copied from time entries to the job. This means that hours were posted by staff but haven’t been transferred to the job by the project manager.|
|Stock Commitment (LCY)||Shows the item quantity that was procured for the job but is still in stock.
This field is only available if you turned on the Job Purchase Incl. Inventory toggle in Jobs Setup.
|Variance (LCY) Incl. Commitment||Shows the result of subtracting the usage cost and the purchase and time commitments from the budget value.|
|Job Completion %||Shows the job progress specified for a work package by the project manager.|
|Posting Progress %||Filled in automatically based on the budget value and the usage cost.|
|Posting Progress % Incl. Commitment||Filled in automatically based on the budget value, the usage cost, and the time and purchase commitments.|
|Line Activity Progress %||Weighted entry based on the progress fields of stored budget lines—or, more specifically, activities—which resources enter in time tracking.
This field is only filled in if resources use both budget lines and the Line Activity Progress % fields to record time.
|Earned Value||Filled in automatically based on the budgeted unit costs and the percentage of job completion.
Shows what value a certain WBS line has achieved in unit costs so far.
|Cost Variance||Filled in automatically based on the earned value and the usage cost.|
|Cost Variance %||Filled in automatically based on the earned value and the usage cost. Shows the cost variance in percent.|
|Estimated Total Cost||Filled in automatically based on actual figures and the percentage of job completion.|
A budget-to-actual comparison offers you an overview of an entire project. It not only shows you all work packages related to a job with their budget and actual figures but also allows you to identify where current results differ from expectations.