• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

credit period management

Gattulenin


You may want to think about providing some more data to allow us to assist with your problem


You can upload an example file, read here: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Hi ,


Use your favourite file-sharing website ( Rapidshare , Skydrive , Googledocs , Mediafire ,...) , give others access to your file , and post the access link here.


Narayan
 
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


https://docs.google.com/spreadsheet/ccc?key=0AvZuBbi1tv17dGMtSXVzd05MaFZOb0dKa2ZneU0zenc
 
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
 
Hi ,


I have downloaded your workbook , but am not clear on what you want to do.


You have a list of customers ( in column A ) along with two categories of amounts ; one is the credit amounts ( in columns D through I ) , and the other is the collection plan amounts ( in columns K through N ).


There is column C which shows all zeroes.


You have defined some terms such as :

[pre]
Code: 
Current means Stock value invoiced within 0-30 days
Credit Period  = 90 days
Credit days means number of days lapsed after 90 days of credit period
[/pre]
What exactly do you want to do in this worksheet ?


Narayan
 
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 ,


To change your profile picture , check out the following question :


http://chandoo.org/forums/topic/chandooorg-forum-avatars


Regarding your original question , things are still not clear ; which column do you want should be filled in using formulae ?


"I want to monitor the credit days per customer so that I can mobilize the payments without much delay" is the objective ; with specific reference to your workbook and to cells / columns / rows , can you explain what you need ?


Narayan
 
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
 
You must log in or register to reply here.
Back
Top