<!DOCTYPE html><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>Hi Danny,</p>
<p>In the CE version it's difficult to get information on your
reseller. Maybe you can use the "Billing data export" feature
described in the manual.</p>
<p>I made my own script to export what I need to a csv file, so I
have full control of the format.</p>
<p>Attached is an example, you can run it from a cron job in the
beginning of the month, only change directory and reseller
domains. If you want to edit the SQL I advice you to use an editor
like notepad++ to highlight the syntax as in a normal editor this
is unreadable.<br>
</p>
<p>Regards,</p>
<p>Henk Plessius</p>
<p>VoipDigit<br>
</p>
<div class="moz-cite-prefix">On 22-May-24 16:37, rkrenn--- via
Spce-user wrote:<br>
</div>
<blockquote type="cite" cite="mid:004501daac55$a27cdaa0$e7768fe0$@sipwise.com">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style>@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;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}span.E-MailFormatvorlage19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}div.WordSection1
{page:WordSection1;}</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]-->
<div class="WordSection1">
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black" lang="EN-US">>Ok, so is it correct that I set the peering
profile for my reseller and the price list agreed between us
for my reseller's customers?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="EN-US">carrier costs are defined by billing profiles
of contracts assigned to a ngcp peergroup entity<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="EN-US">-> billingprofile with </span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black" lang="EN-US">0.xx cents/second your peering providers are
charging you as an platform operator (company1) for calls
leaving the ngcp platform</span><span style="mso-fareast-language:EN-US" lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="EN-US">reseller costs are defined by billing profiles
of contracts assigned to a ngpc reseller entity (company 2)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="EN-US">-> billingprofile with </span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black" lang="EN-US">0.02 cents/minute you will charge company 2</span><span style="mso-fareast-language:EN-US" lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="EN-US">customer costs are defined by billing profiles
of contracts assigned to a ngcp subscriber entity (company
2’s subscribers)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="EN-US">-> billingprofile with</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black" lang="EN-US"> Company 2's subscriber price list, which
company 2 can assign to its susbcribers.</span><span style="mso-fareast-language:EN-US" lang="EN-US"><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black" lang="EN-US">>Is there a way to generate the invoice with
the total traffic developed by the reseller's subscribers?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="EN-US">Yes newer ngcp version support generating PDF
invoices for DID (pbx), reseller and peering/carrier costs.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="EN-US">please check with <a href="mailto:sales@sipwise.com" moz-do-not-send="true" class="moz-txt-link-freetext">sales@sipwise.com</a> if
this functionality is available in the CE version.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="EN-US">br<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US" lang="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">Von:</span></b><span lang="DE"> Danny Cappellari
<a class="moz-txt-link-rfc2396E" href="mailto:cappellari@connectlife.it"><cappellari@connectlife.it></a> <br>
<b>Gesendet:</b> Mittwoch, 22. Mai 2024 15:44<br>
<b>An:</b> <a class="moz-txt-link-abbreviated" href="mailto:rkrenn@sipwise.com">rkrenn@sipwise.com</a>; mcapetta
<a class="moz-txt-link-rfc2396E" href="mailto:mcapetta@sipwise.com"><mcapetta@sipwise.com></a><br>
<b>Cc:</b> spce-user <a class="moz-txt-link-rfc2396E" href="mailto:spce-user@lists.sipwise.com"><spce-user@lists.sipwise.com></a><br>
<b>Betreff:</b> [EXTERNAL] RE: AW: [Spce-user] Resellers
Operating Logics<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">I'll
rephrase the question more specifically<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Company
1 (us)<br>
Company 2 (reseller of Company1)<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Company
1 agrees a price of 0.02 cents/minute to Italy with
Company 2<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Company
1 sets the carrier cost profile on Company 2 and the
subscribers of Company 2 the profile of 0.02 cents/minute<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">In
reality, for Azienda 2 subscribers we should set the price
list that Azienda 2 applies to them..<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Company
1 is not interested in Company 2's subscriber price list,
so how does it bill Company 2's subscriber traffic?<o:p></o:p></span></p>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
</blockquote>
</body>
</html>