This document details the process to identify in PI1 all Bank Accounts not used in last 18th months to perform payments for PI1 companies 0231 - SOLVAY SA - TREASURY DPT and 4044 - Solvay Finance (America), LLC, Houston, TX |
This applies to all Company Codes operating under PI1 ERP System
SBS Data Operation Team is responsible for running the Transaction Z3F_VEN_BANKREP in PI1 ERP System, identifying all Vendor Bank Accounts not used for Payments in last 18th months and proceed with the respective removal of the same from the Vendor Accounts assigned.
SBS Data Operation Team need to execute this routine every quarter.
# | Main activities |
1 | Enter transaction Z3F_VEN_BANKREP |

# | Main activities | Tips / Best practices |
2 | Add the company code: | Please run individual report per Company Code |

# | Main activities | Tips / Best practices | Key points |
3 | Execute the transaction |
|
|

# | Main activities | Key points |
4 | Add a filter in column "Last Payment" | To identify the Bank Accounts by Payment Date |


# | Main activities | Tips / Best practices | Key points |
| 5 | Before remove the bank accounts, exclude the vendors from Aero Legacy A filter has been created 'To exclude from Mass Bank Cleansing' for easier access to the required list:
| column I | |
| 6 | Also exclude the following vendors:
| Exclude Country: TW, AU, BR, CL, CN, HK, ID, IN, JP, KR, MY, NZ, PA, PH, SG, TH, VN | |
7 | Extract Report and proceed in using the Process Runner to remove the identified Bank Accounts defined | PRS System |
|
| 8 | Create a ticket on the Freshdesk and attach the file with the extraction |