2 Problems with Statements

[gsahai]

Hi,

 

Most of our customers like us to keep a running tab for them, and send them monthly statements, which, sometimes they'll clear in full, and sometimes do a part-payment against.

 

PROBLEM 1:

If I do a customer statement today, it shows the credits and debits for that month and a final amount due as of the statement creation date. IT DOES NOT SHOW A BALANCE CARRIED FORWARD FROM THE PREVIOUS MONTH. Without that number, the "final amount due" figure on the statement does not reflect the balance of the credits and debits of that particular month, and consequently, does not appear to make sense to the customer reading that statement.

Eg., a statement for Nov may read:

 

Total Invoices $500

Total Payments $300

Current Balance $330

 

(In this example, a balance of $130 was being carried forward from the month of Oct into Nov. This balance is not being reflected in the statement separately but is taken into account while calculating the Current Balance, which can be confusing).

 

PROBLEM 2:

The Current Balance reflected in the statement is the actual balance reflected ON THE DAY THE INVOICE IS CREATED, AND NOT THE BALANCE AS OF THE END OF THE STATEMENT PERIOD. This can be a challenge at times when we take an order, on let's say the 1st of the month, and get down to processing the statements only later in the day on the 1st. In this case, the order taken on the 1st of the month will not reflect in the statement for the last month, but the Current Balance amount will. This can also be a problem if a customer asks us to send us a statement for a previous period and they've been placing orders after the end of that statement period.

 

Many thanks to anyone who can help us solve these 2 issues.

 

Gaurav

[Solidrave]

Gaurav regarding Current Balance try:

 

1) Open Customers List

2) Double-click on the customer in question

3) Select the Info tab

4) Click on Recalculate Balance

 

Solidrave