Tasks to be completed when creating an operating procedure (from creation to publication)

  1. Enter the Title of the procedure:  Description of the operating procedure - Region (APAC, EMEA, LAM, NAM) - Country (Optional) - ERP (PI1, PF1, WP1)
  2. Add the following Labels : 
  3. Fill all fields as described
  4. Once the procedure is completed, publish it using the SBS-OtC approval workflow

Table of contents 

By default the table of contents displays Heading 2 & Heading 3 (other levels can be added)

How to publish indicators on Real Time Board

What information we import from BW_data

Objective and Scope

Describe the objective of the procedure & detail the scope when needed (legal entitites etc.)

This is an operational procedure manual for APAC credit management team to be able to publish indicators of our credit assessment review aging and blocked order reasons.

Definitions should be added in the OtC - Glossary


Scope

1. Remove the icon(s) when not applicable

   

2. Add countries when the procedure is for a specific country (optional)

ERP

3. Remove the icon(s) when not applicable

BW - WBP   

References

 

4. Add the link to SAP procedures (when it exists)

Attachments

5. Add the link to attachments (to be stored in AODocs or GDrive) or external links  

1. How to retrieve data sources on Real Time Board

This chart describes blocked order cases by reasons.  If an order has two reasons for credit block, it is counted as two cases in respective block reason categories.  We focus on three main reasons:

  1. Credit limit over
  2. Customer review date in the past
  3. Customer credit status 

Data source

When we use the select mode , we can reach the graphic source by clicking the source bottum.

Or you can get there directly from here.

This graphic has the link to the data source spread sheet.  It has a source bottom .  Go to th2RawData_BW".  

You can go to the tab directly from here.

Like wise when you look at the RTB, you can retrieve pie charts, graphs, and its data source spread sheets.  

2. How to update indicators

Monthly order block reason analysis

  1. Refresh a BW query - CreditBlockIN_CL&RiskCategory - sheet "Blocked orders detail" with the end of the reporting period date.  

  2. Clean previous month data in "RawData_BW" from to A2:Oxxxx.  

    1. Please do not over write the first line A1:O1
    2. Insert the end of the month date you are reporting.  The cell P1 with the format "yyyy-mm-ff".



  3. Copy BW data from A12 to Onnnn and paste on the sheet "RawData_BW" from A2 to the end of the data. A2:Oxxxx - depending on the number of blocked orders in the reporting month.  

    1. Modify date and credit limit data format for Google spread sheet.  BW date format is dd.mm.yyyy whereas google spread sheet has yyyy/mm/dd.  

      You can convert the data format with the excel file Format change.

      i Copy BW data (CreditBlockIN_CL&RiskCategory) "Created" and "Closed" from L12:M12 to the end row.

      ii.Paste on the BW Raw Data

      Copy F12:Gxxxx

    2. Modify credit limit data format for Google spread sheet.  BW date format is nnn.nnn.nnn,nn EUR whereas google spread sheet nnnnnnnnn.nn.

      You may copy the column M to N with text format.

      i Replace " EUR" with null "".

      ii. Replace period mark "." with nul "".

      iii.Replace comma "," to period mark ".".

      Copy N12:Nxxxx (BW_Data_format excel file) and paste to column J "Credit Limit Data" in the google sheet "RawData_BW".  

  4. "Dashboard" tab is to be refreshed.
  5.  Team board view is to be refreshed.  

Monthly order block reason analysis

  1. Refresh a BW query - CreditBlockIN_CL&RiskCategory - sheet "Blocked orders detail" with the end of the reporting period date.  

  2. Clean previous month data in "RawData_BW" from to A2:Oxxxx.  

    1. Please do not over write the first line A1:O1
    2. Insert the end of the month date you are reporting.  The cell P1 with the format "yyyy-mm-ff".


  3. Copy BW data from A12 to Onnnn and paste on the sheet "RawData_BW" from A2 to the end of the data. A2:Oxxxx - depending on the number of blocked orders in the reporting month.  

    1. Modify date and credit limit data format for Google spread sheet.  BW date format is dd.mm.yyyy whereas google spread sheet has yyyy/mm/dd.  

      You can convert the data format with the excel file Format change.

      i Copy BW data (CreditBlockIN_CL&RiskCategory) "Created" and "Closed" from L12:M12 to the end row.

      ii.Paste on the BW Raw Data

      Copy F12:Gxxxx

    2. Modify credit limit data format for Google spread sheet.  BW date format is nnn.nnn.nnn,nn EUR whereas google spread sheet nnnnnnnnn.nn.

      You may copy the column M to N with text format.

      i Replace " EUR" with null "".

      ii. Replace period mark "." with nulｌ "".

      iii.Replace comma "," to period mark ".".

      Copy N12:Nxxxx (BW_Data_format excel file) and paste to column J "Credit Limit Data" in the google sheet "RawData_BW".  

  4. "Dashboard" tab is to be refreshed.
  5.  Team board view is to be refreshed.