How to Run an AP91 Query

1
How to Run an AP91 Query

• The AP91 Query should be run to see if an AR
  invoice has been input into AP20 and processed.

2
A new excel document should be opened, the Lawson
menu selection clicked, and the S3 Query Wizard
selected from the drop down menu.
3
Make sure the correct server, user, and password
are filled in. Click the Ok button.
4
Click on the yellow folder and locate where the
AP91 Query dme file has been saved.
5
Double click on the AP91 Query dme file.
6
Click on the Criteria tab.
7
Make sure the records to return field show 65520.
The Paid Doc Date can be changed by checking the
Edit Existing Selection Criteria Box and changing
the Date in the Criteria field. After all the
fields are changed, click the Finish button.
8
AP invoices and payments now appear as an excel
spreadsheet.