Amazon Settlement Sync FAQ

TL;DR

This article addresses frequently asked questions regarding Amazon Settlement Sync in NetSuite. Topics include setup instructions, transaction handling, and refund processes, providing valuable insights for effective integration.

How Do I Set Up Amazon Settlement Sync for NetSuite Connector?

To set up Amazon Settlement Sync, reach out to your NetSuite account manager for guidance on configuration and associated charges.

Where Are the Settings for Settlement Sync and What Do They Mean?

To find and understand the settings for settlement sync, refer to the article on Amazon Settlement Sync Settings in NetSuite Connector.

Can NetSuite Connector Post FBA Inventory Adjustments to NetSuite?

Yes, the Amazon Inventory Adjustment sync feature allows you to update FBA item inventory levels in NetSuite, aligning them with the availability in Amazon's warehouses.

What Happens If I Deposit an Order in One NetSuite Accounting Period But It Is Not Settled Until a New Period?

Best practice dictates waiting to deposit payments and holding cash sales in Undeposited Funds until Amazon has settled the period for the order. If you choose to deposit orders based on when they were placed, you may need to post modifications and refunds as summary transactions across two accounting periods.

To Merge Order Modifications or Refunds into a Single Summary Transaction:

1. Navigate to Settings > Other Transactions, then select the Settlement tab.
2. Click on Advanced Options.
3. Under the required settings, check the boxes:
   • Merge All Refunds on Report into a Single Summary Refund
   • Merge All Order Fees into a Single Transaction
   • Split transactions spanning two months.
4. Click Save.

How Does NetSuite Connector Differentiate between Partial Refunds and Full Refunds?

Partial refunds may be indicated in Amazon Settlement Reports. However, partial refunds related to specific SKUs are not detectable by NetSuite Connector, which relies solely on Amazon's reporting.

Does NetSuite Connector Clear Transactions When Processing Settlement Reports?

Yes, transactions are posted as cash sales or refunds, eliminating the need for additional billing adjustments in NetSuite.

How are Concessions Recorded in NetSuite?

Concessions given by Amazon are recorded as adjustments to the original transaction without affecting the inventory totals.

How are Modifications Posted to Invoiced Orders?

Settlement credits and fees are synchronized with the billed record of the order. If an order remains un-invoiced, such changes are applied directly to the original sales order.

Why is the REVERSAL_REIMBURSEMENT SKU Importing as a Cash Refund?

NetSuite Connector occasionally creates new Cash Refund records for settlement fees rather than appending them to existing cash sales. This usually occurs if the initial sale was already deposited.

Can I Combine My Settlement Fees and Credits into a Single Transaction?

NetSuite Connector does not currently support the combination of multiple fees into a single line item for transactions. Each fee or credit is treated as an individual transaction, preserving a clear accounting trail.

How Long Does NetSuite Connector Store Amazon Settlement Reports?

Only the latest three months of settlement reports are stored by NetSuite Connector.

Who Can Summarize All Fees in One Transaction?

To enable the summarization of fees into transactions, contact NetSuite Customer Support.

Key Takeaways

• Setup of Amazon Settlement Sync requires coordination with a NetSuite account manager.
• Best practice includes delaying deposits until settlements are reconciled.
• Each fee in the settlement sync is treated as a separate transaction.

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