SA Administrator Inactive Vendor Removal Report ranges and options

Ranges

See Reports - Ranges overview.

Options

Print Vendors With No Activity Since?

Specify a date to compare to the last purchase order date and last invoice date on Vendor Setup records.

Specify -1 to -7 in the day to go back up to 7 days. For example, specify **/-7/** to use the current date less 7 days for the date.

If the last purchase order date and last invoice date are less than or equal to the specified date, this information is included on the report:

  • Vendor number
  • Vendor name
  • Vendor status: Active or inactive
  • Vendor type
  • Vendor class
  • Balances: Current and on order
  • Last purchase order date
  • Whether the vendor record was inactivated or deleted by this process
Inactivate The Non-Active Vendors?

Select Yes to inactivate all vendors that qualify as being non-active. An active vendor is inactivated if these dates are less than or equal to the date in the Print Vendors With No Activity Since? option:

  • Last invoice date
  • Last purchase order date

Changing the status from active to inactive does not affect other financial processes. The vendor class remains the same.

Print Class 13 Vendors?

Select Yes to include active and inactive vendors that are currently classified as class 13.

Inactivate The Class 13 Vendors?

Select Yes to inactivate class 13 vendors that have an active status. Class 13 vendors are inactivated, regardless of any other criteria. The Vendor Setup information is included as described under the Print Vendors With No Activity Since option if the Print Class13 Vendors option is Yes.

Delete All The Inactive Vendors?

Select Yes to delete all inactive vendors from Vendor Setup and Vendor Invoice Center Entry under these conditions:

  • The last purchase order and last invoice dates must be less than the option one date.
  • The vendor on order balance must be zero.
  • The vendor RMA amount must be zero.
  • The vendor current balance must be zero.
  • The vendor rebates due balance must be zero.
  • No active history transactions can exist in Vendor Invoice Center Entry.
  • The vendor rebates due balance must be zero.
  • No active history transactions can exist in Vendor Invoice Center Entry.
Inact New Vendors W/O Activity For # Days

Use this option to exclude new vendor records that may otherwise qualify for deletion since a last purchase order or last invoice date does not exist. The last transaction date for the Vendor Setup is compares to the date that you specify.