Register    Login    Forum    Search    FAQ

Board index » Reports and Forms » Building Reports and Forms




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Account History not working well
 Post Posted: Wed Jul 04, 2012 10:05 am 
Offline

Joined: Mon Dec 14, 2009 5:47 am
Posts: 99
Hello Dave,

Thank you for all your support.
I have this challenge with Account history. I made a customer amount to read very high in million and the account history for current, 31-60, 61-90 and over 90 was showing the value in unit of thousands and not in millions.
why is it so?

thanks
popsicles1

attached is a printed statement.


Attachments:
stmt.jpg
stmt.jpg [ 23.88 KiB | Viewed 223 times ]
Top 
 Profile  
 
 Post subject: Re: Account History not working well
 Post Posted: Thu Jul 12, 2012 12:28 pm 
Offline

Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3499
Location: Colorado, US
I can't tell from what you posted. Take a look a the customers last 120 days in and Invoice history report and see if the numbers look correct. I would need your journal from the last 4 months to verify your findings.

Dave


Top 
 Profile  
 
 Post subject: Re: Account History not working well
 Post Posted: Fri Aug 10, 2012 11:27 am 
Offline

Joined: Mon Dec 14, 2009 5:47 am
Posts: 99
Hello Dave,

Thanks for your continued assistance.

attached is the invoice history of a customer.

expecting your reply soonest.

thanks

Popsicles1


Attachments:
INVOICE HISTORY REPORT.jpg
INVOICE HISTORY REPORT.jpg [ 39.17 KiB | Viewed 186 times ]
Top 
 Profile  
 
 Post subject: Re: Account History not working well
 Post Posted: Fri Aug 10, 2012 3:46 pm 
Offline

Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3499
Location: Colorado, US
What's the problem?


Top 
 Profile  
 
 Post subject: Re: Account History not working well
 Post Posted: Thu Sep 13, 2012 6:57 am 
Offline

Joined: Mon Dec 14, 2009 5:47 am
Posts: 99
Hello Dave,

The problem is this; If you look at the first PDF report I sent to you, you will discover that the aged history of Current, 31-60, etc is not equal to the Balance Due which is not supposed to be so.
You asked for the customer 120 days history, hence I printed the history of the customer and attached as the second attachment.
So what is wrong. Please let me know.

Thanks.

Popsicles1


Top 
 Profile  
 
 Post subject: Re: Account History not working well
 Post Posted: Wed Oct 03, 2012 12:40 pm 
Offline

Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3499
Location: Colorado, US
I can not make any sense out of this data. The first image has the aging in thousands, but the total in millions. The second image has the values in the hundred thousands. None of these make sense. On the customer statement, make sure that the starting amount reflects the accurate amount at the beginning of the range period. Also check to make sure you are filtering on a single customer. Next check the Customer Invoice History report with paid set to No for the customer to make sure everything matches up with what you expect.

The form was not designed for numbers as large as you are using. Try shrinking the font on the totals to allow for larger values. There may be an issue with the number exceeding the space allotted and wrapping.



Dave


Top 
 Profile  
 
Display posts from previous:  Sort by  
 
Post new topic Reply to topic  [ 6 posts ] 

Board index » Reports and Forms » Building Reports and Forms


Who is online

Users browsing this forum: Google [Bot] and 0 guests

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron