https://sky-networks.com/mediawiki/index.php?action=history&feed=atom&title=Custom_Report 2026-04-06T00:33:38Z Revision history for this page on the wiki MediaWiki 1.32.3 https://sky-networks.com/mediawiki/index.php?title=Custom_Report&diff=331&oldid=prev 2013-07-31T16:12:38Z

<p>Created page with &quot;This option is dedicated to the generation of custom reports. The customization window is illustrated in figure 33. &lt;center&gt;<a href="/mediawiki/index.php?title=File:Figure33billing.png" title="File:Figure33billing.png">Image:Figure33billing.png</a>&lt;/center&gt; &lt;center...&quot;</p> <p><b>New page</b></p><div>This option is dedicated to the generation of custom reports. The customization window is illustrated in figure 33.<br /> <br /> <br /> &lt;center&gt;[[Image:Figure33billing.png]]&lt;/center&gt;<br /> <br /> <br /> &lt;center&gt;''Figure 33. Custom Report Generation.''&lt;/center&gt;<br /> <br /> The customization window is divided in three parts: Client, Provider, and the third part that includes the field Country. The field Display is used to enable or disable the deployment of the filter in the table. For example if you want to generate a report for a client where you want to see the traffic per area codes, check mark the box under Display for Dial Code.<br /> <br /> <br /> The Client and Provider windows have the following fields:<br /> <br /> • Company<br /> <br /> This field is used when different companies, business units or subsidiaries carry on your business. You can generate the report for the entire group or select the company/business unit of your interest.<br /> <br /> • Traffic Type<br /> <br /> The traffic type depend on the type of service rendered: hubbing, retail, etc.<br /> <br /> • Carrier<br /> <br /> Type here the name of the customer or provider.<br /> <br /> • Destination<br /> <br /> Type here the name of the city or country. As you type a window with all the possible options will appear for you to select the destination.<br /> <br /> • Area Code<br /> <br /> You can customize the report by including a specific area code.<br /> <br /> • Manager<br /> <br /> You can generate a report to see the performance of the accounts of a particular Manager. Select the name of the Manager from the list.<br /> <br /> • Currency<br /> <br /> Here you decide whether or not to show this field in the report.<br /> <br /> <br /> <br /> The third part of the customization window includes the following fields:<br /> <br /> • Country<br /> <br /> Type here the name of the country you want to retrieve data from.<br /> <br /> • Internal Destination<br /> <br /> Type here the name of the City or network (p. e. cellular Avantel) you want to retrieve information. Note that in this field your internal destination assignation is followed.<br /> <br /> • Internal Area Code<br /> <br /> Type the Area Code following your internal definition of area codes.<br /> <br /> • Internal/Client/Provider Date<br /> <br /> Depending on the internal time followed by your business, your customers or providers, you might have differences in the date. This field helps clarify these differences.<br /> <br /> • Output<br /> <br /> Select the format you want the report to be generated: html, csv, excel, xml.<br /> <br /> • Reset<br /> <br /> Click Reset to clear all fields and start a new customization.<br /> <br /> • Next<br /> <br /> Your customized report will be exported in the specified format.<br /> <br /> <br /> <br /> Following is an example of a customized client report for the city of Armenia in Colombia, and for the 12/19/2012. Figure 34 shows the customization parameters.<br /> <br /> <br /> &lt;center&gt;[[Image:Figure34billing.png]]&lt;/center&gt;<br /> <br /> <br /> <br /> &lt;center&gt;''Figure 34. Armenia – Colombia Customization Parameters.''&lt;/center&gt;<br /> <br /> <br /> <br /> The custom report generated in the example of figure 34 is shown in figure 35.<br /> <br /> <br /> &lt;center&gt;[[Image:Figure35billing.png]]&lt;/center&gt;<br /> <br /> <br /> &lt;center&gt;''Figure 35. Armenia – Colombia Custom Client Report.''&lt;/center&gt;<br /> <br /> <br /> This report lists the customers sending traffic to Armenia. The fields of the report are:<br /> <br /> • Client<br /> <br /> These are the customers sending traffic to Armenia.<br /> <br /> • Client Destination<br /> <br /> The destination your customers require the traffic to be terminated.<br /> <br /> • Client Currency<br /> <br /> The currency your customer’s billing is based.<br /> <br /> • Calls<br /> <br /> This is the total amount of calls in the time frame.<br /> <br /> • Internal Minutes<br /> <br /> You also have the Internal Minutes, which refers to your methods of billing in terms of minute rounding.<br /> <br /> • ALOC<br /> <br /> • Income<br /> <br /> As previously described.<br /> <br /> • Sell Rate<br /> <br /> As previously described.<br /> <br /> • Cost<br /> <br /> As previously described.<br /> <br /> • Cost Rate<br /> <br /> As previously described.<br /> <br /> • Profit<br /> <br /> As previously described.<br /> <br /> • % Profit / Income<br /> <br /> As previously described.</div>

Admin