Sync your Amazon settlement report (manually or automatically)

You can use one of the below two options to sync your settlement report and process the settlement reconciliations:

• Automatically pull the settlement report
• Upload the settlement report manually

Automatically pull the settlement report

When you enable the “Request Amazon Settlement Report List” flow, the “Amazon Settlement Report to NetSuite Custom Settlement Records” flow is a sequenced flow that automatically runs on the completion of the first flow. This option first requests Amazon and automatically gets the Amazon settlement reports generated after the previously scheduled run. The second flow imports the settlement report to NetSuite and creates custom settlement records.

Upload the settlement report manually

When you disable the “Request Amazon Settlement Report List” flow, the run button is enabled for the “Amazon Settlement Report to NetSuite Custom Settlement Records” flow. This option allows you to manually upload the Amazon settlement report and it creates the custom settlement records in NetSuite.

Understand the grouping logic of the custom settlement records

When you run the “Request Amazon Settlement Report List” and “Amazon Settlement Report to NetSuite Custom Settlement Records” flows, you may find a variance in no of records in the Amazon settlement report and no of successful record processed by the integration app.

This could be due to the integration app grouping logic to organize content based few parameters in the settlement report while importing the information to NetSuite.

To understand more about the grouping logic, refer here.

Before you set up the flow

Prerequisite: Ensure to raise a support ticket with Amazon to change the frequency of the settlement report generation as per your business needs appropriately. The Amazon default frequency of the settlement report is one report every 15 days. The supported format for the settlement report is “Flat File V2”.

Note: If the volume is high and if you are linking all orders against a single default customer, it is recommended to keep the settlement report window lower. This is to ensure that there are no open invoices.

Configure and run the flow

Option 1: Automatically pull settlement report from Amazon

1. In integrator.io, click Amazon - NetSuite Integration App tile.
2. Go to Flows > Settlement.
3. Enable the “Request Amazon Settlement Report List” flow. The “Amazon Settlement Report to NetSuite Custom Settlement Records” is an auto-triggered sequenced flow that runs on the completion of the first flow.
4. Click Run.
   Note: Using this flow, you can also import historical settlement reports.

Option 2: Upload the settlement report manually

Prerequisite: Download the settlement report from your Amazon account. Refer here on how to download the settlement report from Amazon.

1. In integrator.io, click Amazon - NetSuite Integration App tile.
2. Go to Flows > Settlement.
3. Run the “Amazon Settlement Report to NetSuite Custom Settlement Records” flow. This flow is automatically enabled when the “Request Amazon Settlement Report List” flow is disabled.

Find your records in NetSuite

After you run the “Request Amazon Settlement Report List” or “Amazon Settlement Report to NetSuite Settlement Records” flows, the following happens in NetSuite:

A new tab, Amazon is added in NetSuite. This tab can be used for gaining quick access to the customs records that are created from importing the settlement report into NetSuite. To access these custom records, click Amazon > Settlements.

Celigo Amazon Settlement Summary

The Summary option navigates you to the Celigo Amazon Settlement Summary List page. Every summary record on this page represents a settlement report that was imported by you. Every record on this page provides a high-level summary related to the settlement report imported by you. The following screen displays the information available in an individual record immediately after the settlement report import:

Celigo Amazon Settlement Transaction

The Transaction option navigates you to the Celigo Amazon Settlement Transaction List page. The page displays every transaction imported from the settlement report as an individual record. For example, assume a settlement report with Settlement ID: 118267561 is imported into NetSuite and the Dashboard page displays a total of 34 successful records. This means that 34 transaction records will be created on the Celigo Amazon Settlement Transaction List page. Every record on this page provides details related to an individual transaction imported by you. The following screen displays the information available in an individual transaction record immediately after the settlement report import:

Note: All records created in the Celigo Amazon Settlement Transaction List page are supported with NetSuite Global Search. In the following example, you can see how Order Id can be used to find associated records in NetSuite using the global search box:

You can ask questions and get tips about settlement reports in our community forum.