Sync Amazon FBA return orders as sales return orders to Business Central

The FBA edition of the integration app helps you track and sync your FBA returns for order items that are returned to the Amazon warehouses. The integration flow lets you track the returned “sellable” FBA inventory in Business Central. 

Understand the flow

The Amazon FBA returns to Business Central sales return orders (add) flow helps you sync the FBA customer return data from Amazon to Microsoft Dynamics 365 Business Central. This is a scheduled delta flow. When you run the flow, it requests the “FBA returns report” from Amazon. The flow gets the FBA returns from Amazon and looks for the posted sales invoices in Business Central. The flow creates sales return orders and line items in Business Central. This is a scheduled delta flow.

For each record in the report, an associated posted sales invoice is fetched with “order ID.” If a matching invoice is found, the flow creates a sales return order record with 0 amount in Microsoft Dynamics 365 Business Central and with the status “Pending Receipt.” The sales return orders are created based on the locations you select in the settings in the integration app.

Note: 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. In this scenario, in Microsoft Dynamics 365 Business Central, the returned items will be part of separate sales return order records.

Verify your data

Before you sync your 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.

Understand and configure the settings

To track the returned items as per the locations specified in the settings, ensure that you configure your locations in Microsoft Dynamics 365 Business Central. If you do not have your locations configured, the flow does not consider the locations you provide in the settings. The locations are considered from the posted sales invoice.

Example: In the Business Central inventory location for sellable returns setting, you select the location as “A” and in the Business Central inventory location for damaged returns setting, you select the location as “B.” On the posted sales invoice, you have the location as “C.” if the locations are not configured, the sales return order picks the location from the posted sales invoice, which is “C”. 

If you only select the location in the Business Central inventory location for sellable returns setting, 

• The flow syncs only the items with the disposition “sellable” and ignores the remaining items. In Microsoft Dynamics 365 Business Central, the sales return orders 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. 

Note: An item whose disposition is “customer damaged” and the status is “repackaged successfully” is considered a “sellable” item and is tracked in the “sellable” location. 

If you select locations in the Business Central inventory location for sellable returns and Business Central inventory location for damaged returns settings, the sales order return records are created for all the return transactions with the disposition “sellable” and “damaged.”

1. Go to Settings > FBA Returns in the integration app.
   
2. In the Business Central inventory location for sellable returns setting, select the Business Central location to track “sellable” returns. If the Amazon disposition is "CUSTOMER_DAMAGED" and the status is "Repackaged Successfully," the inventory is tracked in the "sellable" location.
3. In the Business Central inventory location for damaged returns setting, select the Business Central location to track “damaged” returns. 
4. In the Offset time to sync Amazon FBA returns setting, enter the value in minutes to wait before syncing Amazon FBA returns. Amazon recommends a value of 4320 (= 72 hours or 3 days).
   

   Example: If the start date and time is set as 08:00 AM, 04th January; current date and time is 05:00 PM, 07th January; and you entered the value as 4320, the returns will be synced from 08:00 AM, 01st January till 05:00 PM, 04th January.

   
   You can set a value of greater or less than the recommended value of 4320 as needed. If you set it higher than the recommended value, say 5760 ( = 96 hours or 4 days), existing records may get synced again for the time duration that exceeds the recommended value. If you set it lower than the recommended value, say 2880 ( = 48 hours or 2 days), records may be skipped for the time duration that is less than the recommended value.
   The most important thing to remember is that the returns will be synced from the adjusted start date & time (Selected date & time – Value entered in the Offset time to sync Amazon FBA returns setting) to the adjusted end date & time (Current date & time – Value entered in the Offset time to sync Amazon FBA returns setting).
   

   INFORMATION ONLY FOR EXISTING FLOWS: When you enter a value in this setting for the first time in this setting, if the flow was last run on 08:00 AM 04th January and you enter the value as 4320 (72 hours), the flow will run as scheduled for the next 3 days (08:00 AM 04th January to 08:00 AM 07th January) with no records being updated for this time period. If you run the flow on 09:00 AM 07th January, the returns will be updated from 08:00 AM 04th January to 09:00 AM 04th January (09:00 AM 07th January - 4320 minutes = 09:00 AM 04th January).

5. Click Save & close to save the changes made to the settings.

Run the flow

1. From the integration app, go to Flows > FBA Returns.
2. Next to the Amazon FBA returns to Business Central sales return orders (add) flow, use that toggle button to enable the flow.
3. If you run the flow for the first time, a delta flow pop-up window is displayed. This helps you to sync the historical returns.
   1. Automatic: Choose this option to process and sync data from the last flow run time OR
   2. Custom: Choose this option to select a custom start date and time from when you wish to process and sync data.
      

      

4. Click Run.

You can see the flow status in the integrator.io Dashboard. On a successful sync, for every record, the success count of the flow including the import and export is shown as 1.

Understand the records in Amazon and Business Central

After you run the Amazon FBA returns to Business Central sales return orders (add) flow, sales order return is created in Microsoft Dynamics 365 Business Central.