Page tree

   

 

Net Value Accrual CP + Gross Weight

TIERS - Shipment costs detailed analysis
QVSCE_BW_QRY_MVSDTR01_0010

Global Filters

Period

Month Year

Ship Actual for Ship [C_SHIPNU2__C_COMPMON]

Geography

Zone

Ship Dep Geo Zone [C_PNTDP3__C_ZONE]

Country

Ship Dep Country [C_PNTDP3__0COUNTRY]

Organization

GBU

BFC GBU [C_SUBACT2__CPFCTR1_2]

Legal Entity

Company code [C_COMPCDE]

BU

BFC Group of activity [C_SUBACT2__CPFCTR2_2]

Site

Purchasing Site [C_PLANT__C_PSITE]

Specific Filters

Transportation

Transport Mode

Ship Transportation [C_SHIPNU2__C_TR_MODE]

Transportation Group

Transportation Group [C_MATNR2__C_BULKPAC]

Forward Agent

Forward Agent [C_FWDAGID]

Sea line

Ship Shipping Line [C_SHIPNU2__VTADD01]

Destination

Ship Dest Point

Ship Destination Point [C_PNTDS3]

Ship Dest Country

Ship Dest Country [C_PNTDS3__0COUNTRY]

Ship Dest Zone

Ship Dest Geo Zone [C_PNTDS3__C_ZONE]

Partner Type

3rd Party Type [C_PNTY3PY]

Partner

3rd Party (Cust/Vend) [C_3RPARTY]

Product

Material Division

Division [C_MATNR2__C_DIVISN]

Commercial Product

Commercial Product [C_MATNR2__C_PROD]

Product Hierarchy

Material Hierarchy [C_MATNR2__0PROD_HIER]

Reference date:

Shipment completion date

KPI:

Cost  &  Cost/Weight

Comments:

  • Net Value Accrual CP: Net Costs in provisions in EUR or USD

Provisioning Costs

The transportation costs are not the invoiced one. We can only have the product level with the provisioning values.
  • Gross Weight: in kilograms only

  • Conversion rules: EUR / USD

The conversion from a local currency to EUR or USD is based on the exchange rate managed by Finance. For each cost, the rate considered is the one of its reference month*.

* The reference month of a transportation cost is :

      • the actual completion month
      • the planned completion month if the actual completion month is not available
      • the shipment creation date if the planned completion month is also not available 

USD inacurracy

For USD, we don’t have all the exchange rates because it's not the official currency at Solvay (EUR).

So for the following countries: Argentina, Bulgaria, Egypt, Mexico, New Zealand and Switzerland, when selecting USD, the unit will not be USD but the local currency.

 

 

Shipment file

The Transportation Costs are calculated for each and every one of the shipment files present in TIERS. (Inbound and Outbound)

TIERS: Number of single shipment files (shipment operation assigned to one Forwarding Agent) Thus, it depends on each GBU process.

The best way to get IT support is to use the new Service One Platform.