Below are all information as you mention.
- Separate to 3 main cause of duplicate customers at JDE master file.
- Case no. 1-2 are biz need.
- Case no.3 is the case of the customer who lost contact with long time but the return to do biz with us again.
In case of the customer lost contact with us >2 year, we will put DA (Dormant Account Hold) at JDE master file for hold every new order.
But when the customer came to do biz with us again, we open new customer file again. (see n/a for Hold Code at JDE master file column).
For my suggestion
1. When the customer go to Dormant account, we will reduce their credit limit to 1 or 0 .
2. When new customer came to credit team, we will validate at Customer Name and Tax ID .
3. If we found the customer is Dormant Account, we will call old customer master file to update their information. (no open new master file)