General presentation

Objective of the application

FSCM (Financial Supply Chain Management) application provides an unique reporting tool for the collection team, including in particular the following points:

• Give a global overview of overdues (FIAR module) with a data enrichissement for disputes, promise to pay, dunning and collection data (Scenario, collection specialist ...)

• Give some statistics on disputes and P2P (Nbr, average time, …)

• Overdue follow up for sales team using bursting broadcast

Reporting coordinator is Sandrine Micollet

Tool leader is François Rublon.

Usage information

3 type of population for FSCM application

• Collection Team
• Short Payment Team (Only one query => Dispute Follow up for Short Payment)
• Sales Team

History

Project done between 2013 and 2015.

Roles & Access

Roles and access

Authorisation objects

Link to the BW Catalog of role

https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I

Dataflow overview

Overview

Reporting documentation drive folder:

https://drive.google.com/drive/folders/0B_p_Afe8sjVlQXVsRmNEYzRVeVU

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Model 1 - Cash Collection Piloting Tool

• Only open items are present in this model (delete + full loading)
• Data are dispatched in tabs in the workook
  
• By default, we display data without inter-company link (DM Flag < CLM Flag < Err Flag)
  
• Key figures: all overdues are based on NetDueDate VS Current Date)

Model 2 - Scenario Collection Piloting Report

• Data are distributed in 2 tabs
  
  • Distribution of scenario (<=> Collection strategy => allow prioritization for coll. specialist)
    
  • History of scenario
    

  • WARNING : Model based on infoset with inner join => Only customer / company with a BP partner for CLM data are displayed (Same logic for Scenario)

Model 3 - Dunning Level Report

• This model is used to display dunning’s information at master data level
  

• Dunning information at transactional data (link to FI doc) is not supported

  • Some technical and functional analysis must be done in order to find a way to replicate transactional dunning data (which are for certain customers, only maintained in WARP) 
  • Reminder : WARP is a technical company create for financial mirroring concept

Model 4 - Statistics FSCM Report

• Data are distributed into 4 tabs without dimensions (nav. attr. customizing)

  • Disputes Statistics (3 months displayed by default + 3 additional month)
    

  • Promise to Pay (P2P) Statistics
    

  • Customer TOP 10 by number of disputed
    

  • Customer TOP 10 by disputed amount
    

• Model contains opened and closed items (Base on business layer DSO)

Common rules for legacies

• Transcodification of FI Doc. from WARP to Affiliate (For GBU determination)

This part is manage by a RFC module function in CICC and allow to find the affiliate document linked to a WARP document (Useful for data affectation of disputes and P2P which are only created into WARP for the majority of cases)
WARNING : Transcodification covers 92% of cases (Tech./Func. analysis to deepen)

• Joining Data for FIAR, CLM, DM & WARP (Level 1 -> .. -> Level 4)
• Technical Flag management (DM Flag, CLM Flag, Error Flag ...) 
• All doubtful accounts are filtered using subtype for identification
• Use pledging factor (= FA) to identify customer managed in WARP for dunning 
• Customer -> BP -> Collection Specialist (1:1 Relation) 
  • Relation between Customer, Business Partner and Collection specialist is managed by DSO DPCLM03 & DPCLM06 and contain only CICC data (WARP + NAFTA + CICC)
  • WARNING : Rule is not correct for APAC data (Tech. analysis in progress)

Specific rules for legacies

Sales employee determination

• Acetow legacy: Sales Employee is linked to customer credit group associated to customer in FI document
• Rhodia legacy: Sales Employee is linked to Sales Group associated to FI document
• CICC legacy: Sales Employee is linked to Sales Manager of factoring document associated to FI document
• Solvay legacy: Sales Employee is linked to Sales Manager of invoice associated to FI document

Reminder : You can see more details in following documentation :
https://docs.google.com/a/solvay.com/spreadsheets/d/1VUYjzm6EGl6KnyJpa47MBMWs3gXk_h__3F6gZCfhr5A/edit#gid=1259214365

Dependencies with other applications

FSCM applications is dependant with

• WCAP Working Capital (FIAR flow)
• ITC Invoice to Cash (FIAR data source)

Data loadings

Info providers and objects loaded

Loading frequency

Average performance

Record Keeping

Reporting

Queries End User Documentation

Main queries

Main functionalities

Broadcast

Bursting broadcast has been created for FSCM project (Drive by characteristic C_SALEMP - Sales Employee)

• Type of broadcast which allow to send more than 700 emails with only 5 broadcast settings
  • Easier maintenance / Better performance (query run only one time and then data is split using bursting logic)
• Manage using control queries for selection of sales employee (+ manual flag in MD)
  • WARNING : Without control query, you need to create filter in broadcast setting else for each record in master data an email will be sent (More than 60 000 sales employee)
• Manage by 3 specifics process chains (One for each zone ⇔ APAC, NAM/LAM & EMEA)

Specific Broadcasts (See dataflow for more details) 

• Manage for DM (Director of Market) and KAM (Key Account Manager)
  • These broadcasts contain specifics rules for filtering (Like list of customer, or sales employee, or account …)
  • The layout is also different than for bursting broadcast
  • List of email’s recipient is directly managed into the broadcast settings

Maintenance

Known bugs

No known bugs

Recurring procedure

Bursting broadcast analysis

https://drive.google.com/open?id=1VUYjzm6EGl6KnyJpa47MBMWs3gXk_h__3F6gZCfhr5A

Bursting broadcast documentation

https://docs.google.com/a/solvay.com/document/d/15DaFZFEcYsfZc98zzlox-J3QaCYbbGsMTd7GxbSHOMM/edit# (How to use it)
https://drive.google.com/a/solvay.com/?usp=chrome_app#folders/0B6UtwJUYvmgTYU1ndXBZczMtWTQ (How to solve issues)

Business content installation for FSCM

https://drive.google.com/open?id=1wSQPHs-4qCcIcMDpOCnJT9AcPNI_2hHXG–YBuI3Vhk

Planned Evolution

No planned evolution