Delete

Tejaswini

Hi,

How to delete the records except first record based on document no

please suggest me the code

mohana_cse06

can you be more clear please.

Tejaswini

ok

mohana_cse06

remove this filter GenLine.SETFILTER("Account No.",GenLine."Account No.");
sort on vendor no and create a global variable called prevvendorno.
check in repeat statement that Prevvendorno is same as account no. of the genjnlline.
if yes then add the amounts and delete the line
if not assign account no. to prevvendorno.

Tejaswini

Thanks

Could you please tell me in writing the code

I have understand your logic , but I don't know how to write it properly

please suggest me the code

mohana_cse06

forum is to give suggestions only and not to write code for you.
please try yourself

Tejaswini

Thank you.

Kishorm

I totally agree with Mohana. There's a saying (not sure of the origin)...

"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"

...I believe Mibuso (a fantastic forum) is for teaching people how to fish - not giving them a fish