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. From the integration app, go to Settings > FBA Returns.
2. From 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. From the Business Central inventory location for damaged returns setting, select the Business Central location to track “damaged” returns. 
4. Click Save.

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.