Dear Boopathirahaji

No sir, that is not the solution to my problem, simply I was given a ledger of a party( which is exported from tally) with criteria given.I was asked to calculate the Total discount amount that respective party is entitled with credit terms given i.e 15% on 15days payment received,10% on 30 days payment received and 0% when payment is received after 30 days.Manual working already I have shown there at Right Hand Side of 1st worksheet.

I have almost more than 400 parties for which I have to calculate the total discount amount based on credit terms of discount.
Amount is received might be bill to bill, advance,against the bill, on account,etc which perhaps need allocation.How you analyse would depends upon you.

This is the practical issue and strategy of any organisation for speeding up the collection of payment against sales bill drawn.

Hope you would solve the problem.

With Best Rgds,
Suresh