Show TOC

 Detection Method: Manual Payment to a Vendor

 

You can use this method to determine whether manual payments – that is, payments outside the ERP system – have been made to a vendor.

Logic

The execution procedure selects all invoices that have posting key = 21 or 22 or 31 or 32, accounting type K, and a clearing document number. The document number, company code, fiscal year, and item number must be the same as from the input data set.

The execution procedure then checks whether any of the invoices were manually paid. That is, the payments are of accounting type K, the posting key = 25. The payments also must not have been done using transaction code F110. All invoices that were paid manually are reported with a score of 100.

Investigation and Detection Object Types

  • Investigation object type: FRA_VEND (Vendor)

  • Detection object type: FRA_VEINVI (Vendor Invoice Item)

ERP Tables Used

  • BKPF: Accounting Document Header

  • BSEG: Accounting Document Segment

  • T001: Company Codes

SAP HANA Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_MANUAL_PAYMENT_SELE

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.vendor.invoiceitem.se

Execution

PR_MANUAL_PAYMENT_EXEC

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.vendor.invoiceitem.ex

Additional Information

PR_MANUAL_PAYMENT_ADDINF

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.vendor.invoiceitem.ai
Detection Method Parameters

None

Alert Messages

  • Message ID FRA_INTERNAL_AUDIT, message number 089, The outgoing payment was posted on &1 by user &2

  • Message ID FRA_INTERNAL_AUDIT, message number 090, Payment document number &1 / fiscal year &2 / company code &3