[Spce-user] Recalculating invoice

[Rene Krenn]

Invoices use cash_balance_interval (to avoid summing up costs in batch
processes). cash_balance is used in prepaid scenarios only and must be 0 for
postpaid customers.

so you could try to reset cash_balance_interval, or drop that month's
contract_balance record - it should be recreated with correctly initialized
values (carry-over, free time, ..).

 

Try it first with *one* customer only!

 

The re-rate use case is intended to be followed by a re-export of cdrs;
which implies generating invoices externally (hence not relying on
contract_balance records at all).

For upcoming ngcp versions, it is planned to introduce an additional re-rate
status which skips updating the contract balances (a second time).

 

regards

 

Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von
Koot Pienaar
Gesendet: Donnerstag, 14. September 2017 10:03
An: Spce-user at lists.sipwise.com
Betreff: [Spce-user] Recalculating invoice

 

Hi guys

 

So i had a typo on one of my ratings. When customer noticed i had to
regenerate invoice with correct values. After correcting the rates in my
billing profile, I changed rating status for calls with incorrect rates to
unrated in the database and waited for rate-o-mat to rerate calls. Calls
were rerated correctly but my invoice total was not recalculated when i
recreated the invoice.

 

I also tried to clear the contract cash balance in the cdr for that billing
period but it stays the same.

 

Please advise on how to go about corrctly rectifying invoices in situations
like this?

 

Regards 

 

Koot Pienaar

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20170914/47a5d34d/attachment-0001.html>