Page History

Capex

is the amount paid

It's the total amount

If the cost is not related a purchase order => equal to the capspend (GR)

-------------------------------------------------------------

After a project has been approved and created in PS

Capex Actuals are available when Colmar investment project code = the PS project ID

Data are coming from PS

Capex Forecast

is the prevision of capex filled and updated by the GBU into Colmar

Capspend Actuals

is the actual costs (received costs)

it can correspond to :

• Purchase orders, the reception of services/goods (at GR date)

• Stock issue : value of the material (at stock issue date)

• Hours : standard cost defined for each hour.

• Transfers (from Maintenance orders etc...)

• Manual entries (CO document) and other adjustments.

Capspend Forecast

is the prevision of Capspend filled and updated by the GBU into Colmar

paid upon receiving suppliers' invoices billed to the goods/services related to projects created in PS usually link to Purchase Order.

Core query

BW_QRY_MPR_PS014_0011

BW_COLMAR_MVIPCO17_0001

QV query

QVCAPEX_BW_QRY_MPR_

PS014_0003 (Y-1)
QVCAPEX_BW_QRY_

MPR_PS014_0004 (Current Year)

Refresh frequency

Daily - full reload

Daily - full reload

Filters

Investment type <> training

• WBSE Type : Capex, Nc OtC (Opex), Not assigned

• Status : Closed, Created, Not assigned, Released, Technically Completed (coming from the Project)

• Project Definition : Combination of Code + Definition (Choose from list of projects)

• Group PS : Group of Projects (Choose from list of groups)

• Project Scale : Current, Major, Medium, Project without budget

• Conso Meth. : Equity Method, Fully Consolidated, Merged, Not Fully Consolidated, Proportionately Consolidated, Sold

• Version : Active version (last version updated in Colmar), Y versions, Y-1 versions

• Project type : Capitalized, Not Capitalized

• Planned : Yes, No (Yes = the forecast amounts are taken into account in the GBU totals)

• Bundle : list of bundles (def + key)

• Project status : Approved (as soon as there is an authorized amount), Not Approved

• Project approval status : Present approval status of the project

• Project approval year : for a bundle, 1rst date of approval of the projects of the bundle

All the projects

• created in WP1, PF1, RHO

• WBSE Type <> billing

• Project status different from "Closed" or "Closed" with movement in previous year (Y-1) and/or current year (Y)

  entered in Colmar with forecasted budget on the available versions