Rejected payment with reason party_number already exists
I'm looking for a help on my rejected payment problem.
We imported payment spreadsheet and some payment requests are rejected with 'A record with the value PARTY_NUMBER already exists. Enter a unique value.' reason. The reason seems to not make sense that why can't we import payment for the same supplier again. However, when we re-submitted the payment with the rejected item without changing anything, those rejected payment sometimes are imported sometimes are rejected again. I don't understand the logic of this.
Has anyone experienced this problem and how did you resolve the issue?
Could you please advise where should we look into this issue?