Vipulsharma
New Member
Hi All,
I have been a great fan of all your help regarding excels and want to solve some post dated credit notes given to parties in chemical industries, Please help me
Description of sheet:-
First column contains date of sale and voucher number and Column F contains credit note amount and Column N contains received amount as per credit in his account, we adjusts sale date with receipt date and calculate number of days our concern limits to total days pending as shown in column K from date of invoice to date of any credit in his account on which we apply Interest and further discounts, You are requested to please provide some formulae by which we can adjust payment against invoice.
File is attached for your reference
I have been a great fan of all your help regarding excels and want to solve some post dated credit notes given to parties in chemical industries, Please help me
Description of sheet:-
First column contains date of sale and voucher number and Column F contains credit note amount and Column N contains received amount as per credit in his account, we adjusts sale date with receipt date and calculate number of days our concern limits to total days pending as shown in column K from date of invoice to date of any credit in his account on which we apply Interest and further discounts, You are requested to please provide some formulae by which we can adjust payment against invoice.
File is attached for your reference