Can anyone provide the SQL query that generate the Inactivate Supplier list
We are trying to Inactivate suppliers with no transactions for the past 24 months. Unfortunately, we are not clear on what transactions are being considered. Our payables have concerns if the last payment was also considered. The generated list of suppliers only have the column of created date. Having the sql query on hand will validate the concern. Thanks.
0