Amazon Settlement Sync Dashboard in NetSuite Connector

The Amazon Settlement Sync dashboard displays the following:

Settlement transactions that are synced from your settlement reports
Errors associated with the sync
History of synced reports
Progress of previously synced reports

Accessing the Amazon Settlement Sync Dashboard

Access the settlement sync dashboard from the Settlements tab in the Data Flows section.

To access the Amazon Settlement Sync dashboard:

Log in to app.farapp.com.
Select Amazon connector and then select the relevant account.
Go to Data Flows> Settlements.

Dashboard Layout

The Amazon Settlement Sync dashboard contains the following columns:

Column Name	Description
Box	When using bulk actions, check this box to run the bulk action. Checking the box in the column header selects all objects on that page.
Account	Displays the account of the settlement report. This account should always be the same as the account selected for the Amazon connector.
Report ID	Displays the Amazon assigned ID assigned to each report.
Settlement ID	Displays the settlement ID. In a report, each row has a settlement ID. Usually, a single report contains only one settlement ID.
Status	Displays the report status. Status can be: Complete – Indicates the report is completely synced Error posting to NetSuite – Displays when NetSuite Connector encounters an error when posting to NetSuite. The error status shows the percentage of report synced. The percentage updates after the sync completes the run. NetSuite Connector skips errors and continues processing. NetSuite Connector also retries the settlement items with errors on the next sync run a limited number of times, before automatically canceling the posting. Posting in Progress – Displays only when you manually post the report. In FarApp (Automatic Sync Disabled) – Displays only when a report is pulled into NetSuite Connector but the sync is not active.
Available Date	Displays the date Amazon made the report available through the API. This date may not be the same date when the report was brought into NetSuite Connector or began processing. Factors like timing of availability on a certain day versus the time the sync runs, and existing settlements affect the retrieval and processing.
Action	The pencil icon lets you perform an action on the settlement report in that row. Hovering the pointer on the pencil icon, opens the following action options: Post – Posts the selected report. This action will not run when the scheduled settlement sync is running, because the posting is already in progress. Cancel – Cancels all future postings of the report but does not delete the report from NetSuite Connector. Cancellation takes effect in the next scheduled sync run and does not cancel the postings that are in progress. After selecting Cancel, the label changes to Uncancel. Show Mappings – Opens the Settlement Mappings window that lets you view the mapping for a specific order or for the non-order modifications for a report. The popup window has the following settings: Show Order Adjustments – Displays the order mappings for the order ID entered in the Amazon Order ID field. Show Non-Order Adjustments –Displays the mappings for the non-order modifications for the report. Delete from FarApp – Removes the settlement report from NetSuite Connector. However, this option does not remove any settlement data that synced to NetSuite before removal. View Details – Lets you view the various adjustments of the selected report. Clicking View Details opens the View Settlement windows with the following tabs: Order Fees – Displays fees and credits tied to an order. For example, commission of a n order fee. Refunds – Displays the fees and credits that are associated with a refund. You will see a commission fee on refunds also, because Amazon refunds the commission. Inventory Adjustments – These are not commonly found on the reports but reflect report changes to your FBA inventory due to settlement. Note: You cannot view non-order modification fees and credits on the dashboard.

Column Name

Description

Box

When using bulk actions, check this box to run the bulk action.

Checking the box in the column header selects all objects on that page.

Account

Displays the account of the settlement report. This account should always be the same as the account selected for the Amazon connector.

Report ID

Displays the Amazon assigned ID assigned to each report.

Settlement ID

Displays the settlement ID. In a report, each row has a settlement ID. Usually, a single report contains only one settlement ID.

Status

Displays the report status. Status can be:

Complete – Indicates the report is completely synced
Error posting to NetSuite – Displays when NetSuite Connector encounters an error when posting to NetSuite. The error status shows the percentage of report synced. The percentage updates after the sync completes the run. NetSuite Connector skips errors and continues processing. NetSuite Connector also retries the settlement items with errors on the next sync run a limited number of times, before automatically canceling the posting.
Posting in Progress – Displays only when you manually post the report.
In FarApp (Automatic Sync Disabled) – Displays only when a report is pulled into NetSuite Connector but the sync is not active.

Available Date

Displays the date Amazon made the report available through the API. This date may not be the same date when the report was brought into NetSuite Connector or began processing. Factors like timing of availability on a certain day versus the time the sync runs, and existing settlements affect the retrieval and processing.

Action

The pencil icon lets you perform an action on the settlement report in that row.

Hovering the pointer on the pencil icon, opens the following action options:

Post – Posts the selected report. This action will not run when the scheduled settlement sync is running, because the posting is already in progress.
Cancel – Cancels all future postings of the report but does not delete the report from NetSuite Connector. Cancellation takes effect in the next scheduled sync run and does not cancel the postings that are in progress. After selecting Cancel, the label changes to Uncancel.
Show Mappings – Opens the Settlement Mappings window that lets you view the mapping for a specific order or for the non-order modifications for a report. The popup window has the following settings:
- Show Order Adjustments – Displays the order mappings for the order ID entered in the Amazon Order ID field.
- Show Non-Order Adjustments –Displays the mappings for the non-order modifications for the report.
Delete from FarApp – Removes the settlement report from NetSuite Connector. However, this option does not remove any settlement data that synced to NetSuite before removal.
View Details – Lets you view the various adjustments of the selected report. Clicking View Details opens the View Settlement windows with the following tabs:
- Order Fees – Displays fees and credits tied to an order. For example, commission of a n order fee.
- Refunds – Displays the fees and credits that are associated with a refund. You will see a commission fee on refunds also, because Amazon refunds the commission.
- Inventory Adjustments – These are not commonly found on the reports but reflect report changes to your FBA inventory due to settlement.
Note:
You cannot view non-order modification fees and credits on the dashboard.

View Details Window

The View Details window contains the following:

Setting	Description
Search field	Used to search a transaction in the report. Enter the transaction ID of the order or refund that you want to find and click the adjacent magnifying glass icon.
Columns	The report provides the following columns: Marketplace – The Amazon site from where the transaction is originated. For example, US orders show Amazon.com and Canada orders show Amazon.ca. Fulfilled By – Displays whether the transaction was on the Amazon Fulfilled Network (AFN or FBA), or the Merchant Fulfilled Network (MFN). Period Ending – The ending date of settlement period represented by the report. Transaction ID – The order ID associated with the transaction. Transaction Date – The date on which the transaction occurred. Total – The total of fees and credits associated with the transaction. SKUs – Clicking the magnifying glass opens a popup windows displaying fees and credits for the settlement and the SKU for which the fees and credits are applied.
Page Number	Lets you select the page you want to view and shows the page number that you are viewing. Also shows the total number of pages and buttons to move to the first (<<) or last (>>) page.
Transactions per page	Lets you select the number of transactions that appear per page. The larger the number, the longer the page takes to load.

Setting

Description

Search field

Used to search a transaction in the report. Enter the transaction ID of the order or refund that you want to find and click the adjacent magnifying glass icon.

Columns

The report provides the following columns:

Marketplace – The Amazon site from where the transaction is originated. For example, US orders show Amazon.com and Canada orders show Amazon.ca.
Fulfilled By – Displays whether the transaction was on the Amazon Fulfilled Network (AFN or FBA), or the Merchant Fulfilled Network (MFN).
Period Ending – The ending date of settlement period represented by the report.
Transaction ID – The order ID associated with the transaction.
Transaction Date – The date on which the transaction occurred.
Total – The total of fees and credits associated with the transaction.
SKUs – Clicking the magnifying glass opens a popup windows displaying fees and credits for the settlement and the SKU for which the fees and credits are applied.

Page Number

Lets you select the page you want to view and shows the page number that you are viewing. Also shows the total number of pages and buttons to move to the first (<<) or last (>>) page.

Transactions per page

Lets you select the number of transactions that appear per page. The larger the number, the longer the page takes to load.

Accessing the Amazon Settlement Sync Dashboard

To access the Amazon Settlement Sync dashboard:

Dashboard Layout

View Details Window

Related Topics