Aurelie Mazerot
Process 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. 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
 
  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
Control  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
Control  Credit Area = "SOLV"
Specific Dimensions
WC Account Sub Type
 
Customer Country
Country of the PRS Customer