| Project (tppdm6100s000) |  |
| Use this session to maintain master project data for each project. The project data defines all aspects of the project. Many fields depend on the parameter sessions for defaults or input. So, if a field has incorrect data, please check the related field in the parameter sessions. Use the Rotate Currency button to see amounts in the different home currencies. The revenue recognition method and the cost of goods sold method is defined at the project, extension. RR and COGS can also be determined at the element and activity level depending on the method of RR and COGS selected. The usage of element and activity depends on whether the project is controlled by element or controlled by activity. On the project level and extension level, you can set a lower and upper limit on the revenue to be recognized. Related topics To use project data management To create a project To use a search path To use currencies in Project To use home currencies in Project To use the rate determiner Revenue Recognition (RR) and Cost of Goods Sold (COGS)
Fields | Description
General
Project | Enter a new project code. You can choose to create a project from: An existing not-used general project. A new number attached to the project series. A new number attached to the estimate series. The estimate series is different from the project series. If you create an estimating project, the numbering helps you recognize that the project started as an estimate. A first free number.
Status | The status of the project. The project status is important for following the right course throughout the project life cycle. Note For projects of type Template, the project status does not hold any significance.
General
Description | The description or name of the code.
Search Key | An alternative form of a description used for convenience during searching. Typically, it is an abbreviation, an acronym, or a mnemonic alternative to a full description.
Address Code Project | The code that identifies the location where the deliverables for the project can be sent. In the US this address code is used for the tax provider.
Ship-from Address | The address entered here will be used as the standard ship-from address for the project deliveries and services.
Enterprise Unit | A financially independent part of your organization that consists of entities such as departments, work centers, warehouses, and projects. The enterprise unit's entities must all belong to the same logistic company, but a logistic company can contain multiple enterprise units. An enterprise unit is linked to a single financial company. When you carry out logistic transactions between enterprise units, these are posted in the financial companies to which each enterprise unit is linked. You can define the relationships between the enterprise units, and thus the goods transfer that can take place between the enterprise units. To use invoicing and pricing between enterprise units, you must link the enterprise units to internal business partners. You can use enterprise units to do separate financial accounting for parts of your business. For example, you can define enterprise units for separate parts of your organization that belong to one logistic company, but that are located in different countries. The accounting of each enterprise unit is performed in each country's national currency, and in the financial company linked to the enterprise unit.
Financial Company | The financial company to which the enterprise unit is linked. If the financial company is not the same as the operational company, the currency system of the financial company will be used for Project. Related topics Currency systems
Project Type
Internal Project | If this check box is selected, the project is an internal project. An internal project has no contractual obligations to a business partner and its costs will be booked to the profit and loss account. Next to the simple internal project there is also a possibility of making a capital project if you check the Internal Project check box and the Capital Project check box. A capital project is an internal project that will be capitalized on the balance sheet as a fixed asset after completion. Example A training program for the employees is a normal internal project. Constructing production facilities for a new product line is a capital project.
Capital Project | A project used for internal use in which deliverables can be booked as fixed assets but delivery of goods is not possible. In a capital project, you are the business partner. Note The check box cannot be selected if the financial transactions have been processed for the project and the project has already been made Active.
Template | If this check box is selected, the project is of the type template and cannot be used for actual projects. This project can be used only for copying projects. Note You can select the check box only if the status of the project is Free.
Hierarchy Type | A project must belong to one of the project types.
Main Project | The main project to which the subproject belongs.
Organization Breakdown Structure
Use OBS | This field indicates whether an organization breakdown structure (OBS) is used for the project.
Organization Breakdown Structure | The code of the organization breakdown structure.
Contract
Agreement Specification
Sold-to Business Partner | Usually a customer's purchase department, the business partner who orders goods or services from your organization, that owns the configurations you maintain, or for whom you perform a project. Details of the agreement with the sold-to business partner can include the following: Default price and discount agreements Sales order defaults Delivery terms The related ship-to and invoice-to business partner
Contract Amount | The total amount of the project contract. For a time-phased budget version, the contract amount is expressed as follows:
    contract amount = profit fee + management reserve + distributed budget + undistr. budget
The contract amount is used to determine the invoice limit.
Currency Rate/Rate Factor | A charge or payment fixed according to a standard scale, for example, the currency rate of the transaction.
Rate/Rate Factor | The factor by which the amount in the transaction currency or the invoice currency is divided before ERP LN converts it to a home currency. A rate factor is often used for currencies that have a relatively low price, for example, Korean Won.
In Home Currency | One of a company's base currencies in which ERP LN registers and reports amounts. In a multicurrency system, up to three home currencies can be defined: The local currency Two reporting currencies
In Home Currency | The amount in the home currency.
Contract Type | This field determines how the project contract amount is calculated. This affects the invoicing in Project.
Contract Execution | The contract type indicates whether your company executes the project as main contractor or as a subcontractor.
Invoice Type | The invoice type you choose determines the way invoicing is handled in Project Invoicing.
Holdback Percentage | The holdback percentage.
Customer Reference | This field will only be printed for Progress Invoice invoices. As part of the procedure for progress invoices, progress invoice specifications are created, which will use the reference.
Substantial Completion Date | The agreed date of the first completion of the project. This field only provides information.
Cost-Plus Markup
Material | The surcharge percentage used in the Material Costs (tpppc2111s000) session to calculate the default value of the sales price. This calculation is performed as follows:
    surcharge percentage sales price = cost price * (1 + (surcharge percentage / 100))
Note This is only relevant for cost plus projects or extensions.
Labor | The surcharge percentage used in the Labor Costs (tpppc2131s000) session to calculate the default value of the sales rate. This calculation is performed as follows:
    sales rate = cost rate * (1 + (surcharge percentage / 100))
Note This is only relevant for cost plus projects or extensions.
Equipment | The surcharge percentage used in the Equipment Cost (tpppc2151s000) session to calculate the default value of the sales rate. This calculation is performed as follows:
    sales rate = cost rate * (1 + (surcharge percentage / 100))
Note This is only relevant for cost plus projects or extensions.
Subcontracting | The surcharge percentage used in the Subcontracting Costs (tpppc2171s000) session to calculate the default value of the sales price. This calculation is performed as follows:
    sales price = cost price * (1 + (surcharge percentage / 100))
Note This is only relevant for cost plus projects or extensions.
Sundry Cost | The surcharge percentage used in the Sundry Costs (tpppc2191s000) session to calculate the default value of the sales rate. This calculation is performed as follows:
    surcharge percentage sales rate = cost rate * (1 + (surcharge percentage / 100))
Note This is only relevant for cost plus projects or extensions.
Financial
Financial Result Status | This field determines the procedure for calculating the financial project result in Financials.
Fixed Assets
Asset Number | If you select the Capital Project check box and you want to link the project to a fixed asset code, you can enter an asset number and an extension. The fixed asset will be appreciated at the closure of the project's actual costs. Zoom to the Assets (tffam1500m000) session to enter the fixed asset.
Asset Extension | The asset extension is a descriptional field. You can enter up to 15 characters. You can use this field to, for example, choose from a range of fixed assets that belong to one asset number in the Assets (tffam1500m000) session.
Bank Guarantee
Bank Guarantee Amount | To reduce the customer's risk exposure, it is customary for the contractor to place an amount of money on deposit as a guarantee against the failure of the project. This field gives the amount of the guarantee. Alternatively, you can specify a percentage of the total contract value as a guarantee: use the Bank Guarantee % field.
Bank Guarantee Amount | One of a company's base currencies in which ERP LN registers and reports amounts. In a multicurrency system, up to three home currencies can be defined: The local currency Two reporting currencies
Bank Guarantee % | Alternatively to filling in the bank guarantee amount, you can specify a percentage of the total contract value as a guarantee.
Bank Guarantee Expiry Date | The finish date of the bank guarantee is the last date on which it is valid.
Bank Guarantee Reduction | One of a company's base currencies in which ERP LN registers and reports amounts. In a multicurrency system, up to three home currencies can be defined: The local currency Two reporting currencies
Bank Guarantee Reduction | During execution of the project the bank guarantee can be reduced.
Bank Guarantee Reduction % | While executing the project the bank guarantee can be reduced. In this field you can enter the percentage by which the bank guarantee will be reduced.
Bank Guarantee Reduction Date | The effective date of the reduction in the bank guarantee.
Payment Terms for Financial Analysis
Material | The average number of days between order date and payment date.
Labor | The average number of days between order date and payment date.
Equipment | The average number of days between order date and payment date.
Subcontracting | The average number of days between order date and payment date.
Sundry Cost | The average number of days between order date and payment date.
Business Partners | The average number of days between order date and payment date.
Budget
Methods
Budget by | The project budget type determines the way you look at your budget. You can budget the project by: Element Activity
Control By |
Budgeting Method | The way to measure expected productivity. ERP LN distinguishes the following two methods in the bottom-up budget: Production Rate: the number of production units produced per unit of time. Labor Norms: the number of hours required to carry out one unit of the cost object.
Path for Budget Labor Rate | The budget labor-rate search path for the labor cost rate and the sales rate in labor lines in the budget.
Use Extensions in Budget | If this check box is selected, extensions are used in the budget and in cost control.
Main Project Budgeting | If this check box is selected, the budget cost analysis and the generated control data only include the budgeted costs of the main project itself. The actual costs include both the cost of the main project and the costs of the corresponding subprojects. If this check box is cleared, the budget cost analysis and the generated control data include both the budgeted cost of the main project and the budgeted costs of the corresponding subproject.
Actuals
Budget Top Element | The top element of a project element or activity structure. The project budget is composed of a tree-like structure. The structure has only one top element or activity.
Budget Cost Analysis | Based on the project budget, several budget cost analyses can be performed in the Generate Budget Cost Analysis (tpptc3200m000) session. Each budget cost analysis is stored under the combination of project code and budget cost analysis code. For each project it is indicated which budget cost analysis code must be regarded as actual. In the case of cost comparisons between the project budget and/or the costing, ERP LN always shows the cost data of the project budget on the basis of the actual budget cost analysis code.
Time-Phased Budget Anal. | Based on the actual budget, several budget cost analyses can be performed in the Generate Budget Cost Analysis (tpptc3200m000) session. Each budget cost analysis is stored with the combination of project code and budget cost analysis code. For each project it is indicated which budget cost analysis code must be regarded as actual. In the case of cost comparisons between the estimate, the actual budget and/or the actual costing, ERP LN always shows the cost data of the actual budget on the basis of the actual budget cost analysis code.
Exchange Rate Type | The default exchange-rate type used for budget cost analysis across the package. The user can change the value while generating the budget cost analysis.
Defaults
Budget Date | Enter the start date of the budget.
Labor Cost Rate |
Project Currency | If the project is performed in another country, the project currency is useful for monitoring. This currency can be an external currency that is not specified as one of the home currencies.
Cost Rate Transaction Date | Whenever the general labor cost rate is changed in a project, the transaction date of the labor cost rate is automatically filled with the system date, so that it is always known when the latest labor cost rate change took place.
In Home Currency | The cost rate in home currency.
Labor Sales Rate | A general sales rate for the labor costs in a project.
In Home Currency | One of a company's base currencies in which ERP LN registers and reports amounts. In a multicurrency system, up to three home currencies can be defined: The local currency Two reporting currencies
Cost Rate Transaction Date | Whenever the general sales rate is changed in a project, the transaction date of the sales rate is automatically filled with the system date, so that it is always known when the latest sales rate change took place.
In Home Currency | The sales rate in home currency.
In Home Currency | One of a company's base currencies in which ERP LN registers and reports amounts. In a multicurrency system, up to three home currencies can be defined: The local currency Two reporting currencies
Rate Unit | For example, the cost rate is 25 EUR and the unit is hours, this means the costs are 25 euros per hour.
Planning
Scheduling
Active Plan | The project plan used in the project. This field must be filled if the costs are controlled by the activity budget type.
Start Date/Finish Date | This date is default for plans and of importance while running budget cost analysis and using surcharges. The start date is used to decide what (budget) surcharges are valid for the budget cost analysis. Lack of a start date will result in all surcharges to be used. Note If you use an extension for a fluctuation with invoice calculation method Actual Costs (set in the Extension (tpptc0110s000) session), it is mandatory to enter the project start date.
/ | The finish date of a project is only used to provide information.
Project Lead Time Type | The way time is looked at in a plan.
Estimated Lead Time | This field enables you to record the time which is expected to be needed for the execution of a project. The field only serves to provide information. The required project time can be expressed in workdays or in calendar days, depending on the setting of the Project Lead Time Type field.
Final Project Lead Time | This field indicates the project lead time according to the specifications. The field is only used to provide information. The required project time can be expressed in workdays or in calendar days, depending on the setting of the Project Lead Time Type field.
Phase | You can link a phase to a project in every status. A phase can be used to differentiate the project. Example You can link the Phase code 001 with description Delete Data to a range of projects. To delete the right projects, you just select the phase code 001.
Requirements Planning
Commit Inventory On | Specify the phase when the inventory in the warehouse must be committed to the project, based on the availability. Allowed values: Insert You can reserve the real inventory, that is, commit the inventory in the warehouse when you insert a planned warehouse order in the Project Requirements module Approve The inventory is committed when you confirm the planned warehouse order. Not Applicable Note An inventory reservation in Project is an inventory commitment in Warehousing
Priority Supply Warehouse | A general warehouse that receives the deliveries for more than one project. The goods are sent from the priority supply warehouse to the project warehouse. Related topics Using warehouses
Default project warehouse | A project warehouse is used to store the delivered goods coming from the priority supply warehouse. Enter a warehouse in this field if you want to use one warehouse for the project. All inventory will be sent to that warehouse. You can also leave this field empty and link the warehouse on a lower level to an element or activity to improve inventory control.
Project Created From
Project Template | The code of the template used to create the project.
Control
Control
Material Phys. Progress | The level at which you can record the progress for this cost type.
Labor Phys. Progress | The level at which you can record the progress for this cost type.
Equipment Phys. Progr. | The cost price.
Subcontracting Phys. Progress | The level at which you can record the progress for this cost type.
Sndry Cost Phys. Progr. | The cost price.
Register Progress | To use progress result
Cost Registration
Path for Hours Labor Rate | The labor rate for hours registration search path for the labor cost rate per hour and the sales rate per hour in the labor lines.
Logging
Control Data Generation Date | The last date the Generate Control Data (tpptc1230m000) was run for this project.
Control Data Generated By | The logon code of the user who last ran the Generate Control Data (tpptc1230m000) session for this project.
Last History Posting Date | The latest date on which actual cost transactions were posted to the history. This date is automatically saved by ERP LN during execution of the Post Transactions (tpppc4202m000) session. This field is only used to provide information.
Login Last History Posting | This field shows the logon code of the user who last posted actual cost transactions for this project to the history. The value of this field is automatically updated during execution of the session.
Actual Cost Last Build | Date of last generated control data.
Login Cost Ctrl Data | The logon code of the user who last ran the Build Actual Cost Control (tpppc4803m000) session for this project. This field is only used to provide information.
Estimating
Rejected | A project can be rejected after being estimated. This field indicates whether the estimated project can continue with its life cycle of estimating, budgeting and invoicing.
Reason Code | Use this field, for example, in situations where a particular estimate is either rejected or the project is delayed. The reason code is mandatory if the estimate is rejected.
Resulted in Project | This field is filled only if different series are used for projects and estimates. The target project is displayed, after the copy process.
Originated from Estimate | This field is filled only if different series are used for projects and estimates. The estimate project used as the source is displayed.
Last Launched by | The logon code of the person who has launched the estimate to a project. The logon will be registered from the last launch.
Date of Launch | The latest date that the launch process is run.
Interim Results
Revenue Interim Results
Revenue Recognition Method |
Percentage Completed | The percentage of completion of the project. You must multiply this percentage with the contract amount to calculate the revenue to be recognized. Note You can manually enter the percentage of completion or click Calculate Perc. Complete to get the calculated value. ERP LN calculates the percentage using the following formula:
    percentage of completion = costs (incurred) / estimate at completion cost
Earned Revenue Factor | Specify the earned revenue factor. You must multiply this factor with the the cost to calculate the revenue to be recognized. Note You can manually enter the earned revenue factor or click Calculate ERF to get the calculated value. ERP LN calculates the factor using the following formula:
    ERF = project contract amount / total budgeted costs
To calculate ERF, the project status must be Active, because the total budgeted cost is known only for active projects.
Revenue Recognition Threshold | The minimum percentage completion expected before revenue is recognized. Note Only if the percentage completion is greater than or equal to this field, revenue is recognized when interim results are generated using the Generate Financial Interim Results (tpppc2260m000) session. However, if the Profit Percentage is negative, revenue will be recognized irrespective of minimum percentage completion being met or not. Default value 0
Revenue Recognition Limit | The limit on the revenue to be recognized. Specify a maximum percentage. Note The value can be changed. The revenue recognition limit is valid for all RR methods except the Completed Project method. The percentage times the contract amount gives the maximum revenue that can be recognized (until the completion of the project). This percentage is ignored when the project is complete and the final revenue (and COGS) is posted. Default value 100
Cost Interim Results
Costs of Goods Sold Method |
Profit Percentage | Specify the profit percentage. The COGS is calculated on the basis of this percentage and the revenue recognized. Note You can manually enter the percentage or click Calculate Profit Percentage to get the calculated value. ERP LN calculates the percentage using one of the following formulas:
    profit percentage = budget / contract amount
or
    profit percentage = EAC (Estimate at Completion) / contract amount
When the COGS is determined at project level, ERP LN allows you to select the base to calculate the profit percentage. You can either select Budget or select Estimate at Completion as the base to calculate the profit percentage.
Miscellaneous
Classification
Acquiring Method | For statistical reasons you can enter the method you used to acquire this project.
Financing Method | The code that identifies the financing method used for this project.
Business Sector | The code that identifies a business sector.
Geographical Area | The geographical area.
Category | A user-definable classification for projects.
Group | A user-defined classification of projects.
Miscellaneous
Sundry Cost Code for Provisional Amounts | Costs relating to an extension of the Provisional Amount type are posted to a sundry cost object. This field identifies the code of the sundry cost object (standard or project-specific) used for this project. This field takes its default value from the Sundry Cost Code for Provisional Amounts field in the Template - Project Data (tppdm5101m000) session.
Default Cost Account/Work Package | The activity is used as default in processes in which an amount must be posted to an activity and the activity is not specified. This occurs in the following cases: If installments are generated automatically through the Create Progress Invoice Installments (tppin1210m000) session. If provisional amount settlements are generated through the Generate Provisional Amount Transactions (tpppc3210m000) session. If invoices are generated for extensions. If unit rate invoices are generated. Note The default activity comes from the Template - Project Data (tppdm5101m000) session. Create Progress Invoice Installments (tppin1210m000) Generate Provisional Amount Transactions (tpppc3210m000)
Use Surcharges | The surcharges used.
Sufferance Tax | The code that identifies the sufferance tax that applies to this project.
WIP Sales Value Surcharge | The surcharge percentage calculated on the total costs of the project to determine the financial value of the work in process (WIP). This surcharge percentage is used only if the Sales Value Surcharge Costs in WIP check box in the PPC Parameters (tpppc0100s000) session is selected.
Subcontractor's data (as per Dutch WKA law)
Wage in Contract Amount | The percentage of the total contract amount which has been agreed upon with the main contractor that is formed by wage costs.
Labor B-Account | This field is only relevant in the Netherlands.
Login
User | The user who creates the project. The default value is the login name of the user. The value can be changed.
Project Created From
Project Origin |
Project Origin | If applicable, the source from which this project was copied.