The Suppliers Deactivation Report enables users to activate or deactivate vendors that do not have any purchasing or payment activity in the given time period.
Purchasing activity includes a supplier's purchase requisitions or purchase orders created or updated. This includes all documents even if they are not completed or approved.
Payment activity includes a supplier's invoices, debit memos, credit memos, payments, or refunds entered or updated.
The Suppliers Deactivation Report process includes these steps:
Users run the Suppliers Deactivation Report with the Deactivate Suppliers parameter set to No.
Users review the report and note the suppliers that should remain active.
Users rerun the Suppliers Deactivation Report with the Deactivate Suppliers parameter set to Yes.
Users navigate to the Supplier window and query the suppliers noted in Step 2 that should not be deactivated and delete the value in the Inactive On field.
To verify that the correct suppliers are deactivated, users run the Suppliers Deactivation Report with the Deactivate Suppliers parameter set to No.
The Deactivated Supplier Listing section displays the deactivated suppliers.
To run the Suppliers Deactivation Report:
In the Request Name field, select Suppliers Deactivation Report.
In the Operating Unit field, select an operating unit.
In the Supplier Name From field, optionally select a supplier name designating where to begin report generation for the range of suppliers.
In the Supplier Name To field, optionally select a supplier designating where to end report generation for the range of suppliers.
Note: Users can enter a value in Supplier Name From field without having to enter a value in the Supplier Name To field. Users select the default value in the Supplier Name To field and delete it.
In the Date Since No Activity field, enter a begin date for reporting suppliers without any activity.
Note: The current system date is the end date for reporting suppliers with no activity.
To review the list of suppliers with no activity, select N in the Deactivate Suppliers field.
To deactivate suppliers:
Repeat Steps 1 through 5from the Viewing the Suppliers Deactivation Report.
In the Deactivate Suppliers field, select Y.
To reactivate suppliers:
In Payables, navigate to the Suppliers window.
In the Inactive On field, delete the value.
The following table describes the Suppliers Deactivation report.
Column | Description |
---|---|
Supplier Name | Vendor name |
Supplier Num | Number assigned to vendor |
Site | Supplier site |
Days Since Last Activity | Number of days without activity; calculated by the report program |
Date of Last Activity | Date of last invoice, purchase order, requisition, or payment |
Supplier Name | Vendor name |
Supplier Num | Number assigned to vendor |
Site | Supplier site |
Date Deactivated | Date supplier deactivated. The system enters the current system date as the inactivate date for any suppliers picked up by the report.
Note: All supplier sites must be deactivated before the system deactivates a supplier. |