[freeside] Incorrect Customer Balances

[Peter Kolbe]

That is similar to my problem I had yesterday.

I deleted entries manually from the cust_pay table in the db, but I did not 
delete the corresponding entries from the cust_bill_pay !

My symptoms were:
Open invoices did not show open,
when I went to the invoice, I got an error
When I viewed the customer, it showed open balances.

Hope that helps

Peter
----- Original Message ----- 
From: "James McDonald" <james at homelandinternet.com>
To: <ivan-freeside at sisd.com>
Sent: Thursday, May 26, 2005 6:45 PM
Subject: [freeside] Incorrect Customer Balances


> In Freeside 1.5Pre6, we have some customer accounts that are showing  very 
> strange balances. In the billing history, the latest invoice  shows as 
> Open with a balance equal to 2 months of service. When the  invoice is 
> viewed, however, it shows a $0 balance. The total balance  in the billing 
> history shows about 2 months worth of service  outstanding, but if you go 
> to the Post Credit or Post Payment screen,  it again shows $0 balance. 
> I've verified the charges and credits to  the account and the account 
> should show a $0 balance. Why is the  total of the Balance column and the 
> status of the last invoice not  showing correctly?
>
> 

--------------------------------------------------------------------------
The information transmitted is intended only for the person to whom it is 
addressed and may contain confidential and/or privileged material.

Although SCDS / Venturenet scans incoming and outgoing emails and email 
attachments for viruses we cannot guarantee a communication to be free of 
all viruses nor accept any responsibility for viruses. 

Although SCDS / Venturenet monitors incoming and outgoing emails for 
inappropriate content, we cannot be held responsible for the views or 
expressions of the author. 

The views expressed may not necessarily be those of SCDS / Venturenet and 
as such, cannot be held responsible for any loss or injury resulting from 
the contents of a message. 
--------------------------------------------------------------------------