Configuring Reports

The Cybersource SuiteApp for
Oracle NetSuite
 bundle provides these reporting services, which you can import from Cybersource into
Oracle NetSuite
:
  • Transaction Request Report
  • Payment Batch Detail Report
  • Conversion Detail Report

Configuring Reports

Follow these steps to configure the reports that you want to use:
  1. In your
    Oracle NetSuite
    account, on the top navigation, hover over
    Cybersource Integration
    >
    SuiteApp Configuration
    . Click
    SuiteApp Configuration
    .
  2. On the top navigation, hover over
    Configuration
    >
    Reporting
    . Click
    Create Reporting Setup
    .
  3. Enter your
    Business Center
    merchant ID and the key ID and secret key that you generated from the
    Business Center
    .
  4. Check the
    Conversion Detail Report
    box to move details of the Conversion Detail Report from the
    Business Center
    to
    Oracle NetSuite
    .
  5. Check the
    Test Mode
    box to run the integration in test mode. Clear the
    Test Mode
    box to run the integration in live mode.
  6. 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.
  7. Choose a report (Payment Batch Detail Report or Transaction Request Report).
  8. Enter the name of the custom report under
    Name
    and click
    OK
    .
  9. 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:
  1. In your
    Oracle NetSuite
    account, on the top navigation, hover over
    Cybersource Integration
    >
    Reporting Scripts
    . Click
    Transaction Request Report
    .
  2. On the script deployments page, click
    View
    to view the scheduler details.
  3. 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.
  4. By default, the schedule is set as a daily event with a start time of 12:00 a.m.
  5. You can change the schedule options. Click
    Edit
    on the script deployments page to update the scheduler options.
  6. 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:
  1. In your
    Oracle NetSuite
    account, on the top navigation, hover over
    Cybersource Integration
    >
    Reporting Scripts
    . Click
    Payment Batch Detail Report
    .
  2. On the script deployments page, click
    View
    to view the scheduler details.
  3. 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.
  4. By default, the schedule is set as a daily event with a start time of 12:00 a.m.
  5. You can change the schedule options. Click
    Edit
    on the script deployments page to update the scheduler options.
  6. 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:
  1. In your
    Oracle NetSuite
    account, on the top navigation, hover over
    Cybersource Integration
    >
    Reporting Scripts
    . Click
    Conversion Detail Report
    .
  2. On the script deployments page, click
    View
    to view the scheduler details.
  3. 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.
  4. By default, the schedule is set as a daily event with a start time of 12:00 a.m.
  5. You can change the schedule options. Click
    Edit
    on the script deployments page to update the scheduler options.
  6. 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.
  7. 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
    .
  8. 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:
  1. In your
    Oracle NetSuite
    account, on the top navigation, hover over
    Cybersource Integration
    >
    Reporting Script
    . Click
    Map NS ID on Reporting Records
    .
  2. On the Script Deployments page, click
    Edit
    next to
    customdeploy_cs_pymt_map_reporting_ns_id
    for the status Not Scheduled.
  3. Click the drop-down button next to Save, and click
    Save and Execute
    . The script will now update the reporting records in the background.