Process Owner

Ricardo Nunes
Process Expert, Account Payable

D&PS Expert

Marie-Line Ardito
General Description
Indicator regarding payment on time:Payment On Time = In Advance + Due Date + Month Postpone + Weekend Postpone 
 
Details results can be analyzed by:
    • All
    • Region
    • GBU
    • Country
    • Legal Entity
    • Plant
    • Site
    • Domain
    • Type
 Date Reference: Clearing Date
Weekends and Holidays (By Zone) are taken into account.*The function Working Day takes in parameter a calendar ID which corresponds to the country of the current record.
So for each record we take the country and then verify in the table TFACD if the calendar ID is present.
If it is not present, the query take the default value ‘BE’.
Regarding the country, the holidays are different so a Clearing Date can correspond to a working day in a country and to a day off in an other one.


 Refresh frequency:Monthly - 1st and 5th of each month
KPI Name
Type
Number of Invoices where:
%
In advance
In advance
Clearing Date < Net Due Date (or Calculated Payment Date)
#of Invoices In advance
--------------------------------------
Total Numbers of Invoices
 
   
On time
Due Date
Clearing Date = Net Due Date (or Calculated Payment Date)
#of Invoices In advance
--------------------------------------
Total Numbers of Invoices
Mth Postpone
Net Due Date = M-1 last working day and Clearing Date = M 1st working day
#of Invoices In advance
--------------------------------------
Total Numbers of Invoices
WE Postpone
Net Due Date = Saturday or Sunday and Clearing Date = Next Monday
#of Invoices In advance
--------------------------------------
Total Numbers of Invoices
    
Late
]0-5] Days
0 < Clearing Date - Net Due Date (or Calculated Payment Date) ≤ 5
 
#of Invoices "]0-5] Days"
--------------------------------------
Total Numbers of Invoices
]5-10] Days
5 < Clearing Date - Net Due Date (or Calculated Payment Date) ≤ 10-
#of Invoices "]5-10] Days"
--------------------------------------
Total Numbers of Invoices
]10-30] Days
10 < Clearing Date - Net Due Date (or Calculated Payment Date) ≤ 30
#of Invoices "]10-30] Days"
--------------------------------------
Total Numbers of Invoices
]30-60] Days
10 < Clearing Date - Net Due Date (or Calculated Payment Date) ≤ 60
#of Invoices "]30-60] Days"
--------------------------------------
Total Numbers of Invoices
Rest (> 60 Days)
 Clearing Date - Net Due Date (or Calculated Payment Date) > 60
-----#of Invoices "Rest"
--------------------------------------
Total Numbers of Invoices
Source
Core Query:
BW_QRY_MV_APRS1_0005
QV Query:
QVSBS_BW_QRY_MV_APRS1_0003
BW Filters
  • Creditor <> P000000000 - PZZZZZZZZZ
  • Creditor/Vendor Class <> S
  • Creditor Account Group <> Vendor, PERS, Employee, SSOL Vendors, ZSET, CPD One-Time Vendor, Personnel for expense accounts
  • Account Doc Type =
    RHO: KA, KC, KG, KN, KR, KS, RE, RN, ZG
    PF1: 18, 19, 23, 24, 43, 44, 48, 49, 53, 54, 63, 64, 73, 74, 83, 84, 87, 88, 93, 94, KA, KR, M1, M2, M3, M4, M5, M6, M8, M9, R0, R1, R2, R3, R4, R5, R6, R7, R8, R9, RA, RB, RC, RE, RH, RM, RN, RO, RP, RQ, RV, S5, S7
    WP1: KA, KG, KN, KR, RA, RE, RN, ZC, ZW
  • Clearing Doc <>
  • RHO: ]30000000 - 39999999[
    PF1: FI Documents ]3070000000 - 3079999999[;]6310000000 - 6319999999[;MM Documents ]6510000000 - 6519999999[
    WP1: FI Documents ]3000000000 - 3999999999[; MM Documents ]1700000000 - 1799999999[;]1900000000 - 1999999999[

  • Posting Key =
  • RHO: 21, 22, 24, 27, 29, 31, 32, 34, 37, 39
  • PF1: 21, 22, 31, 32
  • WP1: 21, 22, 24, 27, 29, 31, 32, 34, 37, 39
    Net Due Date:
    If Posting Date > Net Due Date => we take the <<Net Due Date>>
     If Posting Date < or =Net Due Date => we take the <<Calculated Payment Date>>
Specific Rules:
  • NAM: if <<Payment Method>> = T or P (WP1) or 1 (PF1) => real clearing date = Clearing Date - 2 working days
  • APAC: real Clearing Date = Clearing Date - 3 working days
  • Always considered as <<Paid On Time>> (At Due Date) if the calculation is <<Late>>:
    • Direct Debit: if <<Payment Method>> = P (WP1) or 5 (PF1)
    • Down Payment: if <<Document Type>> = KA
    • Self Billing: if transaction code = MRRL or MRIS or MRKO
    • Spain (PF1): if <<Payment Method>> = 2
    • Without Tax Obligation (PF1): if <<Document Type>> = S7
Specific Dimensions
VIP Supplier
Y/N (Vendor Attribute = VIP Vendor => Y=VIP ; N=#)
Internal Suppliers
Y/N (Vendor Attribute = Class => Y=G ; N=the rest)

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))