AP221 – Potential Duplicate Payments

System: Accounts Payable (AP)
Type: Batch program
Updates: 2 tables
References: 4 tables

AP221 (Potential Duplicate Payments) is a Lawson Accounts Payable batch program. It updates APINVOICE and CKPOINT and references APCOMPANY, APINVOICE, APVENGROUP and APVENMAST.

About AP221

Run the Potential Duplicate Payments (AP221) to list potential duplicate invoices. The report runs against invoices in all statuses. Use the Select tab to define parameters for the report. Use the Sort tab to define how invoices will be sorted on the report. **More information The program reports potential duplicate invoices of a company. Users have the option of including other parameters in determining potential duplicates and in what order they are sorted. The Select tab allows users to enter vendor, status, and invoice date range tofurther filter the records that will appear in the report. The invoices are sorted by vendors, and invoice amount as default. The Sort tab allows users to select additional criteria from which the invoices can be sorted. Users can enter values 1-9 for each criteria to indicate the sequence of how the invoices will be sorted. If left blank, the parameter will not be part of the key field in determining duplicates. For example, if PO number is left as blank but due date and invoice date has values, if there are two invoices with the same vendor, amount, invoice and due date but different PO numbers, this will be listed in the report as potential duplicate. If PO number has value under sort tab, the invoices will no longer be listed.

Updated files (2)

Table	Description	System
APINVOICE	Accounts Payable Invoice	AP
CKPOINT	No description in the Lawson data dictionary	—

Referenced files (4)

Table	Description	System
APCOMPANY	Accounts Payable Company	AP
APINVOICE	Accounts Payable Invoice	AP
APVENGROUP	Vendor Group	AP
APVENMAST	Vendor Master Record	AP

Program calls

Invoked programs (11)

ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU