Supplier Master Data Cleaning
Dear All
My client has one requirement where we need to undertake the supplier master data cleaning projects to rectify for duplicate supplier records, Incorrect bank details etc.
We had some solution workshops and one of the solution under discussion is about putting an end date to all the supplier and upload the new supplier feed with good record. However I have severe concern on this solution as to how we will manage the open transaction on those existing supplier record for which we are proposing to put an end date.
Can you please place your views on this and would be great if can suggest some good options of data cleaning methods ?