Configuring Reports

Follow these steps to configure the reports that you want to use:

In your Oracle NetSuite account, on the top navigation, hover over

Cybersource Integration

>

SuiteApp Configuration

. Click

SuiteApp Configuration

.

On the top navigation, hover over

Configuration

>

Reporting

. Click

Create Reporting Setup

.

Enter your Business Center merchant ID and the key ID and secret key that you generated from the Business Center.

Check the

Conversion Detail Report

box to move details of the Conversion Detail Report from the Business Center to Oracle NetSuite.

Check the

Test Mode

box to run the integration in test mode. Clear the

Test Mode

box to run the integration in live mode.

Click the

Reporting File Details

tab. The configuration for standard Payment Batch Detail Report and Transaction Request Report appear by default. They cannot be removed.

Choose a report (Payment Batch Detail Report or Transaction Request Report).

Enter the name of the custom report under

Name

and click

OK

.

Enter an end date for a custom one-time report like these examples. Keep the field blank for subscription reports.

Example 1: If your report start date is 2023-03-06 and the end date is 2023-03-09, the Report End Date passed in the query is 2023-03-09.

Example 2: If your report runs from midnight to midnight on 2023-03-09, the Report End Date passed in the query is 2023-03-10.

Configuring the Schedule for the Transaction Request Report

The reporting scripts pull the information from the payment application to Oracle NetSuite based on schedules defined in Oracle NetSuite. To ensure timely generation of reports, set up the same timezone on your Oracle NetSuite account and on the Business Center.

Follow these steps to configure a schedule for the Transaction Request Report:

In your Oracle NetSuite account, on the top navigation, hover over

Cybersource Integration

>

Reporting Scripts

. Click

Transaction Request Report

.

On the script deployments page, click

View

to view the scheduler details.

On the Schedule tab of the Script Deployment page, you can view the frequency of the event, the start date and start time, and the end date and end time.

By default, the schedule is set as a daily event with a start time of 12:00 a.m.

You can change the schedule options. Click

Edit

on the script deployments page to update the scheduler options.

On the Schedule tab, choose the appropriate frequency of the event (daily/weekly/monthly), start date and start time, the end date and end time of the event.

Configuring the Schedule for Payment Batch Detail Report

The reporting scripts pull the information from the payment application to Oracle NetSuite based on schedules defined in Oracle NetSuite. To ensure timely generation of reports, set up the same timezone on your Oracle NetSuite account and on the Business Center.

Follow these steps to configure a schedule for the Payment Batch Detail Report:

In your Oracle NetSuite account, on the top navigation, hover over

Cybersource Integration

>

Reporting Scripts

. Click

Payment Batch Detail Report

.

On the script deployments page, click

View

to view the scheduler details.

On the Schedule tab of the Script Deployment page, you can view the frequency of the event, the start date and start time, and the end date and end time.

By default, the schedule is set as a daily event with a start time of 12:00 a.m.

You can change the schedule options. Click

Edit

on the script deployments page to update the scheduler options.

On the Schedule tab, choose the appropriate frequency of the event (daily/weekly/monthly), start date and start time, the end date and end time of the event.

Configuring the Schedule for Conversion Detail Report

The reporting scripts pull the information from the payment application to Oracle NetSuite based on schedules defined in Oracle NetSuite. To ensure timely generation of reports, set up the same timezone on your Oracle NetSuite account and on the Business Center.

Follow these steps to configure a schedule for the Conversion Detail Report:

In your Oracle NetSuite account, on the top navigation, hover over

Cybersource Integration

>

Reporting Scripts

. Click

Conversion Detail Report

.

On the script deployments page, click

View

to view the scheduler details.

On the Schedule tab of the Script Deployment page, you can view the frequency of the event, the start date and start time, and the end date and end time.

By default, the schedule is set as a daily event with a start time of 12:00 a.m.

You can change the schedule options. Click

Edit

on the script deployments page to update the scheduler options.

On the Schedule tab, choose the appropriate frequency of the event (daily/weekly/monthly), start date and start time, the end date and end time of the event.

The script

Update SO status by Conversion Detail Report

updates the sales order status according to the information from the conversion detail report. To view the scheduler option of this script, hover over

Cybersource Integration

>

Reporting Script

. Click

Update SO status by Conversion Detail Report

.

You can view and change the schedule options on the Script Deployment page.

Creating a Reporting Script

If any of the imported reporting records are missing from the mapping to the transaction in Oracle NetSuite, you can initiate a script on demand to map the existing reporting records to the transaction IDs. Follow these steps to initiate this script:

In your Oracle NetSuite account, on the top navigation, hover over

Cybersource Integration

>

Reporting Script

. Click

Map NS ID on Reporting Records

.

On the Script Deployments page, click

Edit

next to

customdeploy_cs_pymt_map_reporting_ns_id

for the status Not Scheduled.

Click the drop-down button next to Save, and click

Save and Execute

. The script will now update the reporting records in the background.