check duplicate paid

[sagaraperera]

I want check duplicate claim paid in same amount of one claim no in several times.

sagara

[maxgro]

in script you can use a group by claim (CLNO?) and amount ([CLAIM PAID]?) to check if the same amount was paid for the same claim in distinct dates

load CLNO, [CLAIM PAID], count(distinct DATE)

resident yourtable

group by  CLNO, [CLAIM PAID]