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 GBS Credit Management 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 in the Google sheet "".  

    1. Please do not over write the first line A1:O1
    2. Insert the end of the month date you are reporting in Pa.  The cell P1 with the format "yyyy-Mmm-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 - cell L2.

      Copy F12:Gxxxx

    2. Modify credit limit data format for Google spread sheet.  BW amount 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. Click "Team board view"
  6. Team board view is to be refreshed.  

Credit Assessment Review Due Date, Aging (Credit Status = Open Credit ) (One month to go )

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

  2. Clean previous month data in "RawData" from to A13:Txxxx in the Google sheet "OTC FO APAC Indicator 1 - Credit Assessment Due Date Aging".  

    1. Please do not over write the first line A1:T12
    2. Insert the end of the month date you are reporting V2.  The cell V2 with the format "yyyy-Mmm-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 (BW_QRY_MVFIAR01_0002)

      Last Internal ReviewLast Ext.ReviewNext Review

      from R12:T12 to the end row.

      ii.Paste on the Raw Data - cell R13.

      Copy F12:Gxxxx

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

      You may copy the cell O12:Oxxxx 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. Click "Team board view"
  6.  Team board view is to be refreshed.