Search xDRs

The xDRs are billing data records that store information about various billing events: calls, SMSes, payment transactions, etc.

On the Search xDRs panel, you can filter the recently produced (for the current billing period) or archived (produced for the previous billing periods) xDR records.

Specify one or more search criteria and click Apply filters. Click Default filters to reset the search criteria. To refresh the search results, click Reload data.

The Recent tab allows you to filter xDRs created in the current billing period and that have not been archived yet.

Specify the date and time in the current billing period that the search period starts from. Click Calendar to select the date and time or type it in the format YYYY-MM-DD hh:mm:ss (2019-03-19 00:00:00). To clear the selected date, click Cancel .

Specify the date and time in the current billing period that the search period ends with. By default, PortaBilling filters the xDRs up to the present moment. To define a specific date and time, select Specific time and click Calendar to select or type the date and time in the format YYYY-MM-DD hh:mm:ss (2019-03-19 00:00:00). To clear the selected date and time, click Cancel .

Filter xDRs per service, e.g., for voice calls. The list includes the default services and the services you have created. You can also filter xDRs separately for subscriptions, payments, taxes, DID usage.

Filter the xDRs by the phone number of the session originator (a caller or the message sender). This field is available for Voice calls, Conferencing, and Messaging service types only. By default, PortaBilling filters phone numbers that start with your input.

To change the search mode for this field, click Matching mode and select another option to filter xDRs by the originating phone number that:

• Exactly matches – exactly matches your input.
• Starts with – starts with your input.
• Contains – contains your input (anywhere in the number).
• Ends with – ends with your input.

PortaBilling automatically saves matching mode from the previous search.

Filter the xDRs by the destination phone number or the message recipient. This field is available for Voice calls, Conferencing, and Messaging service types only. By default, PortaBilling filters phone numbers that start with your input.

To change the search mode for this field, click Matching mode and select another option to filter xDRs by the destination phone number that:

• Exactly matches – exactly matches your input.
• Starts with – starts with your input.
• Contains – contains your input (anywhere in the number).
• Ends with – ends with your input.

PortaBilling automatically saves matching mode from the previous search.

This option is available for Voice calls, Conferencing, and Messaging service types only. Turn on the toggle to include xDRs for unsuccessful session attempts in the results list.

On this tab, you can choose the parameters of the archived xDRs report (the xDRs become archived once the distributor’s billing period closes). To download a report with archived xDRs, choose the parameters on this tab and then click on the needed date on the Download archived xDRs panel.

Shows the customer’s billing period (defined in Finances > General info > Billing period).

Select the type of xDR report you want to download:

• Standard xDRs report – generated for all customer’s accounts that the distributor is assigned for.
• Site based report – generated for accounts that belong to a specific customer site that the distributor is assigned for. This option is disabled by default. To allow downloading reports of this type, specify the file format (Sites_Based_Report_CSV and/or Sites_Based_Report_PDF) in CustomXDRReport.EnabledPlugins option on the Configuration server.
• Distributor commission report – generated for the distributor (see more details here). To allow downloading reports of this type, specify the file format Distributor_Commission_Report in CustomXDRReport.EnabledPlugins option on the Configuration server.

Choose what xDRs to include on the report by account type. By default, PortaBilling searches for the xDRs produced for the Customer and all their credit accounts. Select Debit accounts to download the archived xDRs produced for the customer’s debit accounts.

Choose the file format to download xDR report.

• .csv
• .pdf – is available only for a Site based report (if the .pdf format is allowed).

By default, the archived xDRs are downloaded as compressed archived files (.zip). You can unmark the checkbox, and then the archived xDRs are downloaded in the format defined in the Report type field.

To download the archived xDRs, click the exact date in the calendar and the file is automatically downloaded.