I need this ---
If any credit amount lies in the range of 1-30 days has to be shifted automatically to the range of 30-60 days as the days are advancing.
Thank you
Lenin
Hi Narayank991,
Thanks for your help.
column C which shows all zeroes that means there is no invoicing from 0-90 days.
I want to monitor the credit days per customer so that I can mobilize the payments without much delay
Please help
Hi Narayank991,
Thanks for your reply.
I think you might have seen my query. Please help me. here is my link
https://docs.google.com/spreadsheet/ccc?key=0AvZuBbi1tv17dGMtSXVzd05MaFZOb0dKa2ZneU0zenc
Dear Hui,
Thanks for your help.
I have pasted the link for my uploaded file, as you said. I want to monitor the credit days as the days are progressing to know the due of a particular customer on a particular period( or date). Please do the needful...
I need to prepare debtors list with recurring due dates. The credit period gave is 90 days from invoicing. I want to monitor the customers who fall in the category of below 90 days credit and who fall in category of above 90 days.
Please help me