The “Amazon (FBA) returns to NetSuite Return Authorization and Item Receipts” flow helps to sync the FBA customer return data from Amazon to NetSuite. It is a scheduled flow. While we running the flow, it requests for the “FBA returns report” from Amazon. For each record in the report, an associated invoice is fetched with “order ID.” If a matching invoice is found, the flow creates a return authorization (RA) record with 0 amount in NetSuite and it has the status “Pending Receipt.” The flow also creates an “item receipt” for each Return Authorization record and closes the Return Authorization record to complete the process. The item receipts are created based on the locations you select in the advanced settings in the integration app. If an order has an item with quantity 3, out of which 2 quantity is returned, the Amazon FBA returns report tracks the returned items as separate lines.
The return order flow supports inventory items, matrix items, Kit and assembly items, item aliases, Serialized items and Lot Numbered items.
How the flow works?
In NetSuite, on the ”return authorization” record, we can configure the locations at the body-level or at the line-level (each item level). To track the returned items per locations specified in the advanced settings, ensure that configure the locations on the ”return authorization” record at the line-level. If you do not have your locations configured at the line-level, the flow does not consider the locations you provide in the advanced settings. Then the locations are considered from the invoice.
If we select only the location in the NetSuite inventory location for “sellable” returns drop-down list,
- The flow syncs only the items with disposition “sellable” and ignores the remaining items. In NetSuite, the “return authorization” and “item receipt” records are created only for the “sellable” items. The items with the disposition “damaged” are ignored.
- If you have only “damaged” items on your return order, the flow ignores that return order.
If an item whose disposition is “customer damaged” and the status is “repackaged successfully” is considered as a “sellable” item and is tracked in the “sellable” location.
If we select locations in the NetSuite inventory location for “sellable” returns and NetSuite inventory location for “damaged” returns drop-down lists, the “return authorization” and “item receipt” records are created for all the return transactions with disposition “sellable” and “damaged.”
Verify the data
Before sync return data, ensure the following:
- An invoice exists for the returned order.
- All the items you want to return exist on the invoice.
- The returned item quantity matches or is less than the order quantity.
Configure and run the flow
- In integrator.io, click Amazon – NetSuite Integration App tile.
- Go to Settings > Integration flows > FBA returns.
Configure the flow settings
- Enable the “Amazon (FBA) returns to NetSuite RA and item receipts” flow.
- In the flow’s Settings, check the Set a start date box to select a start date for this delta flow to bring the historical returns data.
- Click Save.
- Go to Advanced Settings.
- In the Lookup criteria to search matching invoices in NetSuite field, define the lookup criteria to search the matching invoices in NetSuite. By default, the flow looks for the “eTail order ID” from the FBA returns report. The default value is [‘custbody_celigo_etail_order_id’ ‘is’, {{order-id}}]. You can change the lookup criteria as per your business needs.
- From the NetSuite inventory location for “sellable” returns drop-down list, select a NetSuite location to track your inventory for “sellable” returns. If you are not using a different location to track your inventory for “damaged” returns, the return authorization record will have only “sellable” records. This is a mandatory setting.
- From the NetSuite inventory location for “damaged” returns drop-down list, select the location to track your returned inventory that is “damaged.”
If you don’t select any location in the NetSuite inventory location for “damaged” returns setting then, In NetSuite, if the Advanced Receiving checkbox is checked (Setup > Company > Setup Tasks > Enable Features page > Transactions tab > Shipping & Receiving sub-tab), then you can find the “damaged” returns on the item receipt with “restock” as No. If the Advanced Receiving checkbox is unchecked, the “damaged” returns are ignored. The item receipt will only have “sellable” disposition records.
Note: It is recommended to select an account in the Write-off account for returns drop-down list (Setup > Accounting > Accounting Preferences page> Order Management tab > Returns sub-tab) to track the damaged returns on the item receipt. If you do not select any account in the Write-off account for returns drop-down list, the restock value is “Yes” for all the item receipt lines, irrespective of the Amazon disposition or the location selected in the NetSuite inventory location for “damaged” returns integration app setting. ]
4. Click Save.
5. Run the “Amazon (FBA) returns to NetSuite RA and item receipts” flow.
Find your return records in NetSuite
After running the “Amazon (FBA) returns to NetSuite RA and item receipts” flow, the following records are created in NetSuite:
Return authorization: For each record in the FBA Returns report, if a matching invoice is found, the flow creates a RA record in NetSuite with the status “Pending Receipt”
Item receipt: An item receipt is created for each RA record and the RA record is closed. The item receipts are created based on the locations you select in the advanced settings in the integration app.