I
inspirz
Hi,
Ok here's the scenario:
I have a database:
Column A: is unique TRANSACTION NUMBER
Coumn B: is VALUE ($)
Column C: is a the Payment ID (it can be a DEALER PAYMENT, or a CHARGE-BACK
or SYSTEM REVERSAL, et cetera)
Column D: Dealer ID Number
Ok here's the problem and I hope I explain this clearly:
Our company is paying duplicate dealer payments and/or chargebacks and I
need to distinguish which are the real dupes versus legitimate dupes.
so for example - in the scenario below - TRANSACTION NUMBER 12345 had 1
duplicate payment because scenario A1 and A2 cancel each other out ($40 -$40)
therefore you have 2 payments of $40 when a dealer can only be paid 1 time.
How can I create a query to show me only legitimate dupes?
Column A1: 12345
Column B1: $40
Column C1: " Dealer Commission Payment"
Column D1: 5555
Column A2: 12345
Column B2: (-$40)
Column C2: "Dealer Commission Chargeback"
Column D2: 5555
Column A3: 12345
Column B3: $40
Column C3: "Dealer Commission Payment"
Column D3: 5555
Column A4: 12345
Column B4: $40
Column C4: "Dealer Commission Payment"
Column D4: 5555
Ok here's the scenario:
I have a database:
Column A: is unique TRANSACTION NUMBER
Coumn B: is VALUE ($)
Column C: is a the Payment ID (it can be a DEALER PAYMENT, or a CHARGE-BACK
or SYSTEM REVERSAL, et cetera)
Column D: Dealer ID Number
Ok here's the problem and I hope I explain this clearly:
Our company is paying duplicate dealer payments and/or chargebacks and I
need to distinguish which are the real dupes versus legitimate dupes.
so for example - in the scenario below - TRANSACTION NUMBER 12345 had 1
duplicate payment because scenario A1 and A2 cancel each other out ($40 -$40)
therefore you have 2 payments of $40 when a dealer can only be paid 1 time.
How can I create a query to show me only legitimate dupes?
Column A1: 12345
Column B1: $40
Column C1: " Dealer Commission Payment"
Column D1: 5555
Column A2: 12345
Column B2: (-$40)
Column C2: "Dealer Commission Chargeback"
Column D2: 5555
Column A3: 12345
Column B3: $40
Column C3: "Dealer Commission Payment"
Column D3: 5555
Column A4: 12345
Column B4: $40
Column C4: "Dealer Commission Payment"
Column D4: 5555