What's new in Customer Journeys?

Connect and learn more!
Can anyone provide the SQL query that generate the Inactivate Supplier list — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can anyone provide the SQL query that generate the Inactivate Supplier list

Received Response
97
Views
13
Comments
edited Feb 8, 2024 3:58PM in Supplier Management 13 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!