AP SUPPORT [message #386362] |
Sat, 14 February 2009 00:21 |
bharatt19
Messages: 7 Registered: February 2009 Location: banglore
|
Junior Member |
|
|
HYE FRNDS THIS MY REQUIREMENT 4M CUSTOMER please HELP ME OUT
We are in the process of cleaning up our supplier records. I would appreciate if there are any scripts available to identify no-activity suppliers since one year. This script output would help us inactivating the said suppliers.
no-active suppliers mean that we have not done any business with them since 1 year or so (no payment/invoices/PO etc..) The transactions should include PO, AP Invoices and Payments
ONLY SELECT STATEMENT FOR THIS
|
|
|