Show TOC

 Detection Method: New Invoices to Inactive Vendors

 

This detection method lets you find invoices for vendors that had no invoices during the past x days, where x is defined by the input parameter MIN_DAYS_NO_ACTIVITY of the rule.

Detection Method based on SQLScript Procedure FRA_IA_PUR_V_II_N_A

Logic

For each vendor, the invoice with the latest date is selected. In a second step, the invoice before the last one is determined. The final step is to calculate the difference between the creation dates of the two invoices for the vendor (the most recent and the previous invoices). If the difference is equal to or larger than the threshold number of days in detection method parameter MIN_DAYS_NO_ACTIVITY, then an alert is raised. If the most recent invoice is also the first invoice created for a vendor, then no alert is raised.

The risk amount of an alert is defined as the sum of the values of the DMBTR field of the invoice items that are considered to be suspicious.

The method checks only invoices items that meet the following conditions:

  • The invoices are for regular vendors (not one-time account invoices)

  • The account type is set to K

  • The field SHKZG has value H.

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

  • LFA1: Vendor Master (General Section)

  • LFB1: Vendor Master (Company Code)

Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_360DAYS_NO_ACTIVITY_SELE

SQLScript Procedure

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

Execution

PR_360DAYS_NO_ACTIVITY_EXEC

SQLScript Procedure

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

Additional Information

PR_360DAYS_NO_ACTIVITY_ADDINF

SQLScript Procedure

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

  • MIN_DAYS_NO_ACTIVITY: Threshold for the minimum number of days of activity. An invoice that appears after longer inactivity than this threshold is considered suspicious.

Alert Messages

Message ID

Message Number

Message Text

FRA_INTERNAL_AUDIT

106

Vendor &1 had a new invoice

FRA_INTERNAL_AUDIT

107

The last posting to the account was on &1

Example

Business Rule “FRA_IA_PUR_V_II_NOAC”

Logic

For each vendor, the invoice with the latest date is selected. In a second step, the invoice before the last one is determined. The final step is to calculate the difference between the creation dates of the two invoices for the vendor (the most recent and the previous invoices). If the difference is equal to or larger than the threshold number of days in detection method parameter Min days without account activity, then an alert is raised. If the most recent invoice is also the first invoice created for a vendor, then no alert is raised.

The method checks only invoices items that meet the following conditions:

  • The invoices are for regular vendors (not one-time account invoices).

  • The field DebitCreditCodehas the value for the creditor.

Used Entities

  • DETECTION_OBJECT

  • VENDOR_INVOICE_ITEM

SAP HANA Vocabulary

  • Package: sap.hana-app.fra.suite.pur.dt.vendor.invoiceitem.dme

  • Name: VendorInvoiceItem.hprvocabulary

Detection Method Parameters

  • Min days without account activity (MIN_DAYS_WITHOUT_ACTIVITY)

    Threshold for the minimum number of days of activity. An invoice that appears after longer inactivity than this threshold is considered suspicious.

Risk Value

AmountInAlertCurrency: The Risk Value is the amount of the specific invoice in the alert currency.

Risk Value Currency

AlertCurrency: The Risk Value Currency is the Currency of the alert.

Additional Information

The alert shows the last posting to the account.