Amazon Settlement Sync Testing with NetSuite Connector

To ensure a successful implementation of Amazon settlement sync in NetSuite, it is crucial to conduct thorough testing using sample orders. This process verifies that the integration is functioning correctly before moving to a live environment.

What Are the Steps to Set Up Amazon Settlement Sync?

Before you begin testing, you need to prepare for the Amazon settlement sync by following these guidelines:

1. Review Prerequisites: Familiarize yourself with the prerequisites outlined in the NetSuite Connector Settlement Sync Prerequisites.
2. Testing Procedure: Follow the steps for testing the actual settlement sync outlined in Testing NetSuite Connector Settlement Sync.
3. Activate Sync: Ensure you know how to activate the settlement sync by referring to Activating NetSuite Connector Settlement Sync.

How to Prepare for Testing?

Prior to performing tests, make sure you have access to settlement reports from Amazon Seller Central, as this data will form the basis of your testing.

• Amazon usually generates these reports bi-weekly, which include all relevant transactions.
• Select reports that contain only orders successfully synced to NetSuite to avoid errors.
• If necessary, you can request Amazon to generate specific reports for your needs.

Steps for Testing Settlement Sync

Once you have prepared the test orders and have access to the required settlement reports, follow these steps:

1. Log in to app.farapp.com.
2. Select your Amazon connector and the relevant account details.
3. Navigate to Data Flows > Settlements.
4. Click on Retrieve to download the settlement report.
5. When prompted, enter your Settlement Report ID and select Retrieve.
6. After a successful retrieval, check for confirmation messages and proceed to locate the imported report in your list.
7. Click on the Action menu (represented by a pencil icon) and choose Post to sync the report.
8. Monitor the status updates for each transaction as NetSuite Connector processes the report.
9. If you encounter errors, review the error messages for resolution.

Note: Larger reports may take longer to sync, so patience is necessary during this process. If reports show a status of Complete, your testing is successful, and you can move forward.

Who Should Be Involved?

This testing process primarily affects:

• NetSuite Administrators managing integration processes.
• Developers responsible for maintaining connector functionality.
• Finance Teams who rely on accurate settlement data for reporting.

Key Takeaways

• Conduct thorough testing of the Amazon settlement sync before going live.
• Use designated customers for associating non-order transactions to streamline reporting.
• Ensure that reports used for testing have already been synced to avoid errors.

This structured approach helps mitigate potential errors during integration and enhances the overall reliability of financial data received from Amazon Seller Central.

Source: This article is based on Oracle's official NetSuite documentation.