The system provides several preliminary steps, before the actual deletion, to ensure that the supplier you want to delete is the correct one. These include:
- Creating a proposal, listing the suppliers that can more than likely be deleted.
- Maintaining the proposal, which gives you the option to remove those suppliers you do not want to delete
The system also performs a check before the deletion, to ensure that the supplier can be deleted. The system checks that the following is true for the supplier:
- no purchase orders exist
- no purchase statistics exist
- no serial number records exist
- no open A/P transactions exist
Note: If any of these exist for the supplier, the supplier will not be deleted.
For this example you will run through each step prior to the actual deletion.
- Select the Create business partner reorg proposal menu item.
- You access Business partner file reorg proposal crt. Note: Only one proposal can exist at one time. If you create a new proposal, the previous proposal is deleted.
- Creation date <
- All suppliers that were entered into the system before this date will be included in the proposal.
- Type
- Indicate the type of business partners that should be included in the selection. If this field is left blank, all types will be included in the deletion proposal. Valid codes are:
- Only inactivated
- This field is set to YES by default, meaning only the inactivated suppliers shall be included in the selection. For this example, set this field to NO. Tip: Use the Inactivate/Activate options on the Work with business partners panel.
- Print list (deleted)
- This field is set to YES by default. For this example, keep this setting meaning the proposal should be printed listing those suppliers that are to be deleted. As mentioned earlier, only those suppliers that are valid for deletion (according to the system check) will be included in the selection.
- Print list (not del)
- As an extra security, you can print a list displaying only those suppliers you want to delete but should not be deleted because they have transactions connected to them (e.g., included in an open purchase order). This field is set to NO by default. For this example, set it to YES.
- Select the Work with business partner file reorg proposal menu item.
- You access Business partner file reorg proposal mnt, listing only those suppliers that can be deleted (that were on the first list). Scroll to view all. You have two options. You can:
- Remove the suppliers from the list that you do not want to delete. If several pages of suppliers exist you remove the ones you want, one page at a time. Select those you want to delete and click OK.
- Accept all suppliers shown for deletion. Click OK.
- Select the Reorganise business partner file menu item.
- You access Business partner file reorganisation, where you perform the actual deletion of the suppliers from the Business partner file according to the proposal you have created and maintained. Before deleting, the same check, as described above, will be performed. If any of those prerequisites are not true, the supplier will not be deleted. Click OK. A list will be printed with the deleted suppliers.
On this panel you select the suppliers you want to delete via the selection parameters below:
Code | Description |
---|---|
1 | Customer |
2 | Suppliers |
3 | Both customers and suppliers |
9 | Other |
Proposal output
This proposal will create two separate lists: one listing those suppliers that can be deleted and one listing those that cannot be deleted.
Complete the printing parameter fields on the bottom of the panel and click OK or press F2 if authorised.
You can now maintain the created proposal.
You are now ready to physically delete the suppliers from the Business partner file.
Related topics
- About working with suppliers
- Set up a new template and default for a supplier
- Automatically generate field values for your suppliers
- Restrict the use of a supplier template
- Add a new supplier
- Add a supplier by copying an existing
- Print a supplier list
- Create a business partner structure for your suppliers