How to: Create Capital Work in Process Transactions for Purchase Documents
You can create Capital Work in Process (CWIP) transactions for a purchase order or purchase invoice using the following procedures:
Post a purchase order or a purchase invoice.
Calculate and post the Work in Process (WIP) to the general ledger.
Capitalize the WIP.
Note
You must set up CWIP before you create CWIP transactions. For more information, see How to: Set Up Capital Work in Process.
The following procedure describes how to post a purchase order, but the same steps also apply to posting a purchase invoice.
To post capital work in process for a purchase order
In the Search box, enter Purchase Orders, and then choose the related link.
Select the required purchase order that you want to post, and on the Home tab, in the Manage group, choose Edit.
On the General FastTab, fill in the required fields as described in the following table.
Field Description Buy-from Vendor No.
The number of the vendor from whom the items are purchased.
Posting Date
The posting date of the purchase order.
Vendor Invoice No.
The vendor invoice number.
On the Lines FastTab, fill in the required fields as described in the following table.
Field Description Type
Specify the line type.
No.
The item or general ledger account number depending on what you have selected in the Type field.
Location Code
The code for the location of the items.
Quantity
The number of units of the item that are specified on the purchase document line.
Direct Unit Cost Excl. VAT
The direct unit cost of the item, excluding VAT, on the purchase document line.
Job No.
The job number on the purchase document line.
Job Task No.
The job task number for the purchase document. You must enter a job number in the Job No. field before you enter a job task number in this field.
Job Line Type
Select Schedule as the job line type.
CWIP G/L Type
The CWIP general ledger type.
Tip
If the column is not visible, open the shortcut menu for the column headings, and then choose Choose Columns to add it.
On the Actions tab, in the Posting group, choose Post.
In the dialog box, select one of the following options:
Receive
Invoice
Receive and Invoice
Choose the OK button.
To calculate and post the capital work in process to the general ledger
In the Search box, enter Jobs, and then choose the related link.
Select the required job for which you want to calculate the WIP, and on the Home tab, in the Manage group, choose Edit.
To calculate the WIP, on the Navigate tab, in the WIP group, choose Calculate WIP.
On the Options FastTab, fill in the required fields as described in the following table.
Field Description Posting Date
The date on which the WIP is calculated and posted.
Document No.
The document number.
On the Job FastTab, select the appropriate filters.
Choose the OK button.
To post WIP to the general ledger using the Job Post WIP to G/L batch job, on the Navigate tab, in the WIP group, choose Post WIP to G/L.
On the Options FastTab, fill in the required fields as described in the following table.
Field Description Reversal Posting Date
The date on which the posted general ledger entries are reversed.
Reversal Document No.
The document number for the posted reverse general ledger entries.
Reverse Only
Select to reverse the previously posted WIP.
Use Reversal Date
Select to use the reversal date as the posting date for both the reversal of the previous WIP calculation and the posting date for the new WIP calculation.
On the Job FastTab, select the appropriate filters.
Choose the OK button.
To capitalize the work in process
In the Search box, enter Capitalize CWIP, and then choose the related link.
On the Home tab, choose New.
In the Capitalize CWIP window, on the General FastTab, fill in the required fields as described in the following table.
Field Description No.
The capitalize CWIP form header number.
Job No.
The job number against which the CWIP amount is capitalized for the fixed asset.
Posting Date
The date on which capitalization is performed.
Depreciation Book
The depreciation book for which fixed assets will be created. You cannot select the depreciation book if the fixed asset book type is INCOME TAX.
On the Actions tab, in the Functions group, choose Get Task Lines.
On the Job Task FastTab, select the appropriate filters.
To generate the CWIP line details on the Capitalize CWIP Subform FastTab, choose OK.
On the Capitalize CWIP Subform FastTab, fill in the required fields as described in the following table.
Field Description % to Capitalize (Labor)
The labor percentage to capitalize for the fixed assets.
Amt to Capitalize (Labor)
The amount of labor to capitalize for the fixed assets.
% to Capitalize (Material)
The material percentage to capitalize for the fixed assets.
Amt to Capitalize (Material)
The amount of labor to capitalize for the fixed assets.
% to Capitalize (Overhead)
The overhead percentage to capitalize for the fixed assets.
Amt to Capitalize (Overhead)
The amount of overhead to capitalize for the fixed assets.
On the Actions tab, in the Functions group, choose Fixed Asset Details.
In the CWIP Fixed Asset Details window, fill in the required fields as described in the following table.
Field Description FA Code
The fixed asset code for which capitalization is performed.
Total Amt Allocated(Labor)
The total labor amount allocated for the fixed asset.
Total Amt Allocated(Material)
The total material amount allocated for the fixed asset.
Total Amt Allocated(Overheads)
The total overhead amount allocated for the fixed asset.
Depr. until FA Posting Date
Select to calculate the depreciation for the created fixed asset.
Choose the OK button.
See Also
Tasks
How to: Set Up Capital Work in Process
Concepts
Capital Work in Process Overview
Other Resources
Posting Purchase Orders
Posting Purchase Invoices
Calculating Work in Process and Recognition
Posting Work in Process and Recognition