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 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 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 project ledger measurements#
Postings for project usage and sales aren’t automatically transferred to Finance but are only copied when you run the relevant batch job.
When posting measurement entries, a distinction is made between posting WIP and recognizing revenue. A project is linked to financial accounting, for example, to compare inventory consumption, salaries, and other amounts with work in process. At the end of the period, the value of ongoing projects must be reported on a balance sheet for accounting purposes. A batch job is available for both WIP and revenue recognition.
When a project is (partially) completed, work in progress needs to be recognized as revenue. Revenue recognition entries offset the amounts posted to work in process accounts and copy them to the G/L accounts that store project sales and costs.
Measure project ledger entries#
Project ledger entries are often the basis for HGB-compliant measurements. Based on unit costs, this measurement method recognizes revenue at the end of a project.
Calculate WIP by project ledger entry#
To use this method, you first need to open the relevant project ledger entries on the project measurement journal and create measurement entries. You then need to copy and post these entries to Finance.
When you run the Measurement Suggestion function from the measurement journal to open the Project WIP Worksheet, you can enter individual projects to be considered by the batch job in the No. field on the Project FastTab. If you leave the field blank, WIP will be calculated for all measured projects.
You can then specify the method for measuring WIP on this worksheet in the Meas. Method code field on the Project Measurement Method tab. If the field is left blank, all methods are included in the calculation.
On the Options tab, the Measurement From and Measurement To fields can be used to enter a period during which entries need to have been posted to be considered for WIP measurement. You also need to enter a posting date, a document number, and a posting description on this tab.
Note
Placeholder %1 can be used in both the Document No. and Posting Description. It is later replaced with the posting date.
Choose OK to enter the measurement suggestion in the project measurement journal.
If a journal is filled in through this batch job, you typically don’t need to make manual changes to the data. But if the information entered for the batch job is incorrect, you can manually delete lines from the journal and rerun the function.
An example of what a measurement method for posting WIP based on project ledger entries might look like 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 |
This method is used to measure project ledger entries of the usage type at unit costs. If necessary, the values are copied to financial accounting.
The method ensures that only usage entries are copied to the journal. Ledger entries of type Sale aren’t considered in this context. The measured amount will be retrieved from the Unit Cost field of a project ledger entry. The unit price serves only informational purposes here.
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 the measured project ledger entry through the Project Ledger Entry No. field. The project ledger entry also stores the WIP amount.
On the project card, you can choose Related > Project > Measurement > Project Measurement to open a matrix that shows you the measurement status of the project. The posted entries are visible in the WIP column during the selected posting period. You can use the lookup in each field to take a closer look at an entry.
Incorrect measurement base
You can perform a second measurement if a wrong measurement base was chosen. However, only project ledger entries not included in the previous measurement are used for this. The measurement method that you used must also be changed accordingly and reassigned to the project. Canceling posted measurements isn’t possible.
Post WIP to Finance#
The measurement entries that were created through the measurement journal, which only affected the Project area, can now be copied to Finance by using a batch job. In this context, it is important that the G/L Integration checkbox (specifying the method and area of measurement) has been selected for all entries you want to copy.
The values are then transferred to Finance by entering Post Project Work In Process to G/L in the general search field and choosing the relevant link. Individual projects can be selected for inclusion in the batch job on the Project FastTab. You can also set filters on other fields of the project table here.
On the Project Measurement Entry FastTab, you can set filters on individual entries. We recommend that you limit only the period for inclusion here, as the entries are already filtered through the journal.
On the Options tab, you select the method that you want to use for posting. You can create a G/L entry for each measurement entry here or one G/L entry for all of them. You also need to enter a posting date to specify when entries should be transferred to Finance, a document number, and a posting description.
The Post toggle is used to determine if you want to preview WIP calculation (toggle turned off) or whether the posting should already be made.
Afterward, choose Print or Preview at the bottom of the page to start the posting or preview process. This will show you a report listing the work in progress.
After WIP has been posted to Finance, you can open a project card and choose Project > Related > History > Measurement Entries on the ribbon to see the postings. When you post work in progress, the system will update the Posting Date field for the relevant measurement method. The project measurement entries included with the posting are updated in the Posted Measurement Amount field.
In the Finance area, the individual records have been posted as well. As the posting method selected for Post Project Work In Process to G/L was Per Project Meas. Entry, the system posted a great many records.
The posting process is identical when you measure project completion. You only need to first calculate completion values for the period under consideration so that they’re included when you run the measurement suggestion from the journal page.
Posting to Finance also works in the same way despite completely different account assignments.
Recognize revenue by project ledger entry#
For revenue recognition, it is important when revenue is recognized, that is, whether it is recognized based on the percentage of work completed or at completion of the contract. If you use the Completed Contract method, the status of the project must be set to Completed. You can then run the Recognize Revenue from the measurement journal.
The date of revenue recognition is specified on the Options FastTab. You also need to enter posting date, a document number, and a posting description there. On the Project tab, you can filter for specific projects or, if you leave the Project No. field blank, use the function on all projects.
On the Project Measurement Method tab, you can set a filter on measuring methods or, as before, leave the field blank to include all methods.
The Project Measurement Entries tab, on the other hand, can be used to filter for certain posted project measurement entries. In the Entry Type field, you can select either Usage or Sale. If the field is left blank, all entries are considered for revenue recognition.
As was done when posting WIP, the project measurement journal must now be posted. The recognized project ledger entries can then be found in the project measurement matrix in the Recognition column.
Post revenue recognition to Finance#
Following revenue recognition in the Project area, the entries still need to be posted to Finance. For this purpose, you can choose the Post Project Recognition to G/L action.
If necessary, you can limit recognition to specific projects on the Project FastTab. On the Project Measurement Method tab, you can specify for which method you want to recognize revenue.
On the Project Measurement Entry tab, you can select the measurement entries that you want to transfer to Finance for revenue recognition.
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 measurement entries into one G/L entry in Finance. Additionally, you need to fill in the Posting Date, Document No., and Posting Description fields on the tab.
With the Post toggle turned on, revenues are then posted to Finance. Leaving the toggle turned off will generate only a test report.
As was the case when you posted WIP, the system creates numerous G/L entries in Finance when you recognize revenue.
Post progress measurements#
Measuring progress is largely identical to measuring project ledger entries. For this reason, only the differences between them are explained in the following.
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#
For measurements based on project completion, a suitable measurement method must be created for projects. Crucial in this context is the Measurement Base field, where you must select the Completion option.
As was the case for measuring project ledger entries, you first run the Measurement Suggestion function on the Project Measurement Jnl. page. Note the filter set on the Posting Date field, as the focus has now shifted to completion values.
All subsequent steps (posting the project 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 Finance) are the same as for ledger entry-based measurement.
Analyze measurements#
The measurement functionality also provides you with options of analyzing the data relevant to determining the current value of a project.
Gross profit and loss report#
This report shows you the lines and values for 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 has been selected for it in the measurement template.
On the Project Dim. Value Report Buffer FastTab, you can first specify the dimension by which projects on the report are grouped. In the Dimension Value field, you can then enter a value to show only projects where the value has been assigned as a default dimension (such as range 30). You can also limit what projects you can see by setting a filter in the Project No. field.
On the Options FastTab, you need to enter a date so that you see only measurements valid in that month. In the Meas. Method Code field, you need to enter the code of a measurement method that will be included on printouts.
Additionally, with the Preview toggle turned on, the report will show both posted and created but not yet posted measurements on the report.