Laure Imberti
Process Expert
Miriam Luttrin
General Description
  This indicator explore the number of original invoices, postinvoices and percentage on invoicing accuracy, in other words, how much re-work (debit/credit) Customer & Service process is taking from invoices.
 Indicator details results can be analyzed by :
  • GBU
  • Zone
  • Sales Office

 Date Reference:
Billing Document Creation Date
       
  Refresh Frequency:
Daily 
KPI Name
Calculation
#of Original Invoices
Original Invoices refer to invoices without debit/credit invoices, returns, accounting corrections:
Number of invoices where Billing Flow Code = C and Billing Document Type Code]<>REB;S1;RE
#of Postinvoicing
Postinvoices refer to credit invoices, returns, accounting corrections:
 Number of invoices where Billing Document Type Code = ZG2;S1;G2B;ZS1;RE;ZS4;REB;G2
%Invoicing Accuracy
(#of Original Invoices - #of Postinvoicing)*100
--------------------------------------------------------------------
----------------#of Original Invoices
  Target: 98%
#Debit & Credit Notes
Number of debit and credit note
Debit & Credit Notes (KCURR)
Debit and credit note value (K€/K$)
#Debit & Credit Notes by motives
If([Order Reason Code]="962";"WRONG PRODUCT";If([Order Reason Code]InList("966";"909");("CUSTOMER'S ERROR");If([Order Reason Code]InList("963";"956";"960");"ADMIN ERROR";If([Order Reason Code]InList("903";"904");("COMPLAINT QUALITY");If([Order Reason Code]InList("952";"958");"WRONG PRICE";If([Order Reason Code]="951";"WRONG CUSTOMER";"JUSTIFIED (Business Reasons)"))))))
Source Information:
QV Query:
BI4: QV_SBS_GLOBAL_MACRO_KPI_INVOICING_ACCURACY_CSWWPPS_R001
BI4 (Root Cause)NB SBS DEBIT CREDIT NOTES CWWPPS R001 
BI4 Filters
(Invoicing Accuracy)
INTRA ENTERPRISE FLAG = N
INTRA GROUP FLAG = N
ORDER LINE ITEM CATEGORY CODE <> ZZZZ
ORDER FLOW CODE = D/C
LEGAL COMPANIES <> 7378
DISTRIBUTION CHANNEL <> 8I
BI4 Filters
(Root Cause)
LEGAL COMPANIES <>ZFR9/7378
 DISTRIBUTION CHANNEL <> 8I
PAYER SL CODE = 72944/73842/74094/74149/75150/74468/74513/74873/75125/75170/75192/76220/76461/76538/76921/77322/
77358/77599/77874/82069/84269 or
PAYER GROUP CODE <> GRCL200022
INTRA ENTERPRISE FLAG = N
ORDER FLOW CODE = D
ORDER REASON CODE <> 920/969/930/931/935
ORDER LINE ITEM CATEGORY CODE = ZZZZ (CANCELLED IN SAP)
ORDER DOCUMENT TYPE <> ZCO/ZCR/ZCSQ/B1
Specific Dimensions
Sales Office
 
CS Motive