• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

Cleaning up the Vendor Master File

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
NBayless
New Member
Posts: 3
New Member
New Poster
8/25/2020 5:24 PM
Hello, I have been in this position for almost 2 years and now it's time to clean up our vendor master file. The last time they did it here was 2015, and it was apparently a complete disaster, as many active vendors were inactivated. The query they used apparently was not accurate (maybe user error), I don't know.

I can't find a query that can give me a list of active vendors and their last payment made. Does anyone have any thoughts or screen shots of a query that could help with this?

Thanks!

Neal
dcaiani
Veteran Member
Posts: 52
Veteran Member
Helpful Replier
New Poster
Engaged Poster
Engaged Reader
Avid Reader
11/16/2020 3:13 PM
Hi Neal,
We do this quarterly. I have a series of queries (3) that I run in MS Access using the APVENMAST and APVENBAL tables. APVENBAL has two fields of interest, LAST_PMT_DATE and LAST_PUR_DATE.

Step 1 selects the active vendors from one of two vendor groups that are not in two of the vendor classes.
Step 2 Groups al the fields selected in step 1 except for the LAST_PMT_DATE and LAST_PUR_DATE, for those two fields I take the max
Step 3 then selects the data fro step 2 with a criteria that I define each quarter for the max of the two "LAST" fields.

Hopefully this makes sense.
Dave