Versions Compared

Old Version 4

changes.mady.by.user Karina Keiko Tsuji

Saved on

compared with

New Version Current

changes.mady.by.user Karina Keiko Tsuji

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Info
titleProcess Owner
Diogo Paiva
Laure Imberti

Process Expert
Info
titleD&PS 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 :
  • ZI Partner
  • Ship to Group
  • GBU
  • Zone
    Sales Office
  • Sales Office
    Zone

Image Modified
 Date
 Date Reference:
BILLING DOCUMENT CREATION DATE

Billing Document Creation Date
       
 Image Modified 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
 Image Added 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)
Image ModifiedINTRA ENTERPRISE FLAG = N
Image ModifiedINTRA GROUP FLAG = N
Image ModifiedORDER LINE ITEM CATEGORY CODE <> ZZZZ
Image ModifiedORDER FLOW CODE = D/C
Image ModifiedLEGAL COMPANIES <> 7378
Image ModifiedDISTRIBUTION CHANNEL <> 8I
BI4 Filters
(Root Cause)
Image ModifiedLEGAL COMPANIES <>ZFR9/7378
 Image ModifiedDISTRIBUTION CHANNEL <> 8I
Image ModifiedPAYER SL CODE = 72944/73842/74094/74149/75150/74468/74513/74873/75125/75170/75192/76220/76461/76538/76921/77322/
77358/77599/77874/82069/84269 or
Image ModifiedPAYER GROUP CODE <> GRCL200022
Image ModifiedINTRA ENTERPRISE FLAG = N
Image ModifiedORDER FLOW CODE = D
Image ModifiedORDER REASON CODE <> 920/969/930/931/935
Image ModifiedORDER LINE ITEM CATEGORY CODE = ZZZZ (CANCELLED IN SAP)
Image ModifiedORDER DOCUMENT TYPE <> ZCO/ZCR/ZCSQ/B1
Specific Dimensions
Sales Office
 
CS Motive