Mapping Transaction Dates for FBA Orders in NetSuite Connector
By default, NetSuite Connector uses the purchase date that Amazon reports to Fulfillment By Amazon (FBA) orders as the order date. This date is then mapped as the transaction date on the order when the order is imported to NetSuite. Amazon also makes two additional dates, ship start date and ship end date available in the order data that NetSuite Connector retrieves. These two dates are always the same for Amazon FBA orders. NetSuite Connector only reports the dates provided by Amazon and cannot verify if the two dates accurately reflect the shipping date of the order. For accounting purposes, you can map the ship start date and ship end date as the transaction date on the order in NetSuite using the following procedure.
Sometimes, Amazon reports the ship start date as 1/1/1980 on some FBA orders for unknown reasons. If you map that date as your NetSuite transaction date, NetSuite rejects your order and does not let you post the order. For this reason, you should not map the ship dates as your transaction date and leave the default transaction date logic in place.
To map ship start date or ship end date as transaction date:
-
Log in to app.farapp.com.
-
Select Amazon connector and then select the relevant account.
-
Go to Mappings > Orders.
-
Click the Order tab.
-
Click Add Mapping.
-
From the NetSuite Field dropdown list, select Date.
-
Click Add Mapping.
A confirmation message appears indicating the field is added to the end of your list of mappings.
-
Click Close.
A new row for the Date field displays at the end of the mappings list.
-
In the newly added row in the mappings list, from the dropdown list in the Mapping Type column, select Order Header.
-
From the dropdown list in the Amazon Field/Fixed Value column, either select Ship Start Date or Ship End Date as both fields contain same values in the orders.
-
From the dropdown list in the FBA/MFN column, select FBA – Fulfilled By Amazon.
-
Click Save.
A banner message appears indicating the mappings are updated.