I have just done a huge vendor activity and vendor purge on our system. I just completed it this early this morning and so far everything looks great. I would just like to offer a few suggestions for any one who is thinking about doing one; do to the restrains I found in FE. First when doing a vendor activity purge make sure you do a pre purge report on all activity I saved this to a pdf file and wrote it to a cd so that we can open it in case vendors call down the road about anything that was purged. The only way to do a vendor purge is to purge all vendors created before a certain date. Dumb way to do it if you ask me because our electric company was created on the first day we started using BB and we still use them. The way I worked around this problem was I created a last payment date query on all vendors Solution number BB168176. Then I used this to give all vendors who had not been paid since June 30, 2004 an attribute, by importing to add this attribute. When I did the purge I put in the date of today’s date but then over road that date by selecting only vendors with that attribute. Also just because our A/P clerk ask for it I created a cash requirements report on all the checks paid before the June 30, 2004 date that was in check number order and gave all invoices paid by the check.I am not saying that my way is the best way to do a huge purge I am just offering a few suggestions that you won't find in the Knowledgebase or user guides.So happy purging to any one who has to do it.

Great Ideas. These are the kind of emails i file and use when the time comes. thanks again.

It may be too soon to ask, but have you noticed any quicker response times within FE since you purged all those records?

Great question I was just talking with A/P clerk and she said it was much faster. I have worked here since Nov 2002 and this is the first purge that has been done since then. We purged 3993 vendors, 55807 invoices, and 29741 checks. I also forgot another report I ran and saved prior to purge was a vendor profile report on this I told it to give summary info so it has a last payment date and amount on it.

This sounds like a great way to do it. is there any way you can walk me through creating the query? I have NO experience with building queries! Thanks! Charlotte Henning Asst Comptroller Museum of the Shenandoah Valley [Email Removed]

Sure. It would be easier for me to email step by step everything I did so send me your email address to [Email Removed].