<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;
color:black;}
span.E-MailFormatvorlage21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.E-MailFormatvorlage22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.E-MailFormatvorlage23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.E-MailFormatvorlage24
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1555458708;
mso-list-type:hybrid;
mso-list-template-ids:1722713920 560077396 201785347 201785349 201785345 201785347 201785349 201785345 201785347 201785349;}
@list l0:level1
{mso-level-start-at:3;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-font-family:Calibri;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=DE-AT link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Thx4re, makes absolute sense. We had to clarify if this was related to recent changes/fixes in the rating engine.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Regarding your situation and billing profile packages, as you correctly found out<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><span style='mso-list:Ignore'>-<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Packages are the dedicated feature to use dynamic balance intervals (eg. required to bill prepaid per voucher top-up period)<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><span style='mso-list:Ignore'>-<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>They also are the dedicated option to use balance intervals other than „1 month“; eg. some customers are required to drive billing runs in<o:p></o:p></span></p><p class=MsoListParagraph><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>strict 30day intervals, or align to 1st of month etc.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Packages are proven to work, what you experienced here is just an unfinished leftover when the billing package feature was introduced.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>There weren’t any changes on those parts recently.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Right now, the month selector in the UI form for creating an invoice addresses the regular „1month“ intervals, as in use w/o packages.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>The db queries behind fetches the first contract balance that is *<b>fully</b>* enclosed by the picked month, which works for „1month“ intervals starting on 1st of month (thats also how you fixed it).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>For packages the plan was to explicitly pick from exisiting balance intervals records, but that didnt made it for a final requirement yet.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>So you can continue to use packages, but for now if invoice creation is obligatory, the intervals should be kept „1 month“ and starting at „1st of month“.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Also be aware when changing the blance records‘ start and end fields manually in the database, the remaining fields are not adjusted. There is the risk it screws up<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>in other use cases (like changing the contract‘s package/profile) and apart of that this particular invoice pdf will most likely not show correct information.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Will create a ticket to address the issue by introducing a better invoice period selection method in the UI form+api, so it can also work for dynamic intervals of packages.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Btw. since you seem to use it in real life, suggestions are welcome.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>regards<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'>Von:</span></b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'> Henk [mailto:henk@voipdigit.nl] <br><b>Gesendet:</b> Dienstag, 5. Dezember 2017 09:23<br><b>An:</b> Rene Krenn <rkrenn@sipwise.com>; spce-user@lists.sipwise.com<br><b>Betreff:</b> Re: AW: [Spce-user] Error generating invoice<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p>Hi Rene,<o:p></o:p></p><p>I have been using them just as an experiment and all that was left over was the balance period not starting at the beginning of the month. I changed the dates in records 453 and 519. I'm not sure when the problem started, I started with a 4.x version.<o:p></o:p></p><p><tt><span style='font-size:10.0pt'>| 372 | 2017-02-13 03:00:00 | 2017-02-13 03:59:59 |</span></tt><span style='font-size:10.0pt;font-family:"Courier New"'><br><tt>| 373 | 2017-02-13 04:00:00 | 2017-02-13 04:59:59 |</tt><br><tt>| 374 | 2017-02-13 05:00:00 | 2017-02-13 05:59:59 |</tt><br><tt>| 375 | 2017-02-13 06:00:00 | 2017-02-13 06:59:59 |</tt><br><tt>| 376 | 2017-02-13 07:00:00 | 2017-02-13 07:59:59 |</tt><br><tt>| 377 | 2017-02-13 08:00:00 | 2017-02-13 08:59:59 |</tt><br><tt>| 378 | 2017-02-13 09:00:00 | 2017-02-13 09:59:59 |</tt><br><tt>| 379 | 2017-02-13 10:00:00 | 2017-02-13 10:59:59 |</tt><br><tt>| 380 | 2017-02-13 11:00:00 | 2017-03-13 10:59:59 |</tt><br><tt>| 389 | 2017-03-13 11:00:00 | 2017-04-13 10:59:59 |</tt><br><tt>| 399 | 2017-04-13 11:00:00 | 2017-05-13 10:59:59 |</tt><br><tt>| 409 | 2017-05-13 11:00:00 | 2017-06-13 10:59:59 |</tt><br><tt>| 417 | 2017-06-13 11:00:00 | 2017-07-13 10:59:59 |</tt><br><tt>| 426 | 2017-07-13 11:00:00 | 2017-08-13 10:59:59 |</tt><br><tt>| 433 | 2017-08-13 11:00:00 | 2017-09-13 10:59:59 |</tt><br><tt>| 442 | 2017-09-13 11:00:00 | 2017-10-13 10:59:59 |</tt><br><tt>| 453 | 2017-10-13 11:00:00 | 2017-10-31 23:59:59 |</tt><br><tt>| 519 | 2017-11-01 00:00:00 | 2017-11-30 23:59:59 |</tt><br><tt>| 542 | 2017-12-01 00:00:00 | 2017-12-31 23:59:59 |</tt><br><tt>+-----+---------------------+---------------------+</tt></span><o:p></o:p></p><p>Best regards,<o:p></o:p></p><p>Henk Plessius<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On 4-12-2017 22:12, Rene Krenn wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Thx, so is it correct you are or have been using billing packages for this customer contract? Would you like to send results for</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> select start,end from billing.contract_balances where contract_id=<that contractId> order by id desc;</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>and</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> select * from billing.contracts where id = <that contractId>;</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>(won‘t expose any sensitive data) </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>regards</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'>Von:</span></b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'> Spce-user [<a href="mailto:spce-user-bounces@lists.sipwise.com">mailto:spce-user-bounces@lists.sipwise.com</a>] <b>Im Auftrag von </b>Henk<br><b>Gesendet:</b> Montag, 4. Dezember 2017 20:26<br><b>An:</b> <a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><br><b>Betreff:</b> Re: [Spce-user] Error generating invoice</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p>Hi Rene,<o:p></o:p></p><p>An update on my last email, it's working now! I changed the dates to begin/end of month and then generate the invoice for December first. After that I can generate November too. So fixed for now, but it looks like it is caused by not using a monthly period (in the past).<o:p></o:p></p><p>Regards,<o:p></o:p></p><p>Henk Plessius<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><div><p class=MsoNormal>On 4-12-2017 19:54, Henk wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p>Hi Rene,<o:p></o:p></p><p>Thank you for the research. I'm entering a valid invoice period, just 11-2017 with a customer that is active for 1 year. I have found that at least two of the customers with failing invoices have an interval that is not from 1st to last of the month, so for example contract balance runs from 2017-11-13 11:00:00 to 2017-12-13 10:59:59. But after I changed the interval in billing.contract_balances to the start and end of month, I have still the same error.<o:p></o:p></p><p>Regards,<o:p></o:p></p><p>Henk Plessius<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><div><p class=MsoNormal>On 4-12-2017 16:24, Rene Krenn wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>hello Henk,</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>thanks for pointing to this. I was able to reproduce the exact same message, but only if i was trying to enter an invoice period (month+year) when that customer contract was not created yet. Can you check if this was also the case in your situation?</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>regards, rene</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'>Von:</span></b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'> Spce-user [<a href="mailto:spce-user-bounces@lists.sipwise.com">mailto:spce-user-bounces@lists.sipwise.com</a>] <b>Im Auftrag von </b>Henk<br><b>Gesendet:</b> Freitag, 1. Dezember 2017 13:25<br><b>An:</b> <a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><br><b>Betreff:</b> Re: [Spce-user] Error generating invoice</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p>Hi Irina,<o:p></o:p></p><p>Sorry I missed that. Now the first invoice works, but the second has another error:<o:p></o:p></p><p><tt><span style='font-size:10.0pt'>MSG="Failed to create invoice ({UNKNOWN}: Can't call method "start" on an undefined value at /usr/share/perl5/NGCP/Panel/Utils/Invoice.pm line 61. at /usr/share/perl5/Catalyst/Model/DBIC/Schema.pm line 526#012)" LOG=""</span></tt><o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>Regards,<br><br>Henk<o:p></o:p></p><div><p class=MsoNormal>On 1-12-2017 12:19, Irina Peshinskaya wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p>Dear Henk,<o:p></o:p></p><p>Just the same as was described yesterday, kindly upgrade your ngcp-panel to the 5.5.1.5:<o:p></o:p></p><pre> apt-get update<o:p></o:p></pre><pre> apt-get install ngcp-panel<o:p></o:p></pre><pre> ngcpcfg apply 'commit mesasge'<o:p></o:p></pre><pre> <o:p></o:p></pre><pre> or better update to latest hotfixes:<o:p></o:p></pre><pre> <o:p></o:p></pre><pre> apt-get update && apt-get upgrade && \<o:p></o:p></pre><pre> ngcp-update-db-schema && ngcp-update-cfg-schema && \<o:p></o:p></pre><pre> ngcpcfg apply 'commit message'<o:p></o:p></pre><p>Best regards,<o:p></o:p></p><p>Irina Peshinskaya<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><div><p class=MsoNormal>On 01.12.2017 13:14, Henk wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p>Hi all,<o:p></o:p></p><p>I'm on the latest version mr5.5.1 and cannot generate invoices anymore. In panel.log I get the following message:<o:p></o:p></p><p><tt><span style='font-size:10.0pt'>MSG="Failed to create invoice .... Unknown column 'me.source_cli_suppression_id' in 'field list' [for Statement "SELECT `me`.`source_user`, `me`.`source_domain`, `me`.`source_cli`, `me`.`destination_user_in`, `me`.`source_cli_suppression_id`, `me`.`destination_user_in_suppression_id`, `me`.`start_time`, `me`.`duration`, `me`.`call_type`, `me`.`source_customer_cost`, `source_customer_billing_zones_history`.`zone`, `source_customer_billing_zones_history`.`detail` FROM `accounting`.`cdr` `me` LEFT JOIN `billing`.`billing_zones_history` `source_customer_billing_zones_history` ON `source_customer_billing_zones_history`.`id` = `me`.`source_customer_billing_zone_id` WHERE ( ( `call_status` = ? AND `source_account_id` = ? AND `source_user_id` != ? AND ( `start_time` >= ? AND `start_time` <= ? ) ) ) ORDER BY `start_time`" with ParamValues: 0='ok', 1="26", 2='0', 3=1509494400, 4=1512086399] at /usr/share/perl5/NGCP/Panel/Utils/Invoice.pm line 84#012)" LOG=""</span></tt><o:p></o:p></p><p>My current DB version is 15367. Did I miss a part of the DB upgrade?<o:p></o:p></p><p>Regards,<o:p></o:p></p><p>Henk Plessius<o:p></o:p></p><p class=MsoNormal><br><br><br><br><br><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>Spce-user mailing list<o:p></o:p></pre><pre><a href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a><o:p></o:p></pre><pre><a href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a><o:p></o:p></pre></blockquote><p class=MsoNormal> <o:p></o:p></p></blockquote><p class=MsoNormal> <o:p></o:p></p></blockquote><p class=MsoNormal><br><br><br><br><br><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>Spce-user mailing list<o:p></o:p></pre><pre><a href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a><o:p></o:p></pre><pre><a href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a><o:p></o:p></pre></blockquote><p class=MsoNormal> <o:p></o:p></p></blockquote><p class=MsoNormal><o:p> </o:p></p></div></body></html>