WIP Accounting#
Overview#
The Measurement functionality provides a way for you to calculate and record work in process in the system so that you can estimate the financial value of ongoing projects in the general ledger.
Setup#
For automatic measurements, you need to set up the following features:
- Measurement methods
- G/L integration codes
- Measurement templates
- Resource pricing
Projects Setup#
Field | Description |
---|---|
Balance Filter (Measurement) | Here you can select the G/L integration code that will be shown in measurement summaries after recording WIP or revenue. |
Auto Save Posted Measurements | This toggle is only relevant to batch posting (that is, when you post multiple measurements at the same time). If the toggle is turned on, data is saved after each check of a measurement in the batch so that all (successfully) posted values are retained if an error is encountered. With the toggle turned off, none of the measurements from the posting process will be stored (resulting in a complete rollback) so that all of them must be reposted should an error occur. |
Measurement methods#
Before you can work with the functionality, you need to set up at least one method of measurement. Each requires its own page. To set up a method:
- Choose the Search icon, enter Measurement Methods, and then choose the related link.
- Choose New on the ribbon.
- Fill in the fields as described in the following table.
Field | Description |
---|---|
Code | Specify a code for the method. The code must be unique. |
Description | Specify a description for the method. |
G/L Integration | Select this field if you want measurements based on this method to be copied to Finance. |
Project Posting Group | Select a group in this field if you want to measure project ledger entries. |
Measurement Template | Select this field if you want to use a measurement (that is, calculation) template. The Template option is then automatically chosen in the Measurement Base field. |
Measurement Base | Select a basis for estimating project values. If you select the Measurement Template checkbox, the value in this field is set to Template automatically and cannot be changed. Project Ledger Measures project ledger entries. Completion The system determines how far the project has progressed and uses that percentage for calculations in a measurement template. Template Creates measurements according to custom criteria. |
WIP Method | Select a basis for estimating work in process: • (blank) • None • Costs • Prices • HGB Costs |
Calculate | Specify if the system should use project ledger entries posted for usage or sales, or both, to record WIP. |
Recognition Method | Specify if you want to recognize revenue according to the percentage of completion or the completed contract method. |
Computation Log | Select this field if you want the system to log WIP calculations so that you can track measurement amounts. To see the log, choose the Assist button on an unposted or a posted measurement line. |
You can also add a method to a project template. This method is then entered automatically on each project that you create from the template.
Projects set up without the help of a template require manual intervention. To assign a method manually:
- Choose the Search icon, enter Projects, and then choose the related link.
- On the ribbon, choose Related > Project > Measurement > Measurement Methods.
- Alternatively, choose a project card from the list and proceed as already described.
If you opt for measuring ledger entries, the default method for measurements will be used and a template will not be created. You then also need to specify the relevant measurement accounts through project posting groups.
Project posting groups#
Project posting groups store the accounts to which project sales and costs are posted. To set up a group:
- Choose the Search icon, enter project365 Posting Groups, and then choose the related link.
- Fill in the fields as described in the following table.
Field | Description |
---|---|
Code | Specify a code for the group. The code must be unique. |
Description | Specify a description for the group. |
WIP Costs Account | (Usage) Choose the account to which unit costs are debited when running the Post Project Work In Process to G/L batch job and credited when you Post Project Revenue Recognition (to the general ledger). When you post WIP, the Project Costs Adjmt. Account found in General Posting Setup is used as the balancing account to this account. For revenue recognition, that function is assumed by the Project Costs Account. |
WIP Sales Account | (Sale) Choose the account to which unit prices are credited when you Post Project Work In Process to G/L and debited when running the Post Project Revenue Recognition to G/L batch job. When you post WIP, the Project Sales Adjmt. Account found in General Posting Setup is used as the balancing account to this account. For revenue recognition, that function is assumed by the Project Sales Account. |
Project Costs Account | (Usage) Choose the income account to which unit costs are debited when you run the Post Project Revenue Recognition to G/L batch job. |
Project Sales Account | (Sale) Choose the P&L account to which unit prices are credited when you Post Project Revenue Recognition (to the general ledger). |
G/L Expense Account | Fill in this field if you intend to post to a project-related G/L account. Amounts are then credited to this account when project usage is copied to sales lines. |
WIP Profit Account | Choose an account for storing prorated profits, as specified by the IAS percentage of completion (POC) method. This account is only required when you measure project completion. |
WIP Profit Applied Account | Choose the contra account to the WIP Profit Account. This account is only required when you measure project completion. |
Note
If you estimate the financial value of a project based on a measurement template, the accounts you post values to Finance with aren’t copied from a project posting group. Instead, the system will use those specified through G/L integration codes.
G/L integration codes#
These codes are assigned in measurement templates to line amounts that are posted to Finance. They specify the debit and credit accounts you want to use to record WIP and recognize revenue.
You need to set up a unique code for each measurement method and area you want to cover (by creating one for use with reservations and another to record partially finished work as per HGB or IFRS standards, for example).
Afterward, the codes need to be manually assigned to the template lines (see Measurement Templates).
To set up a code:
- Choose the Search icon, enter G/L integration Codes, and then choose the related link.
- Fill in the fields as described in the following table.
Field | Description |
---|---|
Code | Specify a code for G/L integration. The code must be unique. |
Description | Specify a description for the code. |
Integration Type | Select an integration type if you need access to measurement entries posted for a certain project. Example Measurements according to HGB require a calculation of the balance sheet values that you posted the previous year. The following options are available in this field: • (blank) • Balance Sheet • Cost of Materials • Labor Costs • Advance Pmt. (Assets) • Advance Pmt. (Liabilities) • POC • POC Project (Assets) • POC Project (Liabilities) • IFRS Prepmt. |
Debit Account (WIP) | Specify the account to which you want to add the debit amount stored for a certain measurement entry when work in process is posted. |
Credit Account (WIP) | Specify the account to which you want to add the credit amount stored for a certain measurement entry when work in process is posted. |
Debit Account (Recog.) | Specify the account to which you want to add the debit amount stored for a certain measurement entry when revenue recognition is posted. |
Credit Account (Recog.) | Specify the account to which you want to add the credit amount stored for a certain measurement entry when revenue recognition is posted. |
Measure After Final Invoice | Select this field if you want to continue creating measurements for projects that have been settled in full. The integration code is then used to identify the lines to be measured after the entire project has been billed. Suggestions for recognizing revenue, on the other hand, show only entries that this field is not selected for. |
Measurement templates#
Note
You need a valid license to work with measurement templates.
You need to set up a template for each method of measurement that you want to use. Examples are measurement methods based on IFRS or HGB.
- Choose the Search icon, enter Measurement Templates, and then choose the related link.
- Fill in the fields on the lines as described in the following table.
Field | Description |
---|---|
Row No. | Specify a code for the template, such as R10. The code must be unique. The value in this field can later be used to gain access to the Totaling or Argument and Condition fields. Note If you want to work with G/L integration, entering a code is mandatory. |
Description | Specify a description for the measurement line. |
Cost Line | Select this field if you want the system to retrieve only the remaining cost or project ledger entries that contain cost amounts from the source table specified on the line (see Source Table field). |
Auto Calculate | Select this field if you want the line calculated automatically based on tables that contain entries relevant to the project. |
Source Table | Specify based on which table data the line amount will be calculated. The following options can be chosen: • G/L Entry • Project Ledger Entry • Project Account Entry • Measurement Template • Order Amount • Measurement Entry • Remaining Cost • Completion • Advance Pmt. • Advance Invoices Note The Advance Pmt. and Advance Invoices options are only available if you also installed the Advance Payment app. Afterward, you can use the Totaling field to filter data even further. |
Use Unit Costs | Select this field if you want to use the unit costs regardless of whether you chose HGB Costs as the overall basis for measurement. |
Advance Amt. Type | Specify if you want Advance Pmt. or Advance Invoices entries (see Source Table field) to be shown as gross or net amounts. For all other source tables, this field is left blank. |
Totaling Type | Specify the source of measurement totals: • Account (for G/L, project ledger, or project account entries) • Formula • If • Total Accounts (for G/L, project ledger, or project account entries) |
Totaling | Fill in this field based on the option you selected in the previous field. For project ledger or project account entries Specify a project account number or a total account number. For measurement entries Specify a G/L integration code. For measurement templates Specify a row number. For G/L entries Specify a G/L account number or a total account number. For totaling type Formula Specify a row number and a mathematical operator. Leave the field blank if you chose another option than those listed. |
Argument 1 Condition Argument 2 Argument 3 Argument 4 |
For the If totaling type, you need to fill in these fields according to the following rules: If Argument 1 Condition Argument 2, then Argument 3; else, Argument 4. Note Arguments can only contain row numbers and mathematical operators or numbers. Options in Condition fields: • (blank) • < • > • = • <= • >= For all other totaling types, the field is left blank. |
Date Filter Calculation | If table values are posted to a project automatically, you might need to set one of the following options as a date filter: • Previous Year • Year to Date • Current Period • Balance at Date Otherwise, leave the field blank. |
Show | Select this field if you want the line printed on gross profit and loss reports. |
G/L Integration Code | Fill in this field if you want to create a project measurement entry. This code is then copied to the account that is specified on the line when posting values to Finance. Note You must fill in the Row No. field on the line if you want to add a G/L integration code. |
Print Description | Select this field if you want its value printed as a heading on a gross profit and loss report. If the field is left blank, the default description will be used. |
Individual measurement values#
Additionally, you can specify up to 10 values that will be shown on the Project Measurements and Posted Project Measurements pages in accordance with certain measurement methods.
Each value will be displayed in a separate column on the page (but as a line, or row, on the individual finance report, hence the name chosen for the feature).
- Choose the Search icon, enter Project Measurement Method Row Setup, and then choose the related link.
- On each FastTab, fill in the fields as described in the following table.
Field | Description |
---|---|
Measurement Method Code | Specify the measurement method that the value will relate to. |
Source Value | Specify the value that will be shown. Options are: • Amount • Measurement Amount • Measurement Base • Posted Until Prev. Period |
Description | Enter a description for the column header as it should appear on the Project Measurements page. |
Row No. | Select a row number based on the measurement method that you entered. |
Resource prices#
Besides standard unit costs, you can calculate direct unit costs on resource cards. The calculation is based on the following formula:
- Personnel Cost Rate + Personnel Cost % + Personnel Ovhd. Cost = Direct Unit Cost
- Direct Unit Cost + Indirect Cost % = Unit Cost
Both the unit cost and the direct unit cost can be used to estimate the financial value of a project.
You can also choose the Update Personnel Ovhd. Cost function to recalculate the unit cost and the direct unit cost of several resources at once.
The new overhead is entered on the Options FastTab. You can set filters on the Resource tab if you want to update only certain resource records.
Create and post template-based measurements#
One way for you to estimate the financial value of a project is to use a template that contains rules specific to a certain accounting standard.
For more information, see Measurement Templates.
Note
You need a valid license to work with measurement templates.
Create a measurement#
To create measurements from a template, open the Project Measurements page and choose Actions > Create Measurements on the ribbon.
On the request page, on the Project Measurement Method FastTab, you can then specify the projects you want to estimate financial values for. You also need to select a month (such as 01/01/25 for January 2025) on the Options tab.
Note
Turning on the Post toggle on the Options tab immediately posts the measurements as new entries in the project area (but not in Finance). Don’t activate the toggle if you want to check some of the measurements before posting.
Turn on the From Data Transfer toggle if you want to block the values that are calculated (or calculated and posted) from being posted to Finance. This way, you avoid creating duplicate entries when, for example, you only want to enter the status of the measurements into the system but have already added them to the ledger alongside other account values during a data migration.
Review and post a measurement#
To see a measurement that you’ve created before posting:
- Choose the Search icon, enter Projects, and then choose the related link.
- Open a project card and choose Related > Project > Measurement > Project Measurements.
- Alternatively, choose the Search icon, enter Project Measurements, and then choose the related link.
You can then see all values measured based on each method specified in the system. For measurements calculated with the help of a formula, you can use the Show Computation Log function on the Lines FastTab ribbon to view both the formula and the subtotals. If needed, you can also delete and recreate any measurement that hasn’t been posted yet (Actions > Delete Measurements).
After reviewing the measurements, choose Post on the ribbon. This creates the entries required for posting values to Finance.
To post multiple measurements at once, use the Post Measurements action on the Project Measurements ribbon. You can set a filter on the request page to limit what measurements to include.
View a posted measurement#
To see a measurement that you’ve posted:
- Choose the Search icon, enter Projects, and then choose the related link.
- Open a project card and choose Related > Project > Measurement > Posted Project Measurements.
- Alternatively, choose the Search icon, enter Posted Project Measurements, and then choose the related link.
Afterward, you can view the entries created for the measurement by choosing Related > Posted Project Meas. > Measurement Entries on the ribbon.
The G/L Integration field there shows the postings that are created in Finance via the Post Project Work In Process to G/L batch job, with the Measurement Amount field showing the amount to be posted (and the Posted Measurement Amount field being filled in after the batch job is run).
For a value calculated based on a formula, you can run the Show Computation Log action from the Lines FastTab ribbon to see both the formula and the subtotals.
Post WIP#
For posting to Finance, you must use the Post Project Work In Process to G/L batch job (available via the general search function).
On the request page, on the Project FastTab, you can then set filters to limit the projects on which you want to run the function.
On the Project Measurement Entry tab, on the other hand, you can filter for a measurement method and a posting period. If you want to post IFRS and HGB measurements separately, you must also specify a suitable filter in the Meas. Method Code field on the tab. The filter in the Posting Date field should be set to the end of the relevant month, for example 1/31/2025.
On the Options tab, you can choose if you want to post measurements per entry or per project. Please be aware that the Project option might result in totals being copied to Finance.
Afterward, fill in a posting date, a document number, and a posting description (where %1 will be replaced with measurement type WIP and %2 with the posting group, such as IFRS or HGB).
The Post toggle on the page specifies whether entries are posted, previewed, and printed. Leaving it turned off will only display and print the report without posting the entries.
You can then select the Preview button to check what you posted to Finance.
Note
With the Post toggle turned on, the standard Preview function isn’t really a preview either, as it is used to start posting to Finance.
To see the values posted to G/L Integration accounts in Finance, go to the G/L Integration page and select an entry to open the journal you last posted to. For more information on posting-related accounts and records, see Measurement Templates.
If you filtered for a measurement method on the Project Measurement Entry FastTab, you need to rerun the Post Project Work In Process to G/L batch job for each new method.
Close a project#
To post revenue to Finance, the status of the project must be set to Closed. Alternatively, you can turn on the Final Invoice Created toggle on the project card.
Note
You can no longer post to completed projects, but you can post to projects that final invoices were created for. However, you should only post to them if necessary, such as when you need to settle warranty claims or perform rework, as these projects are then excluded from subsequent measurements. In other words, once a project is set to Completed or Final Invoice Created, it will no longer be part of new measurements used for calculating WIP.
Suggest measurements for revenue recognition#
Completed projects or those that final invoices have been created for need to have their revenues recognized on the Project Measurement Journals page in advance. You can use the Recognize Revenue function on the page ribbon for this.
On the request page, on the Project FastTab, you can set filters to specify the projects that you want to recognize revenue for.
On the Project Measurement Method tab, you can set a filter on a method if you want to provide separate suggestions for measurements based on IFRS and HGB, for example.
On the Project Measurement Entry tab, you can specify filters to suggest only certain WIP entries for recognition.
On the Options tab, you need to enter a posting date, a document number, and a description (where %1 will be replaced with the posting date).
When you choose OK, the function then suggests for recognition all entries created from WIP measurements.
Posting the journal doesn’t lead to postings in Finance, as the process creates only project measurement entries for recognizing revenues. To see the entries for a project, choose Posted Project Measurements or Measurement Methods on the project card.
Post revenue recognition#
Afterward, you must copy the measurement entries that you want to recognize to Finance by running the Post Project Revenue Recognition to G/L batch job.
On the request page, on the Project FastTab, you can set filters to specify the projects that you want to recognize revenues for.
On the Project Measurement Method tab, you can set a filter on a method if you want to provide separate suggestions for measurements based on IFRS and HGB, for example.
On the Project Measurement Entry tab, you can specify filters to suggest only certain WIP entries for recognition.
On the Options tab, you can choose if you want to post measurements per entry or per project. Please be aware that the Project option might result in totals being copied to Finance.
Afterward, fill in a posting date, a document number, and a posting description (where %1 will be replaced with measurement type Recognition and %2 with the posting group, such as IFRS or HGB).
The Post toggle on the page specifies whether entries are posted, previewed, and printed. Leaving it turned off will only display and print the report without posting the entries.
You can then select the Preview button to check what you posted to Finance.
Note
With the Post toggle turned on, the standard Preview function isn’t really a preview either, as it is used to start posting to Finance.
To see the values posted to G/L Integration accounts in Finance, go to the G/L Integration page and select an entry to open the journal you last posted to. For more information on posting-related accounts and records, see Measurement Templates.
Correct posted measurements#
Posted project measurements can be reversed.
Reverse a posted measurement#
To reverse a measurement:
- Choose the Search icon, enter Project Measurements, and then choose the related link.
- Choose Actions > Reverse Posted Measurements on the ribbon.
- Alternatively, choose the Search icon, enter Reverse Posted Measurements, and choose the related link.
We strongly recommend that you set a filter to specify exactly which posted measurements you want to reverse.
Example
To correct HGB measurements from February 2025, you need to set at least the following filters:
Meas. Method Code | HGB |
Posting Period | 2/1/2025 |
When you choose OK, the function deletes all selected measurements (their headers and lines) and sets the measured amounts on the previously posted entries to 0.
Additionally, the Corrected Amount field is filled in with the amount that was posted to the relevant entry up to that point.
Reverse posted measurements in Finance#
The corrected entries must now be recopied to financial accounting to record the difference between the measured and posted amount in the ledger.
As the amounts were set to 0 in the project area, those previously transferred to Finance are then corrected through reversal postings. To reverse a posting, you need to rerun the Post Work In Process to G/L batch job (see action Post WIP).
Example
To post a correction regarding the HGB value measured in February 2025, you must set at least the following filters on the measurement entries:
Meas. Method Code | HGB |
Posting Period | 2/1/2025..2/28/2025 |
Note
The filters should be the same as for reversing posted measurements in the project area; the fact that entries have the same document number or posting description in both instances might be a clue as to why the measurement was removed.
Recreate measurements#
Measurements you’ve reversed can always be recreated, reposted, and then recopied to Finance.
Post ledger entry measurements#
Usage and sales postings aren’t automatically transferred to Finance. They’re only copied when you run one of the following batch jobs:
- Post Project Work In Process to G/L
- Post Project Revenue Recognition to G/L
Both batch jobs are available via the general search function or after opening the Project Measurements page and choosing Actions on the ribbon.
The first batch job adds WIP inventory to the balance sheet (to reflect the cost of materials, labor, and other expenses spent on unfinished projects). For your financial statements to be accurate, it must be run at the end of an accounting period if at least one of your projects is still ongoing.
Depending on the recognition method used, the second needs to be run when a project is partially or fully completed. This batch job then copies the entries for revenue recognition to the G/L accounts recording project sales and costs (to offset the amounts that were posted to work-in-process accounts).
Measure project ledger values#
Project ledger entries are often used to estimate project values in accordance with the German commercial code, better known as HGB. Typically, that means calculating WIP based on unit costs and recognizing revenue at project completion.
Calculate WIP by ledger entry#
To work with this method, open the relevant project measurement journal and run the Measurement Suggestion function from the ribbon.
On the request page, on the Project FastTab, you can then fill in the No. field to limit the number of projects that the function should consider. Leaving the field blank means WIP will be calculated for all measured projects.
On the Project Measurement Method tab, in the Meas. Method Code field, you can filter for a certain method of measurement. If you leave the field blank, all methods will be included in the calculation.
On the Options tab, in the Measurement From and Measurement To fields, you need to specify in which period the ledger entries must have been posted. You also need to enter a posting date, a document number, and a posting description on the tab.
Note
Placeholder %1 is available in both the Document No. and Posting Description fields. It is later replaced with the posting date.
Afterward, choose OK to add the new suggestion to the measurement journal.
When a journal is filled in this way, you usually don’t need to make subsequent changes to journal data. But if the information that was entered by the system is incorrect, you can manually delete any impacted line and rerun the function.
An example of WIP measurement based on project ledger entries can be seen in the following table.
Field | Description |
---|---|
Code | HGB-L |
Description | HGB (Ledger Entries) |
G/L Integration | Selected |
Measurement Template | Not Selected |
Measurement Base | Project Ledger |
WIP Method | Costs |
Calculate | Usage |
Recognition Method | Completed Contract |
Here, the system measures project ledger entries of type Usage at unit costs and, if needed, copies the values to financial accounting.
This method ensures that only usage entries are copied to the journal. Ledger entries of type Sale, on the other hand, are not.
The amount that is being measured is retrieved from the Unit Cost field of the relevant ledger entry, whereas the unit price stored with the entry serves only informational purposes in this context.
Posting work in progress then creates measurement entries that you can see when you open the relevant project, as each measurement entry is linked to a measured ledger entry via the Project Ledger Entry No. field. The latter entry also stores the WIP amount.
To see the measurement status of a project, open its project card and choose Related > Project > Measurement > Measurements Overview. The entries that you’ve posted are then visible in the WIP column during the selected posting period. You can use the lookup in each field to view more information about an entry.
Incorrect measurement base
Remeasurements are possible if, for example, the wrong measurement base was chosen. However, only project ledger entries that weren’t included in the previous measurement will be considered by the system. The method you’ve used must also be changed accordingly and reassigned to the project.
Post WIP to Finance#
The measurement entries that were created through the measurement journal in the Project area can now be copied to Finance by running another batch job.
For this purpose, the G/L Integration checkbox must have been selected on all journal entries that you want to copy.
Their values can then be transferred to Finance by entering Post Project Work In Process to G/L in the search field and choosing the relevant link. Individual projects can be selected for inclusion in the batch job on the Project FastTab, although you can also set filters on other fields of the project table.
On the Project Measurement Entry FastTab, we recommend that you limit only the period for inclusion, as the measurement entries themselves have already been filtered via the journal.
On the Options tab, select what method you want to use for posting. You can create one general ledger entry for each measurement entry or one for all of them. You also need to enter a posting date (to specify for which period you want entries copied to Finance), as well as a document number and a posting description.
You can then turn on the Post toggle if you want the WIP values to be posted, or leave it turned off if you merely want to preview the WIP calculation.
Afterward, choose Print or Preview to see a report listing all work in progress.
When posting work in progress, the system updates the Posting Date field for the relevant measurement method and adds up the new measurement entries in the Posted Measurement Amount field.
The individual records are also posted to financial accounting. As the method selected was Per Project Meas. Entry, a great many records will be posted.
To see the WIP postings you’ve made, open the relevant project card and, on the ribbon, choose Related > Project > Measurement > Measurements Overview. The WIP field for a certain entry should then show the same amount as in the WIP Posted field during the specified month.
The process is mostly the same when measuring project completion. The only difference is that you need to determine completion values for the accounting period prior to having the system suggest measurements on the journal page.
Posting to Finance also works as it does when you’re measuring ledger entries (despite completely different account assignments).
Recognize revenue by project ledger entry#
For revenues, it is important to know when they need to be recognized, that is, whether based on project progress or at completion of contract.
If you use the Completed Contract method, the status of the project must be Completed. You can then run the Recognize Revenue function from the ribbon of the measurement journal.
On the request page, on the Options FastTab, specify the date when revenues should be recognized. Additionally, enter a posting date, a document number, and a posting description.
On the Project tab, you can filter for specific projects or, by leaving the No. field blank, run the function on all projects.
On the Project Measurement Method tab, you can set a filter on the methods used for measurement (or, as before, leave the field blank to run the function on all methods).
On the Project Measurement Entries tab, on the other hand, you can filter for the measurement entries that have been posted. In the Entry Type field, you can select either Usage or Sale. Leaving the field blank means all entries will be considered for revenue recognition.
As was done when posting WIP, the entries in the measurement journal must now be posted so that they’re visible on the Measurements Overview page, in the Recognition column.
Post revenue recognition to Finance#
Following recognition in the Project area, the entries must still be posted to Finance. For this purpose, run the Post Project Revenue Recognition to G/L action (available via the general search function).
On the request page, on the Project FastTab, you can limit revenue recognition to specific projects. On the Project Measurement Method tab, you can specify the method you want to recognize revenue for.
On the Project Measurement Entry tab, you can filter for measurement entries so that only certain entries are recognized in financial accounting.
On the Options tab, you can specify whether you want a G/L entry created for each measurement entry or if you want to aggregate the entries into one G/L entry in Finance. You also need to fill in the Posting Date, Document No., and Posting Description fields on the tab.
With the Post toggle turned on, the revenues will already be posted to financial accounting. Leaving the toggle turned off will generate only a test report.
As was the case when you’ve posted WIP, you can then choose OK to transfer the general ledger entries to Finance.
Post progress measurements#
Measuring project progress is largely identical to measuring a project’s ledger entries. For this reason, the following sections will explain only the differences between both methods.
Calculate project completion#
Project progress is calculated by choosing Related > Project > Measurement > Completion on the project card ribbon. You then use the Estimate Completion function on the page that opens to create completion lines.
Calculate WIP based on completion#
You first need to set up a suitable method for measurement. In this context, selecting Completion in the Measurement Base field is essential.
As was the case when measuring project ledger entries, you then run the Measurement Suggestion function on the Project Measurement Journals page. Note the filter on the Posting Date field, as the focus has shifted to completion values.
All subsequent steps (posting the measurement as a project measurement entry and posting this entry to Finance [if the relevant journal gives you the option of doing so], recognizing the entry and posting recognition to financial accounting) are the same as for ledger entry-based measurement.
Analyze measurements#
The measurement functionality also provides you with options for analyzing the data relevant to determining a project’s current financial value.
Default Gross Profit and Loss#
This report shows you the lines and values related to a posted measurement (for example, based on IFRS or HGB and a specific month).
A line is only included on the report if the Show checkbox is selected for it in the measurement template.
On the request page, on the Project Dim. Value Report Buffer FastTab, specify the dimension by which projects on the report will be grouped. Afterward, you can fill in the Dimension Value field (for example, with range 30) to show only projects to which the value is assigned as a default dimension. You can also limit what projects you see by filling in the No. field.
On the Options FastTab, enter a date so that you see only measurements valid in the specified month. In the Meas. Method Code field, select the code of the measurement method that you want included on printouts.
Additionally, with the Preview toggle turned on, the report will show all posted measurements and those created but not yet posted.