You can use this detection method to find duplicate invoice items that have similar amounts. Specifically, this detection method looks for invoice items with the following characteristics; the invoice items:
Were booked in the same company code
Come from the same vendor
Have the same invoice date
Have the same line item number
Have the same reference invoice number
Have similar amounts
The amounts are similar if they do not differ by more than an amount that you specify as a detection method parameter. Currency conversion takes place to ensure the comparability of amounts.
You can restrict the invoice items that are evaluated by specifying upper and lower thresholds on the invoiced amount. You can also specify the type of invoice to be evaluated.
A detection result of 100 is returned for duplicate invoice items.
Investigation object type: FRA_VEND
(Vendor
)
Detection object type: FRA_VEINVI
(Vendor Invoice Item
)
BKPF
: Accounting Document Header
BSEG
: Accounting Document Segment
Procedure Category | Procedure Name | Procedure Type | Package |
---|---|---|---|
Selection |
| SQLScript Procedure |
|
Execution |
| SQLScript Procedure |
|
Additional Information |
| SQLScript Procedure |
|
Parameter | Meaning |
---|---|
| Lower limit for invoice item amounts that are evaluated by this detection method. Invoice items with lower amounts are ignored. |
| Currency in which |
| Upper limit for invoice item amounts that are evaluated by this detection method. Invoice items with larger amounts are ignored. |
| Currency in which |
| Absolute amount by which invoice item amounts may differ. Invoice items amounts that differ by less than this amount are considered similar. If the amounts are similar and other characteristics match, then the detection result is set to 100 for the pair of invoice items. |
| Currency in which |
| Specifies the document type of invoices ( |
Message ID FRA_INTERNAL_AUDIT
, message number 111, Similar invoice for ref. doc. no. &1 found on date &2 with amount &3 &4
The message variables are as follows:
&1
– Reference document (BKPF.XBLNR
)
&2
– Invoice date (BKPF.BLDAT
)
&3
– Risk amount (invoice amount from BSEG.WRBTR
)
&4
– Invoice currency (BKPF.WAERS
)