Sync Amazon orders (MFN) to Microsoft Dynamics 365 Business Central sales orders (add or ignore)

Contents

• Understand the flow
• Configure settings
• Configure flow settings
• Run the flow
• Understand the Amazon MFN and Microsoft Dynamics 365 Business Central order records

The Amazon orders (MFN) to Microsoft Dynamics 365 Business Central sales order (add or ignore) flow syncs new MFN orders from Amazon as sales orders to Microsoft Dynamics 365 Business Central. If an order exists in Microsoft Dynamics 365 Business Central, the flow ignores it. The flow looks for the customer by email address and syncs it to Microsoft Dynamics 365 Business Central. It then syncs the address and order line items to sales orders. This flow also syncs sales order cancellations. Finally, it looks for the order total details and syncs variance amounts to sales orders. This is a scheduled-delta flow.

Understand the flow

In the Amazon orders (MFN) to Microsoft Dynamics 365 Business Central sales order (add or ignore) flow, the Get MFN orders from Amazon export get the new Amazon MFN orders on a scheduled basis created after the last flow run. The Lookup sales orders in Microsoft Dynamics 365 Business Central flow step looks for sales orders in Microsoft Dynamics 365 Business Central. The Get MFN order items from Amazon export gets the MFN order items.

The Post customers to Microsoft Dynamics 365 Business Central import syncs the customers to Microsoft Dynamics 365 Business Central. 

• If a customer is found in Microsoft Dynamics 365 Business Central, the flow ignores it. 
• If a customer is not found in Microsoft Dynamics 365 Business Central, the Post customers to Microsoft Dynamics 365 Business Central import creates a customer record in Microsoft Dynamics 365 Business Central. While creating the customers, the flow validates if the record has an email and the Celigo eTail account ID. The flow doesn’t create duplicate customer records for different accounts. The success count is specified on the integration.io Dashboard.
• If the flow fails to create a customer, an error message is displayed on the integration app Dashboard.

The Post sales order cancellations to Microsoft Dynamics 365 Business Central and Post sales orders to Microsoft Dynamics 365 Business Central import syncs sales orders and sales order cancellations to Microsoft Dynamics 365 Business Central. If a sales order exists in Microsoft Dynamics 365 Business Central, the flow ignores to sync the record. 

The Update sales order address to Microsoft Dynamics 365 Business Central and Post sales order line items to Microsoft Dynamics 365 Business Central imports syncs the sales order addresses and order line items to Microsoft Dynamics 365 Business Central.

The Lookup sales order amount from Microsoft Dynamics 365 Business Central flow step gets the sales order amounts from the Microsoft Dynamics 365 Business Central. The Post sales order variances to Microsoft Dynamics 365 Business Central import syncs the sales order variance amounts to the Microsoft Dynamics 365 Business Central sales order. 

Configure settings

1. In the Amazon - Microsoft Dynamics 365 Business Central integration app, go to Settings > Order (MFN).
2. In the Set go-live date and time setting, enter the date and time when you want to start syncing Amazon orders. All Amazon orders created prior to this date are ignored. 
3. In the Default Microsoft Dynamics 365 Business Central customer for all Amazon orders setting, enter a customer number to be applied by default to all Microsoft Dynamics 365 Business Central orders. This setting is useful if you prefer to skip adding a customer record to Microsoft Dynamics 365 Business Central for each new Amazon order.
4. In the Select Microsoft Dynamics 365 Business Central item to track Amazon gift wrap amounts and taxes setting, choose a Microsoft Dynamics 365 Business Central non-inventory item to track the gift wrap amounts and taxes. The selected item is added as a separate line item on the Microsoft Dynamics 365 Business Central sales order.
5. In the Select Microsoft Dynamics 365 Business Central item to track Amazon shipping amounts and taxes setting, choose a Microsoft Dynamics 365 Business Central non-inventory item to track the shipping amounts and taxes. The selected item is added as a separate line item on the Microsoft Dynamics 365 Business Central sales order.
6. Click Save.

Configure flow settings 

Information: It is recommended to use the below settings if you want to re-sync the orders (during Amazon downtime, or invalid configuration scenarios) to Microsoft Dynamics 365 Business Central.

1. Go Flows > Order (MFN).
2. Click on the Amazon orders to Microsoft Dynamics 365 Business Central sales order (add or ignore) flow.
3. On the Get MFN orders from Amazon export, click on the Export.
   
   
4. On the Edit export window, click to expand Custom Settings.
5. Check the Sync historical Amazon MFN orders on demand box to sync historical missing orders on demand for a specified duration. After you check this box, provide an end date in the Select the end date for historical orders setting to limit the orders you want to export. The Amazon orders (MFN) to Microsoft Dynamics 365 Business Central sales orders (add or ignore) flow syncs back the missing orders on-demand only for the specified duration.
   
   Important: Uncheck this box after syncing the historical orders on demand.
6. In the Select the end date for historical Amazon MFN orders setting, select an end date for the historical missing orders that you want to sync on-demand to Microsoft Dynamics 365 Business Central.

Run the flow

Prerequisite: The items in Amazon must be in sync with Microsoft Dynamics 365 Business Central, otherwise the flow will error out. 

1. Go Flows > Orders (MFN).
2. Next to the Amazon orders to Microsoft Dynamics 365 Business Central sales order (add or ignore) flow, use the 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 orders. 
   • Automatic: Choose this option to process and sync data from the last flow run time OR
   • 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 Amazon MFN and Microsoft Dynamics 365 Business Central order records

Amazon Seller Central MFN order

The Amazon orders (MFN) to Microsoft Dynamics 365 Business Central sales orders (add or ignore) flow syncs the following from Amazon:

• Order details
• Customer information
• Custom fields such as Celigo eTail order ID, Celigo eTail account ID, Celigo eTail order status, Celigo eTail ship service level, Celigo eTail pay method details, Celigo Amz fulfillment channel, and Celigo Amz sales channel.
• The flow syncs the order ID, eTail order line ID, eTail channel, and variances at the body level.

Microsoft Dynamics 365 Business Central sales order

Microsoft Dynamics 365 Business Central sales order - line details