Sync Amazon FBA inventory adjustments as item journals to Business Central

In the Amazon (FBA) warehouse, there might be multiple reasons for inventory loss or damage. To account for the loss, adjustments are made to the inventory levels in the Amazon (FBA) warehouse on a daily basis. With FBA inventory adjustments, you can ensure that the lost or damaged inventory is automatically accounted for using the Amazon (FBA) inventory adjustments to Business Central item journals (add) flow. You can manage your inventory and ensure all the adjustments are reported in Microsoft Dynamics 365 Business Central using the FBA edition of the integration app. For more information about adjustment types, reason codes, and dispositions, see Amazon FBA inventory adjustments.

Understand how the flow works

The Amazon (FBA) inventory adjustments to Business Central item journals (add) flow allow you to manage, maintain and track your available inventory levels in Microsoft Dynamics 365 Business Central. It also categorizes sellable vs damaged inventory based on the disposition given by Amazon. The flow automatically syncs Amazon (FBA) adjustment data in Microsoft Dynamics 365 Business Central.  The flow imports the inventory adjustment to Microsoft Dynamics 365 Business Central as per the scheduled time. In Amazon, a real-time FBA inventory adjustment report is generated no more than once every 30 minutes. Before you send another request, Amazon should have a 30-minute time lag to generate the updated version of the report.

The Amazon (FBA) inventory adjustments to Business Central item journals (add) flow syncs the Amazon (FBA) inventory adjustments data as item journals to Business Central. This flow helps you to manage the on-hand Amazon (FBA) inventory levels in Business Central. The flow lookup gets inventory adjustments with matching SKUs from Business Central items. If any records are not synced, update the lookup criteria in the Define criteria to search for a matching item in Business Central setting and search for the records with the modified lookup criteria. This is a scheduled delta flow.

Note: Only the inventory items are supported.

Configure the settings

1. Log in to integrator.io.
2. Click Amazon - Microsoft Dynamics 365 Business Central integration app tile.
3. Go to Settings > Inventory (FBA).
4. In the Sync event types to Business Central setting, choose one or many event types to be synced to Business Central. The event types that are not specified in this setting will be ignored. The default value is Adjustments event type.
5. In the Offset time to sync Amazon (FBA) inventory setting, enter the number of minutes to wait before syncing the Amazon FBA inventory. The recommended value is 4320 [72 hours]. Example: If the start date for the flow is set as 08:00 AM January 4, and today’s date is 05:00 PM January 7, a lag time value of 4320 will sync the inventory from 08:00 AM January 1 to 05:00 PM January 4.
6. In the Select the Amazon (FBA) warehouse location for sellable inventory setting, select the Amazon (FBA) warehouse location to track the sellable inventory. If you’re not using a different Amazon FBA warehouse location to track the damaged inventory, only the inventory records with disposition as “sellable” will be added to the inventory adjustment report. Tip: Do not use the same warehouse location to track both sellable and damaged inventory. When inventory is damaged, two adjustments are created: The first adjustment decreases the quantity from the sellable inventory location, and the second adjustment increases the quantity in the damaged inventory location.
7. In the Select the Amazon (FBA) warehouse location for damaged inventory setting, select the Amazon (FBA) warehouse location to track damaged inventory. If you do not select any location for tracking your damaged inventory, the inventory adjustment report will only contain records with disposition as “sellable.” Tip: Do not use the same warehouse location to track both sellable and damaged inventory. When inventory is damaged, two adjustments are created: The first adjustment decreases the quantity from the sellable inventory location, and the second adjustment increases the quantity in the damaged inventory location.
8. Click Save.

Configure the import custom setting and run the flow

1. Go to Flows > Inventory (FBA).
2. Click on the Amazon (FBA) inventory adjustments to Business Central item journals (add) flow > Get inventory from Business Central lookup.
3. Scroll down to expand the Custom settings section.
4. In the Define criteria to search for a matching item in Business Central setting, customize the lookup criteria to search for an item in Business Central. The default value is No eq '{{decodeURI (split (encodeURI record.MSKU) "%0D%0A" 0)}}'. Ensure that the custom handlebar is in the following format: No eq {{your-handlebar-expression}}. For example, No eq {{record.ASIN}} or No eq {{record.custom_field}}. You can narrow your filter by combining additional conditions in this format, separated by “and” or “or”.
5. Next to the Amazon (FBA) inventory adjustments to Business Central item journals (add) flow, use the toggle button to enable the flow.
6. If you run the flow for the first time, a delta flow pop-up window is displayed. This helps you to sync the historical inventory adjustments.
   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.
      
      
7. 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

Amazon FBA inventory adjustment report

Amazon categorizes inventory adjustments by quantity and reason code. Following are the key terms:

• (- or +): type (- or +) in the quantity column denotes whether an adjustment is an increase or decrease to the inventory level.
• Reason: describes the type of adjustment made.
• Disposition: denotes the inventory disposition that represents the physical state of a product (unit or units).

Note: A single report can have multiple entries of the same item, reason, disposition, or Transaction-item-id. Based on the reason code and disposition, it is easy to identify if the inventory is sellable or damaged. The damaged state of a product might be for multiple reasons such as defective, customer damaged, distributor damaged, warehouse damaged, carrier damaged, or expired (if applicable). For more information about adjustment types, reason types, and reason descriptions refer to Inventory adjustments.

Microsoft Dynamics 365 Business Central item journal

After your run the Amazon (FBA) inventory adjustments to Business Central item journals (add) flow, a request is sent to Amazon and the inventory adjustments are sent in a CSV report. The Amazon (FBA) inventory adjustments to Business Central item journals (add) flow create an item journal in Microsoft Dynamics 365 Business Central. The flow syncs the following information to the item journal record:

• Posting date
• Location code
• Quantity (negative adjustment or positive adjustment)
• The event type in the “Celigo Amz event type” column
• The disposition in the “Celigo Amz disposition” column
• Celigo Amz reason
• Celigo eTail channel - Amazon