Show TOC

 Detection Method: Purchase Order Overpaid

 

You can use this detection method to find cases in which the amount paid in an invoice is greater than the amount shown in the relevant purchase order item.

Logic

The method compares the amount in the purchase order item with the amount in the invoice. If the invoiced amount is higher than the amount in the purchase order item, then the purchase order item is suspicious.

For the comparison, the amounts in the purchase order item and the invoice recipient are converted into the currency of the company code. The net values of the invoice recipient are then added up according to the debit/credit sign in the record. Any credit is subtracted from the debit, and the real amount in the invoice document is determined.

Similarly, the net value of the purchase order item is calculated with respect to the invoiced quantity, so that the amounts are compared using the same quantity (here, the quantity in the invoice). The net values are then aggregated per purchase order item. The amounts are then compared and the result is evaluated against the threshold amount/currency and threshold percent (defined by the user) that indicate how much the amount in the invoice may exceed the amount in the purchase order item to which it is being compared. The risk amount is then the difference between the invoice amount and the purchase order amount.

Note Note

  • The currency conversion uses the standard conversion at average type of type M and the business document dates of the purchase order and invoice.

  • The functionality is restricted to purchase order items of the category Standard (PSTYP = 0).

  • Amount values (that is, the purchase order item net value, the invoice net value, and the risk value) are rounded to two decimal places.

End of the note.
Investigation and Detection Object Types

  • Investigation object type FRA_PO (Purchase Order)

  • Detection object type FRA_POITEM (Purchase Order Item)

ERP Tables Used

  • EKKO: Purchasing Document Header

  • EKPO: Purchasing Document Item

  • RSEG: Document Item: Incoming Invoice

  • T001: Company Codes Tables for the currency conversion (TCUR…)

SAP HANA Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_PURCHASE_ORDER_AMOUNT_SELE

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.purchaseorder.item.se

Execution

PR_PURCHASE_ORDER_AMOUNT_EXEC

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.purchaseorder.item.ex

Additional Information

PR_PURCHASE_ORDER_AMOUNT_ADDINF

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.purchaseorder.item.ai
Detection Method Parameters

  • THRESHOLD_AMOUNT: Indicates how much larger the amount in the invoice may be in comparison to the amount in the corresponding purchase order item. A smaller difference between invoice and purchase order amounts does not trigger an alert. All amounts are converted into the currency of the company code so that the amounts are compared in the same currency.

  • THRESHOLD_CURRENCY: Is the currency of the threshold amount.

  • THRESHOLD_PERCENTAGE: Indicates how much larger in percent the amount in the invoice may be in comparison to the amount in the purchase order item.

Alert Messages

  • Message ID FRA_INTERNAL_AUDIT, message number 065, Ordered amount &1 &2 < invoiced amount &3 &4 in accounting document(s)