Estimate (form)

Article
10/09/2018

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Depending on your version of the program, do one of the following:

In Microsoft Dynamics AX 2012 R2: Click Project management and accounting > Common > Projects > All projects. Double-click a Fixed-price or Investment project. In the Projects form, on the Revenue recognition FastTab, right-click the Estimate project ID field, and then click View details on the shortcut menu. In the Estimate projects form, in the Related information group, click Estimates.
In Microsoft Dynamics AX 2012 Feature Pack or Microsoft Dynamics AX 2012: Click Project management and accounting > Common > Projects > Estimate projects. On the Action Pane, on the Estimate project tab, in the Related information group, click Estimates.

Use this form to modify your estimate settings and process revenue recognition for Fixed-price and Investment projects that are associated with an Estimate project.

Note

For information about the purposes of these two project types, see About project types.

If the revenue recognition rule for a project group is set to percentage completed, a percentage of completion is calculated on the Estimate project when you create estimates at predefined intervals. Based on the percentage completed calculation, the revenue is recognized for the project and a fee transaction is posted to accrue the revenue. The percentage of completion is calculated as the difference between actual consumed hours, items, and expenses and their projected, or forecasted, values.

If the revenue recognition rule is set to completed contract, the revenue is calculated only after the project is 100 percent completed.

Tasks that use this form

About estimate periods

Set up a provision for foreseeable losses

Create an estimate project

Navigating the form

The following tables provide descriptions for the controls in this form.

Tabs

Tab	Description
Overview tab	Enter and maintain estimates.
General tab	View general information about the transaction. You can also view hour rates based on estimated, accumulated, and total amounts. For fixed-price estimate projects, you can view the value-added factor and the markup factor in the PL structure field group. The value-added factor is the value-added amount as a percentage of the revenue. The markup factor is the gross margin as a factor of the total costs. For Fixed-price projects that use the Manual completion method, you can enter the completion percentage on the General tab and view the calculated revenue amount.
Profit and loss	View the amounts that will be posted to profit and loss accounts if the estimate is posted now.
WIP	View the amounts that will be posted to work-in-progress (WIP) accounts if the estimate is posted now.
Consumption	View the estimated and accumulated cost of hours, items, and expenses that were consumed on the estimate.
Hour rate	View the estimated, accumulated, and total hour rate of the estimates for a fixed-price project.
Totals	View information about current, remaining, and total estimates.

Buttons

Button	Description
New	Open the Create estimate form to create an estimate.
Delete	Delete an unposted estimate.
Edit	View or modify the cost lines for an unposted estimate.
Calculate	Calculate the percentage complete for an estimate.
Post	Post an estimate to the project ledger and the general ledger.
Reverse	Reverse a previously posted estimate.
Eliminate	Eliminate an estimate. To eliminate an estimate project, it must be 100 percent completed.
Reverse elimination	Reverse the elimination of a previously eliminated WIP project.
Ledger	Open a menu that contains the following items: Posted – View posted estimate lines. Reverse – View reversed estimate lines.

Fields

Fields	Description
Estimate date	The ending date of the estimate period.
Version	The number of times an estimate was reversed and posted for an estimate period.
Estimate status	The status of the estimate.
Forecast model	The forecast model that is associated with the estimate.
Manual calculation	Enter a number between 0 and 100 for calculating the percentage of completion. Note The value in this field can be modified only if you selected Manual in the Completion method field in the Cost template form.
Hour - quantity	The number of hours that have been posted to profit and loss accounts.
Value-added hour rate	The value-added amount per hour.
Recalculation	If you change the estimate lines, this check box is selected. Click Calculate to recalculate the estimate.
Period code	The period type that is used to determine the estimate periods.
Completion method	The method that is used to determine the percentage completed. The calculation type is defined in the Completion method field in the Cost template form.
Automatic calculation	The percentage of completion that was calculated automatically if the automatic option is selected in the Completion method field in the Cost template form.
Ledger date (Below the Voucher number field)	The date of an estimate posting transaction.
Reversed	The voucher number of the estimation reversal transaction.
Ledger date (Below the Reversed field)	The date on which an estimation reversal is posted.
Eliminate to (Investment projects only)	The setting that determines whether WIP value is transferred to a fixed asset, to a ledger account, or to a new project.
Main account (Investment projects only)	The ledger account that WIP value is transferred to. This field is available only if you select Ledger in the Eliminate to field.
Fixed asset number (Investment projects only)	The fixed asset that WIP value is transferred to. This field is available only if you select Fixed asset in the Eliminate to field.
Value model (Investment projects only)	The value model for the fixed asset to which WIP value is transferred. This field is available only if you select Fixed asset in the Eliminate to field, and after you make a selection in the Fixed asset number field. Note This control is available only if Microsoft Dynamics AX 2012 R2 or AX 2012 R3 is installed.
Project ID (Investment projects only)	The project to which WIP value is transferred. This field is available only if you select Project in the Eliminate to field.
Activity number (Investment projects only)	The activity that WIP value is associated with when it is transferred to a project. This field is available only if you select Project in the Eliminate to field.
Category	The category that WIP value is associated with when it is transferred to a project. This field is available only if you select Project in the Eliminate to field.
Line property	The line property that WIP value is associated with when it is transferred to a project. This field is available only if you select Project in the Eliminate to field.
Quantity	Number of units that are represented in the transaction line.
Revenue (Fixed-price projects only)	The sum of invoiced revenue and accrued revenue that is posted to profit and loss accounts.
Cost - expense	The expense transactions amounts that are debited to the cost account when you post the estimate.
Cost - item	The item transaction amounts that are debited to the cost and item cost accounts when you post the estimate.
Accrued loss	The amount that is debited to the accrued loss account, when foreseeable losses have been enabled and the project is running at a loss. Note Foreseeable losses are set up in the Project groups form and can be enabled only for Fixed-price projects.
Value-added (Fixed-price projects only)	The amount that is debited to the current profit and loss account.
Cost - hour (Fixed-price projects only)	The hour transaction amounts that are debited to the cost account when you post the estimate.
Gross margin (Fixed-price projects only)	The total revenue minus the total cost.
Value-added markup percentage (Fixed-price projects only)	The value-added amount as a percentage of hour costs (Value-added amount*100/hour costs).
Markup percentage	Gross margin as a percentage of total costs (Gross margin*100/total costs).
Invoiced revenue - on-account (Fixed-price projects only)	The on-account revenue that is posted to profit and loss.
Accrued revenue - sales value (Fixed-price projects only)	The accrued revenue that is posted to profit and loss when the sales value model is used.
Accrued revenue - production (Fixed-price projects only)	The cost portion of the revenue that is posted to a profit and loss account when the Production + Profit model is used.
Accrued revenue - profit (Fixed-price projects only)	The profit portion accrued revenue that is posted to profit and loss when the Production + Profit model is used
Accrued revenue - on-account (Fixed-price projects only)	The amount of accrued revenue for on-account transactions that is credited to the associated profit and loss account.
Total accrued revenue (Fixed-price projects only)	The total amount of all accrued revenue that is posted to a profit and loss account when the estimate is posted.
Total cost	The total hour, item, and expense transaction amounts that are debited to the cost, item cost, and accrued loss accounts when you post the estimate.
WIP - cost value - hour	The amount that is debited to the cost value hour account when you post the estimate.
WIP - cost value - expense	The amount that is debited to the cost value expense account when you post the estimate.
WIP - cost value - item	The amount that is debited to the cost value item account when you post the estimate.
WIP - accrued loss	The amount that is debited to the accrued loss account when you post the estimate.
Total WIP cost	The sum of all capitalized costs and accrued costs.
Cost hour rate	The cost amount divided by the number of hours in the Hour - quantity field, which yields an hourly rate.
Consumption	The total amount that has been debited to the cost value accounts from transactions up to the estimate date. This applies to the Hour consumption, Expense consumption, and Item consumption areas.
Capitalized	The total amount of to-date cost value transactions that are debited to the balance sheet. This applies to the Hour consumption, Expense consumption, and Item consumption areas.
Not capitalized	The total amount of to-date cost value transactions that are debited to a profit and loss account. This applies to the Hour consumption, Expense consumption, and Item consumption areas.
Consumption (Total consumption area)	The total amount consumed on hour, expense, and item transactions.
Capitalized (Total consumption area)	The total negative amount of postings to balance accounts.
Not capitalized (Total consumption area)	The total amount that is debited to item accounts from hour, expense, and item transactions.
Revenue hour rate (Fixed-price projects only)	The revenue amount divided by the number of hours in the Hour - quantity field, which yields an hourly rate.
Value-added hour rate (Fixed-price projects only)	The value-added amount divided by the number of hours in the Hour - quantity field, which yields an hourly rate.
Gross margin hour rate (Fixed-price projects only)	The gross margin amount divided by the number of hours in the Hour - quantity field, which yields an hourly rate.
Contract value (Fixed-price projects only)	A report of how much contract revenue has been realized for the year, and how much remains for the year. Actual – The total revenue that has been realized for the project to date. Internal – The amount of revenue for the project that has been contributed by an internal funding source. To complete – The remaining contract value amount that is still available to the project.
Cost	A summary of actual costs and cost to complete. Actual – The actual total costs for the life of the project. The cost value is based on transactions that are entered for all projects that are associated with this estimate project. Internal – Costs that are being retaining internally and that have not been posted. To complete – The remaining costs to complete the project.
Not capitalized (Investment projects only)	The cost amount that is not reflected in the balance sheet.
To be capitalized (Investment projects only)	The total cost on the balance sheet.
Accrued loss (Investment projects only)	The total accrued loss on the balance sheet.