Show TOC

 Detection Method: Vendor Payments Too Early

 

You can use this detection method to find instances in which a vendor has been paid too quickly, relative to the agreed-upon payment terms. You can allow a grace period in days. Early payments are ignored if their earliness does not exceed the number of days in the grace period.

Detection Method based on SQLScript procedure FRA_IA_PUR_VEN_INV_ITEM

Logic

The invoice items that are processed must have a credit entry (in table BSEG field SHKZG = H). Also, for accounting type, in table BSEG field KOART = K), and the accounting key is of type credit memo, reverse invoice, invoice, and reverse credit invoice (table BSEG field BSCHL = 21 or 22 or 31 or 32).

The procedure works by calculating a tolerance date as the date on which an accounting document was entered (table BKPF field CPUDT) plus the largest cash discount days value minus the TOLERANCE_DAYS input parameter.

For returning results, this TOLERANCE_DATE is compared with the CLEARING_DATE. If the TOLERANCE_DATE is larger, then an alert is created.

Investigation and Detection Object Types

  • Investigation object type: FRA_VEND (Vendor)

  • Detection object type: FRA_VEINVI (Vendor Invoice Item)

ERP Tables Used

  • LFA1: Vendor Master (General Section)

  • LFB1: Vendor Master (Company Code)

  • BKPF: Accounting Document Header

  • BSEG: Accounting Document Segment

Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_VENDOR_INV_EARLY_PAYMENT_SELE

SQLScript Procedure

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

Execution

PR_VENDOR_INV_EARLY_PAYMENT_EXEC

SQLScript Procedure

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

Additional Information

PR_VENDOR_INV_EARLY_PAYMENT_ADDINF

SQLScript Procedure

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

  • TOLERANCE_DAYS: The minimum threshold for the number of days early that a payment has been made. If the earliness of the payment falls within this grace period, then the early payment is ignored.

Alert Messages

  • Message ID FRA_INTERNAL_AUDIT, message number 096, Invoice item was paid on the &1, &2 days earlier than the net due date &3