A sub contract can report costs to a project using a connected activity. This allows for seamless tracking and reporting of Planned, Committed, and Used costs.
If multi-currency is used on the sub contract, the contract currency is the default currency for the item. This can be changed to any currency code valid for the sub contract currency type. If a project activity is connected to the sub contract, a connection per currency code will be created in the project.
While the sub contract will report Planned, Committed, and Used costs throughout various stages of the contract, the used cost is reported by the vouchers created. When multiple currencies are involved, all calculations to reduce the committed cost when the used cost is reported are done in the transaction currency. The remaining committed cost is then converted to the base currency using the currency conversion rate valid on the system date and updated to the project activity.
The example below illustrates how the sub contract reports costs to the connected project activity when multi-currency is involved.
The Sub Contract, Revision and Items command or Sub Contract Revision and Items.
Line | Value Contract Currency | Value Company Currency | Item | Currency | Currency Type | Value | Value in Contract Currency |
Line 1 | 24000 | 24000 | Item 1 | USD | 1 (1:8) | 1000 | 8000 |
Item 2 | USD | 1 (1:8) | 1000 | 8000 | |||
Item 3 | USD | 1 (1:8) | 1000 | 8000 |
View the cost progression in the Project Monitoring/Cost page.
Cost Element | Planned Cost | EV | Planned Committed Cost | Committed Cost | Used Cost | Progress |
S01 | 24000 |
Cost Element | Planned Cost | EV | Planned Committed Cost | Committed Cost | Used Cost | Progress |
S01 | 24000 | 24000 |
Cost Element | Planned Cost | EV | Planned Committed Cost | Committed Cost | Used Cost | Progress |
S01 | 24000 | 24000 |
Cost Element | Planned Cost | EV | Planned Committed Cost | Committed Cost | Used Cost | Progress |
S01 | 24000 | 24000 | 24000 | 100% |
This table illustrates how costs are reported from the sub contract to the project activity at different stages.
Cost Type | Event | Values Reported | Currency Type | Date to Calculate Currency Rate |
Planned Cost | Select Report Planned Cost option | The adjusted contract item value | Item currency type
|
System date
|
Activate revision | The adjusted contract item value, refreshed each time a revision is activated | |||
Update planned cost | The adjusted contract item value, refreshed each time a revision is activated | |||
Planned Committed Cost | Enter call of values | The planned call off values | Item currency type | Call off date |
Committed Cost | Release call off | The call off values of the released call offs | Item currency type | System date |
Receive application | Total Contract value of released call offs in transaction currency - Cumulative Certified or Cumulative Application Received value of the maximum valuation in transaction currency | |||
Certify valuation | Total Contract value of released call offs in transaction currency - Cumulative Certified or Cumulative Application Received value of the maximum valuation in transaction currency | |||
Amend committed cost | Amended call off values of the released call offs | |||
Used Cost | Receive application for payment | Base currency values from the SCV vouchers are used. | - | - |
Certify valuation | Base currency values from the SCV vouchers are used. | |||
Actual Cost | Update GL vouchers | Base currency values from the GL vouchers are used. | - | - |
When the Project Connection Refresh operation is performed, the cost is retrieved as described below. Cost elements will be retrieved from the posting control setup.
Cost Type | Reported Value | Currency Type | Date to Calculate Currency Rate |
Planned Cost | If an active revision exists use the stored base currency value | -
|
-
|
If there is no active revision, but the Report Planned Cost option is enabled, use the stored base currency value | |||
Committed Cost | If no valuations exist use the released call off values | Item currency type | System date |
If a valuation exists: Total Contract value of released call offs in transaction currency - Cumulative Certified or Cumulative Application Received value of the maximum valuation in transaction currency |
|||
Used Cost | Base currency values from the SCV vouchers and I vouchers. | - | - |
Actual Cost | Base currency values from the GL vouchers are used. | - | - |