Basic Information
| BW Server | WBP |
|---|---|
| Application | ITC - Credit Management |
| Workbook Name | Credit Mgt - Weighted Paymt terms & delays (Core Workbook) |
| Workbook Code | BW_WBK_ITC_0028 |
| Query Technical Name | BW_QRY_MVFIAR02_0007 |
| Core/Specific Scope | Core |
| Specific Reason | If the query is not core, explanation on why it's specific (Ex : Special Tax system in India...) |
| Provider Name | Ex : Material Stock MPR_IC002 |
| Usage type | Direct execution in Analyzer / Workbook broadcast / QV / webtemplate... |
| Expected users | Ex : Site controller |
This query is defined in Conso. view as all the other Credit Mgt reports, meaning in WP1/PF1/PI1 area and after Intercos eliminations
It includes factoring entries that can be seen both in Legal/Affiliate (origin) Company points of view.
1) Cash in follow up
- Cash in M, M-1..., M-5: Customer entries that have been cleared in current month, current month-1...
NB: Cash in definition is the same as the one used in other WC and Credit Mgt reports
- Weighted Paymt term M In days, M-1...M-5: [ Cleared (Cash in) date - Baseline (Invoice) date * Amount in Local/Target curr. ] / Amount in Local/Target curr.; it's calculated at document level
- Weighted Delay M In days, M-1...M-5: [ Cleared (Cash in) date - Net due date * Amount in Local/Target curr. ] / Amount in Local/Target curr.; it's calculated at document level
2) Open items follow up
- Outstanding: Customer open items at current date.
NB: Outstanding definition is the same as the one used in other WC and Credit Mgt reports
- Weighted Agreed Paymt term In days: [ Net due date - Baseline (Invoice) date * Amount in Local/Target curr. ] / Amount in Local/Target curr.; it's calculated at document level
- Overdues: Customer open items at current date with Net due date < current date.
- Weighted Overd. Delay In days...: [ Net due date - Current date * Amount in Local/Target curr. ] / Amount in Local/Target curr.; it's calculated at document level