Versions Compared

Old Version 5

changes.mady.by.user Karina Keiko Tsuji

Saved on

compared with

New Version Current

changes.mady.by.user Miriam Luttrin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Info
titleProcess Owner
Aurelie Mazerot
Process Expert
Info
titleD&PS Expert
Miriam Luttrin
General Description
This KPI display a chart with WC Receivables split by Trade Receivables, Advances received from customers and Trade Receivables by BFC Account and WC Account Sub-Type.
This measures values by month which helps for future projection.  Besides another chart where it's possible to explore WC Receivables split by GBU
These graphs show data for external customer coming from FIAR as well as GL Account coming from FIGL. This allows users to have an overview on the QC receivables for non SAP companies that are entered manually in BFC and therefore allowing reconciliation with BFC on a Solvay Group level.
 Indicator details results can be analyzed by :
BFC Account
WCAccount Sub-Type
Image Removed Date Reference:
 
  Refresh Frequency: 
Monthly (during closure on 1st to 6th 3 times per day)
KPI Name
Calculation
Account Receivables
 
Advances Received Customers
 
Trade Receivables Wd
 
WC Receivables (FIAR-SAP)
(QVWCAP_BW_QRY_MVFIWC01_0013)
Total WC
Clearing year/month = Not assigned
Merging Date = #
WC Receivables (FIGL-Non SAP)
(QVWCAP_BW_QRY_MVFIWC01_0015)
WC Acct Type = Receivables, Key Figure "FC pack"
To isolate BFC entities - Compare queries "_0013" & "_0015"
QV Rule: If Company code is null or equal to 0 in query "_0013", then show figures from query _0015 for those companies.
Source Information:
Core Query:
BW_QRY_MVFIWC01_0013
BW_QRY_MVFIWC01_0015
QV Query:
QVWCAP_BW_QRY_MVFIWC01_0013
QVWCAP_BW_QRY_MVFIWC01_0015
(Non SAP - manual - conditional if absent from 13)
BW Filters:

 

Flag Obsolete Object <> 1
  Info Provider <> FISCA: Magnitude account data (cube)
PRS Comp. Interco Flag = YES
 
Image AddedControl  Credit Area = "SOLV"
Flag Obsolete Object <> 1
Info Provider <> FISCA: Magnitude account data (cube)
PRS Comp. Interco Flag = YES
WC Acct Type = INVENTORY
PAYABLES
RECEIVABLES
Image AddedControl  Credit Area = "SOLV"
Specific Dimensions
WC Account Sub Type
 
Customer Country
Country of the PRS Customer