Prev
Next
Forums Financial Management Lawson S3 Financials

Vendors with no activity

 4 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
jacobske
New Member
Posts: 2
New Member
5/21/2010 4:00 PM
    We are trying to clean up our vendor master, In doing so we want to find vendors with no activity. I see there is no canned Lawson report for this - but in trying to create in crystal, we are a multi company facility - and using the APVENBAL table isnt proving to be that easy to use b/c it shows Last Payment date.
    I am sure there is a way to do this - but I am not a crystal expert by any means - so if anyone has done something similar to this, any information is greatly appreciated!
    TracyO
    Veteran Member
    Posts: 97
    Veteran Member
    5/21/2010 5:59 PM
      You could do something by including the APVENMAST table. Then create selections where apvenbal.LAST_PMT_DATEs = blank (or in my world 1/1/1800) and apvenmast.CREATE.DATE is < a certain date.
      Ruma Malhotra
      Veteran Member
      Posts: 412
      Veteran Member
      5/21/2010 7:18 PM
        Try the APINVOICE Table for particular vendors to see whether the create table is less than a particlar date.
        Ruma Malhotra
        Veteran Member
        Posts: 412
        Veteran Member
        6/11/2010 6:45 PM
          On the apvenbal there is a last purchase date field and a last payment field. If you query these 2 fields and both fields are null then there is no activity for the vendor.

          However there is a location code for the vendor which you may have to take into account to show vendor activity.


          Eddie Smith
          Advanced Member
          Posts: 39
          Advanced Member
          6/16/2010 6:18 PM
            We needed this also and created a SSRS report using the SQL below.

            SELECT APVENMAST.CREATE_DATE,
            APINVOICE.INVOICE,
            APVENMAST.VENDOR_VNAME,
            APVENMAST.VEN_CLASS,
            APVENMAST.VENDOR
            FROM APVENMAST left outer join
            APINVOICE on APVENMAST.VENDOR = APINVOICE.VENDOR and
            APVENMAST.VENDOR_GROUP = APINVOICE.VENDOR_GROUP
            WHERE APVENMAST.VENDOR_GROUP = 'ULNA'
            AND APINVOICE.INVOICE is null