Export (0) Print
Expand All

Estimate (form) [AX 2012]

Updated: October 12, 2012

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.

NoteNote

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.

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

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.

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

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.

NoteNote

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.

NoteNote

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.

NoteNote

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.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft