• Search Forums
    Advanced Search Topics Posts
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