version: 7.5 user guide...ap mm and sap po overview rs_ap_po_acc note the ap verified invoices per...

Kofax Performance AnalyticsUser GuideVersion: 7.5

Date: 2020-12-29

© 2012–2020 Kofax. All rights reserved.

Kofax is a trademark of Kofax, Inc., registered in the U.S. and/or other countries. All other trademarksare the property of their respective owners. No part of this publication may be reproduced, stored, ortransmitted in any form without the prior written permission of Kofax.

Table of ContentsPreface.......................................................................................................................................................... 9

About this guide..................................................................................................................................9Related documentation.....................................................................................................................10

Chapter 1: Accounts Payable (AP) reports............................................................................................11AP Account Overview.......................................................................................................................12

Query filters............................................................................................................................13Key figures.............................................................................................................................13Free characteristics................................................................................................................13

AP Aging Since Entry.......................................................................................................................15Query filter............................................................................................................................. 16Key figures.............................................................................................................................16Free characteristics................................................................................................................16

AP Approved FI documents............................................................................................................. 18Query filters............................................................................................................................19Key figures.............................................................................................................................19Free characteristics................................................................................................................20

AP Automatisation rate MM documents.......................................................................................... 21Query filters............................................................................................................................22Key figures.............................................................................................................................22Free characteristics................................................................................................................23

AP Automatisation rate of FI WC determination..............................................................................24Query filters............................................................................................................................25Key figures.............................................................................................................................25Free characteristics................................................................................................................26

AP Automatisation Rate Documents................................................................................................27Query filters............................................................................................................................28Key figures.............................................................................................................................28Free characteristics................................................................................................................28

AP Discount Overview......................................................................................................................30Query filters............................................................................................................................31Key figures.............................................................................................................................31Free characteristics................................................................................................................32

AP Document Overview................................................................................................................... 33Examples................................................................................................................................34

3

Kofax Performance Analytics User Guide

Query filters............................................................................................................................36Key figures.............................................................................................................................36Free characteristics................................................................................................................36

AP Document process timing...........................................................................................................38Query filters............................................................................................................................39Key figures.............................................................................................................................40Free characteristics................................................................................................................40

AP Document Volumes.................................................................................................................... 41Examples................................................................................................................................42Query filters............................................................................................................................43Key figures.............................................................................................................................43Free characteristics................................................................................................................44

AP Error Overview............................................................................................................................46Query filter............................................................................................................................. 47Key figure...............................................................................................................................47Free characteristics................................................................................................................47

AP Event Transitions........................................................................................................................48Query filter............................................................................................................................. 49Key figures.............................................................................................................................49Free characteristics................................................................................................................49

AP FI Doc Approvers Header Data................................................................................................. 51Query filters............................................................................................................................52Key figures.............................................................................................................................52Free characteristics................................................................................................................52

AP FI Document Approvers............................................................................................................. 53Query filter............................................................................................................................. 54Key figure...............................................................................................................................54Free characteristics................................................................................................................54

AP Message Log..............................................................................................................................55Example................................................................................................................................. 56Key figure...............................................................................................................................57Free characteristics................................................................................................................57

AP No Matched Suppliers................................................................................................................58Example................................................................................................................................. 59Query filters............................................................................................................................60Key figure...............................................................................................................................60Free characteristics................................................................................................................60

AP Not Posted FI documents.......................................................................................................... 61

4


Example................................................................................................................................. 62Query filters............................................................................................................................63Key figures.............................................................................................................................64Free characteristics................................................................................................................64

AP Open and not approved FI documents......................................................................................66Example................................................................................................................................. 66Query filters............................................................................................................................67Key figures.............................................................................................................................68Free characteristics................................................................................................................68

AP Open approved FI docs without complete account assignment................................................ 70Query filters............................................................................................................................71Key figure...............................................................................................................................71Free characteristics................................................................................................................71

AP Payment Discount Analysis........................................................................................................72Example................................................................................................................................. 73Query filters............................................................................................................................73Key figures.............................................................................................................................74Free characteristics................................................................................................................74

AP PO Rate Versus FI.....................................................................................................................75Query filters............................................................................................................................76Key figures.............................................................................................................................76Free characteristics................................................................................................................77

AP Posted invoices per user........................................................................................................... 78Example................................................................................................................................. 80Query filters............................................................................................................................80Key figures.............................................................................................................................80Free characteristics................................................................................................................81

AP Processing Times....................................................................................................................... 82Query filters............................................................................................................................83Key figures.............................................................................................................................83Free characteristics................................................................................................................84

AP Status Transitions.......................................................................................................................85Query filters............................................................................................................................86Key figures.............................................................................................................................86Free characteristics................................................................................................................87

AP Verified invoices per user...........................................................................................................88Query filters............................................................................................................................89Key figures.............................................................................................................................89

5


Free characteristics................................................................................................................90AP Work Cycle Processing Times................................................................................................... 90

Query filter............................................................................................................................. 91Key figures.............................................................................................................................91Free characteristics................................................................................................................91

AP Workflow Resource Analysis......................................................................................................93Query filter............................................................................................................................. 94Key figure...............................................................................................................................94Free characteristics................................................................................................................95

AP MM and SAP PO Overview....................................................................................................... 95Restrictions.............................................................................................................................96Query filters............................................................................................................................96Key figures.............................................................................................................................97Free characteristics................................................................................................................97

Chapter 2: Accounts Payable (AP) OCR reports.................................................................................100AP OCR Document Statistics........................................................................................................ 100

Query filter........................................................................................................................... 101Key figures...........................................................................................................................101Free characteristics..............................................................................................................102

AP OCR Field Statistics................................................................................................................. 103Query filter........................................................................................................................... 104Key figures...........................................................................................................................104Free characteristics..............................................................................................................104

AP Docs with manual interaction within Verify.............................................................................. 105Query filters..........................................................................................................................106Key figures...........................................................................................................................106Free characteristics..............................................................................................................107

Chapter 3: Accounts Receivable (AR) reports.....................................................................................109AR Document Overview................................................................................................................. 109

Query filters..........................................................................................................................110Key figures...........................................................................................................................110Free characteristics..............................................................................................................111

AR Electronic Bank Statement Document Overview..................................................................... 112Query filters..........................................................................................................................113Key figures...........................................................................................................................113Free characteristics..............................................................................................................113

AR Item Overview.......................................................................................................................... 114Query filters..........................................................................................................................115

6


Key figures...........................................................................................................................115Free characteristics..............................................................................................................115

AR Customer Analysis................................................................................................................... 116Query filters..........................................................................................................................117Key figures...........................................................................................................................117Free characteristics..............................................................................................................117

AR State Transition........................................................................................................................ 118Query filters..........................................................................................................................119Key figures...........................................................................................................................119Free characteristics..............................................................................................................120

AR Process Analysis...................................................................................................................... 120Query filter........................................................................................................................... 121Key figures...........................................................................................................................121Free characteristics..............................................................................................................122

AR Processing Times.....................................................................................................................122Query filters..........................................................................................................................123Key figures...........................................................................................................................123Free characteristics..............................................................................................................124

AR Processing Time until Posting..................................................................................................124Query filters..........................................................................................................................125Key figures...........................................................................................................................125Free characteristics..............................................................................................................125

AR Processing Time until Clearing................................................................................................ 126Query filters..........................................................................................................................127Key figures...........................................................................................................................127Free characteristics..............................................................................................................127

AR Age Unprocessed Documents................................................................................................. 128Query filters..........................................................................................................................129Key figures...........................................................................................................................129Free characteristics..............................................................................................................129

Chapter 4: Generic Kofax Process Director (PD) reports...................................................................131PD Document Overview................................................................................................................. 131

Query filters..........................................................................................................................132Key figure.............................................................................................................................132Free characteristics..............................................................................................................132

PD Posted Documents................................................................................................................... 133Query filter........................................................................................................................... 134Key figure.............................................................................................................................134

7


Free characteristics..............................................................................................................135PD Document Volumes.................................................................................................................. 135

Query filter........................................................................................................................... 136Key figure.............................................................................................................................136Free characteristics..............................................................................................................136

PD Posted Documents in Workflow...............................................................................................137Query filter........................................................................................................................... 138Key figure.............................................................................................................................138Free characteristics..............................................................................................................138

PD Workflow Processing Time.......................................................................................................139Query filter........................................................................................................................... 140Key figures...........................................................................................................................140Free characteristics..............................................................................................................140

Chapter 5: Sales Order (SO) reports.................................................................................................... 142SO Workflow Resources................................................................................................................ 142

Query filters..........................................................................................................................143Key figures...........................................................................................................................143Free characteristics..............................................................................................................144

SO Item Processing Issues............................................................................................................144Query filter........................................................................................................................... 145Key figure.............................................................................................................................145Free characteristics..............................................................................................................145

SO Message Overview...................................................................................................................146Query filters..........................................................................................................................147Key figures...........................................................................................................................147Free characteristics..............................................................................................................148

SO Item Overview.......................................................................................................................... 149Query filters..........................................................................................................................150Key figures...........................................................................................................................150Free characteristics..............................................................................................................151

SO Currently Running Workflow.................................................................................................... 152Query filters..........................................................................................................................153Key figures...........................................................................................................................153Free characteristics..............................................................................................................154

SO Document Overview.................................................................................................................155Query filters..........................................................................................................................156Key figures...........................................................................................................................156Free characteristics..............................................................................................................156

8

Preface

Continuous process performance improvement is a hallmark for the sustainable success of anyorganization, but it is both challenging and expensive without access to real information that is deliveredin a format that easily enables analysis. SAP Business Warehouse (BW) is the tool of choice for manyorganizations, and Kofax’s BW solution, Kofax Performance Analytics, makes it easier, faster andless expensive to report on and improve the accounts payable, accounts receivable and sales orderprocesses.

For customers using SAP NetWeaver Business Warehouse, Kofax offers a suite of flexible componentsand reports integrated into SAP and BW to intelligently analyze, evaluate and report on businessperformance. Customers can use these data warehouses and accelerator components to gather, analyzeand report on the information acquired during the capture and approval processes, using their BWsolutions.

The Performance Analytics solution is tightly integrated with Kofax Process Director Accounts Payable(formerly known as the Invoice Cockpit Suite) and with Process Director Accounts Receivable and SalesOrders and comes complete with ready-to-go reports, data models, extractors and transformations, tosignificantly reduce implementation time and costs. The solution is extensible, web-enabled and providesan integrated view of corporate data.

Performance Analytics is available in the following languages:• English• German• Dutch• French• Spanish• Portuguese• Italian

About this guideThis guide provides information about the standard reports delivered with the Performance Analyticssystem. It assumes that you are already familiar with SAP NetWeaver Business Warehouse, ProcessDirector Accounts Payable, and Process Director.

Please note that this guide is available only in English.

This guide contains the following topics:• Preface

Provides an overview of Performance Analytics, as well as information about the data extraction andaggregation processes.

9


• Accounts Payable (AP) reportsProvides detailed information about the standard AP reports delivered with Performance Analytics.

• Accounts Payable (AP) OCR reportsProvides detailed information about the standard AP OCR reports delivered with PerformanceAnalytics.

• Accounts Receivable (AR) reportsProvides detailed information about the standard AR reports delivered with Performance Analytics.

• Process DirectorProvides detailed information about the generic PD reports delivered with Performance Analytics.

• Sales Order (SO) reportsProvides detailed information about the standard SO reports delivered with Performance Analytics.

Related documentationSee the following Performance Analytics guide:• Kofax Performance Analytics Installation and Configuration Guide

Describes how to install and configure Performance Analytics.

For more information about Kofax Process Director Accounts Payable and Process Director, see thefollowing guides:• Kofax Process Director Accounts Payable Configuration Guide• Kofax Process Director Accounts Payable User Guide• Kofax Process Director Configuration Guide• Kofax Process Director User Guide

10

Chapter 1

Accounts Payable (AP) reports

Performance Analytics provides the following standard Accounts Payable reports.

Accounts Payable (AP) report Query name

AP Account Overview RS_AP_ACCOUNT_OVERVIEW

AP Aging Since Entry RS_AP_AGING_SINCE_ENTRY

AP Approved FI documents RS_AP_APPROVED_DOCUMENTS

AP Automatisation rate MM documents RS_AP_AUTOMATISATION_RATE_MM

AP Automatisation rate of FI WC determination RS_AP_AUTOM_FI_WC_DETER

AP Automatisation Rate Documents RS_AP_AUTOMATISATION_RATE

AP Discount Overview RS_AP_DISCOUNT_OVERVIEW

AP Document Overview RS_AP_DOCUMENT_OVERVIEW

AP Document process timing RS_AP_DOC_PROC_TIME

AP Document Volumes RS_AP_DOCUMENT_VOLUMES

AP Error Overview RS_AP_ ERROR_OVERVIEW

AP Event Transitions RS_AP_EVENT_TRANSITIONS

AP FI Doc Approvers Header Data RS_AP_FI_DOC_APPROVERS_HEADER

AP FI Document Approvers RS_AP_FI_DOCUMENT_APPROVERS

AP Message Log RS_AP_MESSAGE_LOG

AP No Matched Suppliers RS_AP_NO_MATCHED_SUPPLIERS

AP Not Posted FI documents RS_AP_NOPOSTEDFI

AP Open and not approved FI documents RS_AP_NOTAPPROVED_FI

AP Open approved FI docs without complete accountassignment

RS_AP_FI_WO_COMPL_ASSIGNM

AP Payment Discount Analysis RS_AP_PAYMENT_DISCOUNT

AP PO Rate Versus FI RS_AP_PO_RATE_VS_FI

AP Posted invoices per user RS_AP_POSTED_INV

AP Processing Times RS_AP_PROCESSING_TIMES

AP Status Transitions RS_AP_STATUS_TRANSITIONS

AP Verified invoices per user RS_AP_VERIFIED_INV

Work Cycle RS_AP_WC_PROCESSING_TIME

11


Accounts Payable (AP) report Query name

AP Workflow Resource Analysis RS_AP_WF_RESOURCE_ANALYSIS

AP MM and SAP PO Overview RS_AP_PO_ACC

Note The AP Verified invoices per user report is valid only for those companies that run the OCRintegration with Kofax Invoices.

AP Account Overview

Query name

RS_AP_ACCOUNT_OVERVIEW

Summary

This report displays information about the general ledger accounts, cost centers and profit centers thathave been used (for both posted and unposted documents).

Report user

Accounts Payable Manager

Questions the report can answer• Which general ledger accounts have been used most?• What amount has been booked to a particular general ledger account?• Which cost centers have incurred the highest costs?

12


Query filtersName Filter type Description Default value

Reporting Date Query variable Selects a specific date forreporting.

Current date

Target Currency Default value The document currencyis converted into thiscurrency.

Defined by customizing inthe Currency Conversionobject.

DB Status Indicator Fixed value This flag marks records aseither active (A) or deleted(D) in the source system.

A

Key figuresName Technical name Description

Net Amount in Document Currency /EBY/DOCNETAM The net amount of the invoice in thedocument currency.

Net amount in target currency EBY_LOCNETAM The net amount in the targetcurrency. It is calculated from theexchange rate by using the CurrencyConversion Date of the document.

Gross Amount in Document Currency /EBY/DOCGROSS The gross value of the invoice in thedocument currency.

Gross amount in target currency EBY_LOCGROSSAM The gross amount converted tothe report-specific currency. Thiscurrency can be selected in thereport selection screen and is bydefault filled with the configured localcurrency.

Counter /EBY/COUNTER The number of documents.

Free characteristicsName Technical name Description

G/L Account Number /EBY/SAKNR The General Ledger account number.

Source system ID 0SOURSYSTEM The ID of the SAP system that thedocument is located in.

AP Account /EBY/APACCIT This characteristic contains themaster data for account lines. Thefield itself contains the uniqueidentifier created in ERP. It iscompounded to the document GUID(/EBY/APUNDOC).

AP Document Number /EBY/DOCNO The Process Director documentnumber.

13


Name Technical name Description

AP Unique Document /EBY/APUNDOC This characteristic contains themaster data for invoice documents.The field itself contains the globallyunique identifier for the document.

Business Area /EBY/GSBER The organizational FI unit.

Company Code /EBY/BUKRS The internal SAP number of thebuying organization.

Cost Center /EBY/COSTCTR The buying organizational unitresponsible for costs.

Currency Conversion Date /EBY/CONVDATE At query runtime, this date is used toconvert currencies. If the documentis already paid, the payment date isused. Until payment, the current dateis used.

Document Currency /EBY/DOCCURR The currency used in the document.

FI / MM Document /EBY/FI_MM_FL The type of document:FI = without purchase orderMM = with purchase order

PD Document Type /EBY/ICDOCTYP The Process Director document type.

Invoice Flag /EBY/DINV_IND Indicates whether the document is aninvoice or a credit note:X = Invoice# = Credit note

Origin of Document /EBY/DORIGIN The way the document enteredProcess Director. For example, viaOCR/Invoices, the IDoc interface,Web Board, or another system.

Plant /EBY/WERKS The production facility within thecompany code. In Accounts Payable,this is usually the receiver of thegoods.

Profit Center /EBY/PROFCTR The buying organization unit forwhich the operating results aregenerated.

SAP Document Type /EBY/DOC_TYPE The SAP document type used tocreate the posted document.

Vendor /EBY/LIFNR The name of the vendor who issuedthe document.

WBS Element /EBY/WBS_ELEM Work Breakdown Structure element -a task within a project, to which costscan be assigned.

14


AP Aging Since Entry

Query name

RS_AP_AGING_SINCE_ENTRY

Summary

This report sorts documents into day intervals, based on the number of days since the document enteredProcess Director Accounts Payable. By default, the report displays only those documents that have notyet reached a final state (deleted, paid, or rejected). The day intervals can be customized in the /EBY/CONFIG transaction, as an OLAP evaluation. For more information, see the Performance AnalyticsInstallation and Configuration Guide.

Report user


Questions the report can answer• How many documents are above the defined thresholds for processing?• For which vendors do we cross those thresholds?

15


Query filterName Filter type Description Default value


Current date


Document Count /EBY/COUNTER Displays the number of documents.

Average Aging Since Entry Calculated key figure Average number of days sincedocument entry.



16





Document Status /EBY/STATUS The Process Director documentstatus.

Final AP Status /EBY/APFINSTA Flag that indicates whether adocument has reached a final stateor not. A final state is deleted, paid,or rejected.





Origin of Document /EBY/DORIGIN The way the document enteredProcess Director. For example,through OCR/Invoices, the IDocinterface, Web Board, or anothersystem.


FI / MM Doc /EBY/FI_MM_FL The type of document:FI = Without purchase orderMM = With purchase order

Document Creator /EBY/DOCCRUSR The SAP user ID of the documentcreator

Document Processor /EBY/DOCPRUSR The last SAP processor to work onthe document.

Calendar Year/Month 0CALMONTH The month and year. This is basedon the month and year in which thedocument entered Process Directorand the date of the first documentversion.

Cal. Year/Quarter 0CALQUARTER The quarter (Q1/Q2/Q3/Q4) and year.This is based on the quarter andyear in which the document enteredProcess Director and the date of thefirst document version.

17



Calendar Day 0CALDAY The date (dd.mm.yyy). This is basedon the date on which the documententered Process Director and thedate of the first document version.

Calendar month 0CALMONTH2 The month in which the documententered Process Director.

Calendar Year 0CALYEAR The year in which the document firstentered Process Director.

Calendar Year/Week 0CALWEEK The week and year. This is basedon the week and year in which thedocument entered Process Directorand the date of the first documentversion.

AP Approved FI documents

Query name

RS_AP_APPROVED_DOCUMENTS

Summary

This report displays all the approved FI documents for each business area, and by document processors.

Report user


Questions the report can answer• How many FI documents were posted on a given date?• From which vendor were most documents posted?• For which business area were most documents approved?

18




Current date




Gross amount in Document Currency /EBY/DOCGROSS The gross value of the invoice in thedocument currency.

Gross amount in target currency EBY_LOCGROSSAM The gross amount converted intothe report-specific currency. Thiscurrency can be selected in thereport selection screen and is bydefault filled with the configured localcurrency.

# Posted None Number of posted FI documents.

# Approved in WF None Number of FI documents posted afterworkflow approval.

# Not approved in WF None Number of FI documents postedwithout workflow approval.

19





Calendar year/quarter 0CALQUARTER The quarter (Q1/Q2/Q3/Q4) and year.This is based on the quarter andyear in which the document enteredProcess Director and the date of thefirst document version.


Calendar year 0CALYEAR This is the year in which thedocument first entered ProcessDirector.









20



Posting Date /EBY/BUDAT The date on which the document wasposted.



AP Automatisation rate MM documents

Query name

RS_AP_AUTOMATISATION_RATE_MM

Summary

This report shows the number of MM invoices that were posted automatically by the system. Automaticpostings can occur in different ways; for example, upon receipt, or via the Repetitor program. You cantherefore see how efficient your processing of MM documents is, and how many documents have requireda manual posting.

Report user

Accounts Payable Manager, Process Director Administrator

Question the report can answer• How many MM documents have been posted automatically?

21




Current date

Company Code Query variable Selection on multiple singlecompany codes.

[blank]

Interval Calmonth Query variable Query variable to set areporting interval in thecalendar month.

[blank]


Total MM /EBY/COUNTER The total number of MM documents.

Automated MM None The total number of MM documentsposted automatically by the system.

Automatisation Rate None The percentage of the total numberof automated MM documents.

22





Calendar Year/Week 0CALWEEK The week and year. This is basedon the date on which the documententered Process Director and thedate of the first document version.

Calendar Year/Month 0CALMONTH The month and year. This is basedon the date on which the documententered Process Director and thedate of the first document version.

Calendar year/quarter 0CALQUARTER The quarter (Q1/Q2/Q3/Q4) and theyear. This is based on the date onwhich the document entered ProcessDirector and the date of the firstdocument version.


Currency Conversion Date /EBY/CONVDATE The date when the amount wasconverted into the local (display)currency.





Payment Block /EBY/SPERZ A block that prevents the invoice frombeing paid.

Payment Method /EBY/PYMTMETH How the payment is made. Forexample: bank transfer, check.

23



Posting User /EBY/POSTUSR The SAP user who posted thedocument or the user configuredfor automatic posting, if the postingwas performed by the system (forexample, automatic posting upondocument receipt).

Posting Date /EBY/BUDAT The date the document was posted.

Process Type /EBY/PROCTYPE The method by which the documentwas processed:Not assignedPerformPostCreate document out of SAPdocument (document import)

Posting Way /EBY/POSTWAY The interface used for posting.Usually signifies the type of invoicedocument:1 – FI2 – Not assigned3 – MM logistical invoice validation

Posting Type /EBY/POSTTYPE The origin of the document posting:1 (Online) – Manual posting by a user2 (Submit) – Automatic posting onreceipt, and parked documentssubsequently posted in SAP3 (Repetitor) – Posted usingRepetitor4 (Work Cycle) – (Not used)5 (EDI Cockpit) – (Not used)6 (Import) – PD document createdfrom SAP document



Terms of Payment /EBY/DZTERM The ID of the payment terms.

AP Automatisation rate of FI WC determination

Query name

RS_AP_AUTOM_FI_WC_DETER

24


Summary

This report displays the rate of workflows for FI documents that were started automatically, as opposed tothose manually started by SAP users.

Report user


Question the report can answer• How many FI workflows were started automatically?



Current date

Last WF Flag Fixed value Set to X for the currentlyrunning or last workflow.For old workflows, it is setto false (space).

X


[blank]

FI / MM Document Fixed value The type of document:FI = without purchase orderMM = with purchase order

FI

Company Code Query variable Filters the query on aspecific company code.

[blank]


Total FI /EBY/COUNTER The number of FI documents.

25



Sent by OPS User /EBY/COUNTER Filter on /EBY/WCINIUSR using theEBY_CM_AUTOUSER_OPS queryvariable. Workflows initiated by thebackground user.

Not sent by OPS User None Total FI - Sent by OPS User.Workflow started manually by anSAP user.

Automatisation None The percentage of workflows forFI documents that were startedautomatically (sent by OPS user /total FI x 100).





Calendar year 0CALYEAR The year in which the document firstentered Process Director.






26





AP Automatisation Rate Documents

Query name

RS_AP_AUTOMATISATION_RATE

Summary

This report shows the number of invoices that were posted automatically by the system. Automaticpostings can occur in different ways; for example, upon receipt, or via the Repetitor program. You cantherefore see how efficient your processing of documents is, and how many documents have required amanual posting.

Report user


Question the report can answer• How many documents have been posted automatically?

27




Current date


[blank]


[blank]

FI / MM Document Fixed value The type of document:FI = without purchase orderMM = with purchase order

FI & MM


Total MM + FI None The sum of the number of MM and FIdocuments.

Automated Total None The sum of automated FI and MMdocuments.

Automated MM /EBY/COUNTER The number of automated MMdocuments.

Total FI /EBY/COUNTER The total number of FI documents.

Total MM /EBY/COUNTER The total number of MM documents.

Automated FI /EBY/COUNTER The number of automated FIdocuments.

Automatisation Rate FI None The percentage of automated FIdocuments in relation to the totalnumber of FI documents.

Automatisation Rate MM None The percentage of automated FIdocuments in relation to the totalnumber of MM documents.

Automatisation Rate FI + MM None The percentage of automated FI andMM documents in relation to the totalnumber of documents.



28













Payment Block /EBY/SPERZ A block that prevents the invoice frombeing paid.

Payment Method /EBY/PYMTMETH How the payment is made. Forexample: bank transfer, check.

29



Posting User /EBY/POSTUSR The SAP user who posted thedocument or the user configuredfor automatic posting, if the postingwas performed by the system (forexample, automatic posting upondocument receipt).

Posting Date /EBY/BUDAT The date the document was posted.



Process Type / EBY/PROCTYPE The method by which the documentwas processed:Not assignedPerformPostCreate document out of SAPdocument (document import)



Terms of Payment /EBY/DZTERM The ID of the payment terms.

AP Discount Overview

Query name

RS_AP_DISCOUNT_OVERVIEW

30


Summary

Similar to the AP Workflow Resource Analysis report, RS_AP_DISCOUNT_OVERVIEW provides anoverview of the discounts gained and lost.

Report user

Accounts Payable Manager, Chief Financial Officer

Questions the report can answer• How much money was saved because invoices were paid early?• How much money was lost because invoices were not paid before the due date?• What discounts were gained and lost for the ZB01 payment terms?



Current date

Document Status Fixed value The Process Directordocument status.

Paid (3)

Document Currency Default value The currency used in thedocument.

Must not be empty


Invoices paid /EBY/COUNTER Number of invoices that have beenpaid.

Cash discount amount in documentcurrency

/EBY/WSKTO The reduction in the selling price.This is allowed in cases where thepayment is made within a stipulatedperiod (as agreed upon with thevendor).

Gained discount amount in documentcurrency

/EBY/SKGAINED The actual discount received. It couldbe equal to the cash discount amountor less, depending on when theinvoice is paid.

31



Lost discount amount in documentcurrency

/EBY/SKLOST This is calculated as the maximumavailable discount minus the gaineddiscount (cash discount – gaineddiscount).

Gross Amount in Document Currency /EBY/DOCGROSS The gross value of the invoice in thedocument currency.


Cash Discount Amount in targetCurrency

None The discount that was givenconverted into the report-specificcurrency.

Discount gained in target currency None The total discount gained convertedinto the document-specific currency.

Discount lost in target currency None The total amount of discount that waslost converted into the report-specificcurrency.

Relative Discount Loss None The relative lost discount comparedto the total gross amount.

Relative Discount Gain None The relative gain of discountcompared to the total gross amount.



Terms of payment /EBY/DZTERM The ID of the payment terms.


Calendar Day 0CALDAY The day on which the invoice wascleared (paid).

Calendar month 0CALMONTH2 The month in which the invoice wascleared (paid).

Calendar year 0CALYEAR The year in which the invoice wascleared (paid).

Calendar Year/Week 0CALWEEK The week and year in which theinvoice was cleared (paid).

Calendar Year/Month 0CALMONTH The month and year in which theinvoice was cleared (paid).

32



Calendar year/quarter 0CALQUARTER The quarter (Q1/Q2/Q3/Q4) and yearin which the invoice was cleared(paid).







AP Document Overview

Query name

RS_AP_DOCUMENT_OVERVIEW

Summary

This report provides an overview of the total number of documents and their amounts at specified dates.

Report user

Chief Financial Officer

Questions the report can answer• How many posted and unposted documents are in the system?• Which of these unprocessed documents contain/are free of errors?

33


Examples

How many posted and unposted documents are in the system?The number and volume of posted documents are displayed in the initial query:

To view the number and volume of unposted documents, select the following filters for the documentstatus:

34


These document statuses are different unposted documents. (The Deleted and Rejected statuses havenot been selected because it is assumed that these documents are no longer relevant.)

The Overall Result row displays the total number and volume for unposted documents:

How many unposted documents contain errors?The number and volume of documents with errors are displayed in the initial query:

35




Current date




Document count /EBY/COUNTER The number of documents.

Gross amount in document currency /EBY/DOCGROSS The gross value of the invoice in thedocument currency.

Net amount in document currency /EBY/DOCNETAM The net amount of the invoice in thedocument currency.


Net amount in target currency EBY_LOCNETAM The net amount converted intothe report-specific currency. Thiscurrency can be selected in theselection screen and is by defaultfilled with the configured localcurrency.





Calendar year 0CALYEAR This is the year in which thedocument first entered ProcessDirector.

36








User ID: Creator of Document /EBY/DOCCRUSR The SAP user ID of the documentcreator.






Last change date The date on which the document waslast changed and/or saved.


37








AP Unique Document /EBY/APUNDOC Global unique document ID to identifythe document.


AP Document process timing

Query name

RS_AP_DOC_PROC_TIME

Summary

This report displays the dates and times for the document processing steps such as Scan, Transfer,Workflow, Approval and Posting. The times indicated are absolute times, not the working times.

38


Report user


Questions the report can answer• When was the document scanned in Kofax Invoices?• When did the document enter Process Director?• When was the document sent to a workflow for the first time?• When was the document approved?• How long does it takes from scanning to posting in SAP?



[blank]

Vendor Query variable Selection on multiplevendors.

[blank]

Reporting Period Query variable Selects a specific period forreporting.

Last 14 days

39



Scantime, Date None The date on which the document wasscanned in Invoices.

Scantime, Time None The time at which the document wasscanned in Invoices.

Transfertime, Date None The date on which the documentwas transferred into Process DirectorAccounts Payable.

Transfertime, Time None The time at which the document wastransferred into Process DirectorAccounts Payable.

WC sent time, Date None The date on which the document wassent to a workflow for the first time.

WC sent time, Time None The time at which the document wassent to the workflow for the first time.

Approved time, Date None The date on which the document wasapproved.

Approved time, Time None The time at which the document wasapproved.

Posting time, Date None The date on which the document wasposted in SAP.

Posting time, Time None The time at which the document wasposted in SAP.

Total Duration h None Total processing time in hours.

min None Total processing time in minutes.




Calendar Year / Month 0CALMONTH The month and year. This is basedon the month and year in which thedocument entered Process Directorand the date of the first documentversion.

40



Calendar year / quarter 0CALQUARTER The quarter (Q1/Q2/Q3/Q4) and year.This is based on the quarter andyear in which the document enteredProcess Director and the date of thefirst document version.




Calendar Year / Week 0CALWEEK The week and year. This is basedon the week and year in which thedocument entered Process Directorand the date of the first documentversion.




AP Document Volumes

Query name

RS_AP_DOCUMENT_VOLUMES

Summary

This report displays how many documents are currently in Process Director and what statuses they have.

Report user


Questions the report can answer• How many documents are currently in Process Director?• What is the split between FI and MM documents?• Which company codes are the documents for?

41


• What are the current statuses of the documents?

Examples

How many documents are currently in Process Director?The report opens displaying the number of documents currently in Process Director. This includes alldocuments, posted or otherwise. The volume of documents will increase every month, until an archive isperformed.

How many documents are posted or in a workflow?Apply the Posted or Work Cycle document status filters to see the number and value of documents forthose statuses:

42




Current date




Document count /EBY/COUNTINV The number of documents.

Net amount in target currency /EBY/NETAMINV The net amount converted intothe report-specific currency. Thiscurrency can be selected in theselection screen and is by defaultfilled with the configured localcurrency.

Gross amount in target currency /EBY/GROSSINV The gross amount converted intothe report-specific currency. Thiscurrency can be selected in thereport selection screen and is bydefault filled with the configured localcurrency.

43



Document Count: Change None The difference in the number ofdocuments from the previous monthto the current one.

Document Count: In /EBY/COUNTIN The number of documents that havecome into the system in the currentmonth.

Document Count: Out /EBY/COUNTOUT The number of documents that havegone out of the system in the currentmonth (archived).

Net amount change in local currency /EBY/DOCNETAM The net amount of the invoice in thedocument currency.

Gross amount change in localcurrency

/EBY/DOCGROSS The gross value of the invoice in thedocument currency.








Calendar year/month 0CALMONTH The month and year. This is basedon the month and year in which thedocument entered Process Directorand the date of the first documentversion.


44













45






AP Error Overview

Query name

RS_AP_ERROR_OVERVIEW

Summary

This report provides an overview of the errors contained in documents.

Report user:


Questions the report can answer• What are the most common errors that have occurred?• In which part of the document have these errors occurred?• What type of document was most affected?• What is the origin of the affected document?

46




Last 14 days

Key figureName Technical name Description

Message Counter None The number of checks.












47




Internal Field Name /EBY/FIELDSAP The Process Director or SAP internalfield name.


Item Number /EBY/POSNUM The line item number.


Process Type /EBY/PROCTYPE The process category that the errorbelongs to (for example: Check, Post,Received).



Structure Error Appeared /EBY/ERRSTRUC The structure in which the errorappeared; for example, header, item,tax, check data.

Value Check Type /EBY/CHECKTYP The description of the error type (forexample: document already exists,price deviation).


AP Event Transitions

Query name

RS_AP_EVENT_TRANSITIONS

Summary

This report displays the duration it took for a document to move from any selected Entry status to any Exitstatus.

Report user


48


Questions the report can answer• What is the number of days it took for a document to move from the Entry status to the Exit status?• What is the average number of days it took for the document to move from the Entry status to the Exit

status?



Last 14 days


Average Transition Time (Days) None The average number of days it tookfor the document to move from theEntry status to the Exit status.

Transition Time (Days) None The number of days it took for thedocument to move from the Entrystatus to the Exit status.

Document Counter /EBY/COUNTER The number of documents.



AP Event Timestamp /EBY/APEVENTS Indicates the date and time of theevent.


Calendar year / quarter 0CALQUARTER The quarter (Q1/Q2/Q3/Q4) and year.This is based on the quarter andyear in which the document enteredProcess Director and the date of thefirst document version.

49




Calendar Month 0CALMONTH2 The month in which the documentfirst entered Process Director.


Calendar Year / Week 0CALWEEK The week and year. This is basedon the week and year in which thedocument entered Process Directorand the date of the first documentversion.

Calendar Year / Month 0CALMONTH The month and year. This is basedon the month and year in which thedocument entered Process Directorand the date of the first documentversion.


Direct Transition Flag /EBY/APEDTRAN This flag indicates the directtransition between the Start and EndEvents.X = Direct transition# = Indirect transition

End Event /EBY/APEVENT End Event: Possible Entries:Interpret, Verify, Transfer, InvoiceCockpit Entry, Post, Pay, Reject,First Error, Last Error, Approval, FirstWorkflow Entry, First Workflow Exit,Last Workflow Entry, Last WorkflowExit

End Event is the Last Event /EBY/APEVLAST This flag indicates if the Event is thelast one.X = Last Event# = Not the Last Event



50







Start Event /EBY/APEVENST The Event from which thetransitioned document is coming.

Start Event is the First Event /EBY/APEVFIRS This flag indicates if the Start Event isthe first Event or not.X = Start Event is the first Event# = Start Event is not the first Event


AP FI Doc Approvers Header Data

Query name

RS_AP_FI_DOC_APPROVERS_HEADER

Summary

This report displays all the FI documents that have been approved, as well as the corresponding grossamounts in document and local currencies. It is also used as a jump target for the FI Document approvers(RS_AP_FI_DOCUMENT_APPROVERS) query.

Report user

Key Account Manager, Accounts Payable Manager

Questions the report can answer:• What is the gross amount cumulated for a specific vendor?• What is the gross amount for approved FI documents for a specific company code?

51




Last 14 days

Target Currency Query variable Currency every amountshould be converted intowhile viewing the report.

Configured local currency


Gross amount in document currency /EBY/DOCGROSS The gross value of the invoice in thedocument currency.

Gross amount in target currency EBY_LOCGROSSAM The gross amount converted tothe report-specific currency. Thiscurrency can be selected in thereport selection screen and is bydefault filled with the configured localcurrency.





52




AP FI Document Approvers

Query name

RS_A