Cleaning up the Vendor Master File

Sort:
You are not authorized to post a reply.
Author
Messages
NBayless
New Member
Posts: 3
New Member
    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
      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


      You are not authorized to post a reply.