AP [message #386109] |
Thu, 12 February 2009 12:55 |
bharatt19
Messages: 7 Registered: February 2009 Location: banglore
|
Junior Member |
|
|
Detailed Problem Statement: 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
hye i have this requirement would any one please ans or gve the select query for this????
|
|
|
Re: AP [message #386129 is a reply to message #386109] |
Thu, 12 February 2009 17:16 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Your test would have been better if you had used the 'Spell-check Message' facility.
David
|
|
|