Tasks to be completed when creating an operating procedure (from creation to publication)
- Enter the Title of the procedure: Description of the operating procedure - Region (APAC, EMEA, LAM, NAM) - Country (Optional) - ERP (PI1, PF1, WP1)
- Add the following Labels :
- Fill all fields as described
- Once the procedure is completed, publish it using the SBS-OtC approval workflow
Table of contents
How to publish indicators on Real Time Board
What information we import from BW_data
Objective and Scope
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.
Scope
ERP
BW - WBP
References
Attachments
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:
- Credit limit over
- Customer review date in the past
- 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
- Refresh a BW query - CreditBlockIN_CL&RiskCategory - sheet "Blocked orders detail" with the end of the reporting period date.
Clean previous month data in "RawData_BW" from to A2:Oxxxx.
Title row
- Please do not over write the first line A1:O1
- Insert the end of the month date you are reporting. The cell P1 with the format "yyyy-mm-ff".
- 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.
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.
Format change
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
Modify credit limit data format for Google spread sheet. BW date format is nnn.nnn.nnn,nn EUR whereas google spread sheet nnnnnnnnn.nn.
Format credit limit
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".
- "Dashboard" tab is to be refreshed.
- Team board view is to be refreshed.
Monthly order block reason analysis
- Refresh a BW query - CreditBlockIN_CL&RiskCategory - sheet "Blocked orders detail" with the end of the reporting period date.
Clean previous month data in "RawData_BW" from to A2:Oxxxx.
Title row
- Please do not over write the first line A1:O1
- Insert the end of the month date you are reporting. The cell P1 with the format "yyyy-mm-ff".
- 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.
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.
Format change
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
Modify credit limit data format for Google spread sheet. BW date format is nnn.nnn.nnn,nn EUR whereas google spread sheet nnnnnnnnn.nn.
Format credit limit
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".
- "Dashboard" tab is to be refreshed.
- Team board view is to be refreshed.