About work in process (WIP) calculation [AX 2012]
Updated: August 6, 2014
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Do you use Project management and accounting in Microsoft Dynamics AX? We’d like to hear from you! Your survey invitation is here: http://go.microsoft.com/fwlink/?LinkId=506702
A work in process (WIP) amount is the total accumulated costs or revenue on a project that is still in progress. Depending on the project group, actual project costs and revenue for hours, expenses, and items can be posted to a WIP financial account on the balance sheet. When you invoice a customer for a project or close an internal project, the accumulated costs for the project are reversed from the WIP account.
On external projects, calculating a WIP amount ensures that the costs and revenue that are recorded for projects are recognized and posted on the profit and loss statement in the same accounting period.
On internal Investment projects, a WIP amount is calculated in anticipation of costs being capitalized on balance sheet accounts when the project is completed.
You can calculate WIP values based on cost value or sales value. The method that you use depends on the project type. The following table provides details about each method.
WIP - cost value
Actual costs for hours, expenses, and items are posted to a financial account on the balance sheet. When costs on a project are invoiced to the project customer or an internal project is completed, the costs and associated revenue are posted to profit and loss accounts.
This option is available for all project types.
WIP - sales value
When actual costs are posted to a project, the costs are accrued as revenue. This is done by crediting a revenue account on the profit and loss statement and debiting a WIP - sales value account.
This option is available only for Fixed-price projects and Time and material projects.
The following sections explain how to apply WIP amounts to different project types.
For both Time and material projects and Fixed-price projects, WIP amounts are calculated periodically by using batch jobs or when projects are invoiced, depending on the ledger settings that you select in the Project groups form.
For Time and material projects, the WIP amounts are posted to an invoice. For Fixed-price projects, they are posted to an estimate.
For internal projects, the WIP amount is calculated periodically by using batch jobs or journal entries, depending on the ledger settings that you select for the project group. The WIP amount that is posted is only calculated at the actual cost price. The posting activity is the same as when calculating WIP amounts for Time and material projects.
For Investment projects, the WIP amount is posted by using the estimate system in Project management and accounting. WIP amounts can only be calculated at the cost price. Revenue is accrued during the project to match actual costs on the profit and loss statement, and the estimated WIP amount is calculated as a percentage of the sales price.
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).