Process Effectiveness

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

Month Postpone

Net Due Date = M-1 last working day and Clearing Date = M 1st working day

#of Invoices In advance
-----------------------------------
Total Numbers of Invoices

WeekEnd 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

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:

2019:

• 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

2020:

• 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

  • Without Tax Obligation (PF1): if <<Document Type>> = S7

QlikSense Filter:

Remove PAX GBU and PAX Legal Entities

Late Posting

Invoices where:
Posting Date > Net Due Date

Core Query: BW_QRY_MV_APRS1_0004
QV Query: QVSBS_BW_QRY_MV_APRS1_0003B

[For more technical information]

Invoices Posted

Invoices posted on the reference date

%Late Posting

VIP Supplier

Y/N (Vendor Attribute = VIP Vendor => Y=VIP ; N=#)

Internal Suppliers

Y/N (Vendor Attribute = Class => Y=G ; N=the rest)

**Missing Dimensions from SBS_PtP

If you do not find the same dimensions you used to see in SBS_PtP, please refer here for details.