Tariscope 4.6. User's guide
Chapter 2. Tariscope application
2.3. Provider reports
This group of reports included in the Tariscope installation package is intended only for users of the Tariscope Provider edition. Typically, such users have individual requirements for reports and other documents that can be obtained from the billing system. Why you have users, such users come to us to develop reports according to their requirements. At the same time, such users can use the following reports by modifying them themselves according to their requirements. now that you can create new report forms yourself and modify existing report forms using the Microsoft Report Builder application.
The usual work of a communication operator in relation to subscribers consists of accounting for subscribers, accounting for services rendered, formation of payment documents, accounting for payment by subscribers for communication services, tracking of debtors, etc. To solve these issues, the following forms of reports are offered:
- Act of providing communication services. The act of providing communication services needs to be adjusted directly to the details of your company. The full name of the person of your company who signs the act must be added to the Tariscope System Variables.
- Charged services. The report allows you to obtain generalized charges for periodic, one-time services and services for completed calls for a given month. The total amount of services provided is calculated.
- Invoice-act. The report generates a bill-act for a specific subscriber according to his identifier for the selected month. The invoice may or may not include VAT.
- Recurring services charged. The report allows you to get a list and amount of accrued periodic services for a given month. The total amount is calculated.
- One time services that were charged. The report allows you to get a list and amount of one-time services charged for a given month. The total amount is calculated.
- Details by numbers. The report generates data on charges for communication services in separate directions, as well as for subscription fees and other services for the selected period.
- Detailing by subscribers. The report shows the initial balance, accruals, payments, VAT and final balance for each subscriber for the specified period. City, long-distance, mobile, international calls, and other communication services are taken as separate charges.
- Overdue payments. Data are provided on overdue payments from subscribers for communication services on a given date, 30, 60, 90 and 180 days ago.
- Subscriber payments. The report allows you to get information about subscription payments for a given period.
- Receipt for communication services for individuals. A receipt is generated for a specific subscriber based on his ID for the selected month.
- Data about the subscriber. The report generates data on accruals, payments and balance of a specific subscriber for the selected period. In this report example, payment can be made in 3 directions: communication services, construction, customization.
- List of telephone conversations of the subscriber. Information is provided on all long-distance, international calls and to the phones of mobile operators for the selected period of the specified subscriber.
- Accounting for the number of subscribers. Displays the number of subscribers, phone numbers, connected and disconnected for a given period.
- Non-working DNs. The report allows you to get a list of non-working DNs for a given period.
Tariscope 4.6. User's guide
Chapter 2. Tariscope application
2.3. Provider reports
2.3.13 List of telephone conversations of the subscriber
Report form file name: subscribers month calls details.rdl
Надається інформація по усім міжміським, міжнародним та розмовам на телефони мобільних операторів за обраний період заданого абонента.
Variables:
- Start of period. The date from which information will be provided on all long-distance, international and calls to mobile operators' phones for the selected period of the given subscriber.
- End of period. The date on which information will be provided on all long-distance, international and calls to mobile operators' phones for the selected period of the given subscriber.
- SubscriberId. Subscriber ID..
Example of a report in Figure 2.3.13.1.
Figure 2.3.13.1
Tariscope 4.6. User's guide
Contents
Chapter 1 Getting started with Tariscope
Charpter 2 Tariscope application
2.1. Tariscope interface
2.2. Working with views for calls
2.2.1. Creating or selecting a view for calls
2.2.2. Management of the views
2.2.3. Fields of a view for calls
2.2.4. Working with Call View
2.2.5. View for services
2.2.6. Provider summary view
2.2.7. View for IP traffic
2.2.8. Data filtering
2.2.9. Filter by selection and Exclude selection
2.2.10. Selection of related records
2.2.11. Filter by extensions
2.2.12. Selection of calls for a period
2.2.13. Edit SQL filter
2.2.14. Saving and applying filters
2.2.15. Sorting data
2.2.16. Grouping function
2.2.17. Call categories
2.2.18. Transferring phone numbers from one subscriber to another
2.2.19. Import of accrued one-time services in Tariscope
2.3. Provider reports
2.3.1. Non-working DNs
2.3.2. Charged services
2.3.3. Recurring services charged
2.3.4. One time services that were charged
2.3.5. Act of providing communication services
2.3.6. Details by numbers
2.3.7. Detailing by subscribers
2.3.8. Invoice-act
2.3.9. Overdue payments
2.3.10. Subscriber payments
2.3.11. Receipt for communication services for individuals
2.3.12. Data about the subscriber
2.3.13. List of telephone conversations of the subscriber
2.3.14. Accounting for the number of subscribers
2.4. Generalized reports
2.4.1. Summary report by groups
2.4.2. Generalized for all groups
2.4.3. Summary report by categories
2.4.4. Generalized data by departments
2.4.5. Generalized by groups and subscribers
2.4.6. Summary report on the cities from which they called
2.4.7. Generalized report by phones-sources of incoming calls
2.4.8. Generalized by calls to mobile operators
2.4.9. Summary report. International calls
2.4.10. Summary report: cities where calls where were made
2.4.11. Summary report: cities where calls were made by a subscriber
2.4.12. Summary report: cities where calls were made from the group
2.4.13. Consolidated report on PBX
2.4.14. Summary report by routes
2.4.15. Generalized report by group of subscribers
2.4.16. Subscribers' expenses by days
2.4.17. Subscribers' expenses for the period
2.4.18. Subscribers who are call initiators
2.4.19. Generalized report by subscribers (extended)
2.4.20. Generalized report by subscribers, which are sorted by name
2.4.21. Generalized report by subscribers, which are sorted by cost
2.4.22. Generalized report by termination code of incoming calls
2.4.23
Tariscope 4.6. User's guide
Chapter 1 Getting started with Tariscope
Getting started with Tariscope the Tariscope administrator must perform the following actions:
- to install Tariscope;
- to activate Tariscope;
- to configure Tariscope.
These actions do not describe in the document. How to install, activate, and configure Tariscope, see in the document “Tariscope 4.6. Administrator’s guide”.
Tariscope 4.6. User's guide
Purpose
This document is intended for users of the Tariscope Enterprise and Tariscope Provider editions for version 4.6 or later. Further in the text, if there is no need to clarify the edition, the Tariscope name is used. This guide describes all features of the Tariscope applications except the Tariscope installation, configuration, and maintenance.
The Tariscope installation, configuration, and maintenance are described in the Tariscope 4.6. Administrator’s guide.
Introduction
There are two editions of the Tariscope system: Tariscope Enterprise and Tariscope Provider.
The Tariscope Enterprise edition is a call accounting software for companies that have one or a group of PBXs and these telephone systems are used for their own purposes.
The Tariscope Provider edition is a telecom billing system for telecommunications service providers.
Further in the text, if there is no need to clarify the edition, the Tariscope name is used.
- provides a collection of information about calls from various data sources, such as an Ethernet port using TCP, UDP, FTP, and SFTP, local and remote folders, databases, a serial port etc.;
- processes the received information with a definition of the subscriber who made or received a call, with a call rating;
- carries out a search of the desired information about the calls or received / transmitted data using filters of different levels of complexity;
- creates reports with text and graphic information;
- assesses telephone traffic for routes, trunks (lines), or subscribers;
- includes a customer account management (only for the Tariscope Provider edition);
- interacts with other systems, for example, hotel, accounting, CRM, and others;
- manages telecommunications equipment using money or time limits on the volume of calls made or the use of Internet services;
- gives a customer (subscriber) access via the Web interface to get information about the customer (subscriber) account, call details, data traffic and allows an issue to be sent to get help or obtain information, etc.;
- collects information on Internet use from a range of data transmission equipment using NetFlow (version 5, 9), IPFIX, rFlow protocols.
The Tariscope user must possess certain skills in the telephony services provided to subscribers (customers) and / or the Internet services.