Setting up Amazon Settlement Sync

Amazon Settlement Sync Settings

The Amazon Settlement sync can be configured in the Settlement tab of the Settings > Other Transactions screen of your Amazon connector.

Setting	Description
NetSuite SKU Field	Enter the field ID of the field used to match items on orders to items in NetSuite.
Customer Internal ID	Certain fees or credits on your settlement report are not associated to a particular order, for example, FBA warehouse fees. Since NetSuite requires all transactions to be associated with a customer, enter the internal ID of the customer ID that you want to associated with the new cash sales or cash refund records that the settlement sync creates. The leading practice is to use a customer record used only for settlements. This associates all new transactions created by the settlement sync to a specific customer record for review purposes.
Days Back to Search for Settlement Reports	Sets the number of days NetSuite Connector searches for settlement reports. The leading practice is to set to minimum of 20 days.
Merge All Refunds on Report into a Single Summary Refund	Posts all refunds in one single summary refund, rather than posting the refunds against each specific order. Note: Line items are not compiled. Each refunded line item is placed into a single refund transaction record.
Merge All Order Fees into a Single Transaction	Posts all orders fees and credits into a single summary transaction record rather than posting to each order. Note: Line items are not compiled. Each refunded fee or credit line item is placed into a single transaction record.
When Posting Summary Transactions, Split Them into Two Transactions if They Span Two Months	Use with any of the merge options. When checked, the summary records are split so that the records do not cross months.
Post Refunds as Credit Memos	Check this option to create refunds as credit memos instead of cash refunds or refund authorizations.

Setting

Description

NetSuite SKU Field

Enter the field ID of the field used to match items on orders to items in NetSuite.

Customer Internal ID

Certain fees or credits on your settlement report are not associated to a particular order, for example, FBA warehouse fees.

Since NetSuite requires all transactions to be associated with a customer, enter the internal ID of the customer ID that you want to associated with the new cash sales or cash refund records that the settlement sync creates.

The leading practice is to use a customer record used only for settlements. This associates all new transactions created by the settlement sync to a specific customer record for review purposes.

Days Back to Search for Settlement Reports

Sets the number of days NetSuite Connector searches for settlement reports.

The leading practice is to set to minimum of 20 days.

Merge All Refunds on Report into a Single Summary Refund

Posts all refunds in one single summary refund, rather than posting the refunds against each specific order.

Note:

Line items are not compiled. Each refunded line item is placed into a single refund transaction record.

Merge All Order Fees into a Single Transaction

Posts all orders fees and credits into a single summary transaction record rather than posting to each order.

Note:

Line items are not compiled. Each refunded fee or credit line item is placed into a single transaction record.

When Posting Summary Transactions, Split Them into Two Transactions if They Span Two Months

Use with any of the merge options. When checked, the summary records are split so that the records do not cross months.

Post Refunds as Credit Memos

Check this option to create refunds as credit memos instead of cash refunds or refund authorizations.

General Notices