Sync your Amazon FBA inventory adjustments

In the Amazon (FBA) warehouse there might be multiple reasons for a loss or damage of inventory. To account for the loss, adjustments are made to the inventory levels in the Amazon (FBA) warehouse on a daily basis. 

With the FBA Inventory Adjustments add-on, you can make sure that the lost or damaged inventory is automatically accounted for using the "Amazon (FBA) inventory adjustment to NetSuite inventory adjustment" flow. You can manage your inventory and ensure all the adjustments are reported in NetSuite. 

Understand how the flow works

The “Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments” add-on flow allows you to manage, maintain, and track your available inventory levels in NetSuite. It also categorizes sellable vs damaged inventory based on the disposition given by Amazon. The flow automatically syncs Amazon (FBA) adjustment data to NetSuite. 

The flow imports the inventory adjustment to NetSuite 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, there should be a 30-minute time lag for Amazon to generate the updated version of the report.

The supported and unsupported items in this add-on:

• Supported: 
  • Inventory items
  • Matrix items
  • Kit and Assembly items
• Not Supported (NetSuite limitation): 
  • Serialized items
  • Lot Numbered items
  • Item aliases
    Note: Item Alias concept is not applicable to MCF because it does not deal with catalog management. The orders come different sales channel and the line is pointed to single SKU in the Amazon Warehouse.

See the add-on data flow

The flow fetches the Inventory Adjustment report from Amazon and creates the Inventory Adjustment record(s) in NetSuite as follows:

Note: NetSuite allows only 1000 lines in a single adjustment record. If an adjustment report contains more than 1000 lines, then the flow creates multiple inventory adjustment records, with each record of 1000 lines.

To understand more about add-ons, refer to Understanding integration app add-ons.

Read an inventory adjustment report

Amazon categorizes inventory adjustments by quantity and reason code. 

Understand 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 of 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.

Install the add-on

You can install this add-on from the "Subscriptions" section of your Integration App. For more information on how to install add-ons, refer to Add-Ons.

Before you set up the flow

Before you configure or install the add-ons, in NetSuite, add the “Adjust Inventory” permission to the native “Celigo eTail SmartConnectors” role or to any other appropriate custom role.

Configure and run the flow

1. In integrator.io, click Amazon - NetSuite Integration App (SmartConnector) tile.
2. Go to Settings > Integration flows > Inventory (FBA).

Configure basic settings

1. Enable the “Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments” flow.
2. In the flow’s Settings, check the Select a start date for this flow box to select a start date for this delta flow. There is no impact on the scheduled run time if you check this box.
   

   Recommended: If you run this flow for the first time, select the check box to fetch the historical adjustments. Refresh the page after you check this box.

3. Click Save.

Configure settings

Adjust your inventory

1. Go to the Advanced Settings > FBA Inventory tab.
2. In the Define criteria to search the matching items in NetSuite field, define the lookup criteria to search the matching items in NetSuite. For example, by default, you can define the lookup criteria where Item name (Name(internal)) matches the "SKU" coming from Amazon and is in the "active" state.
3. In the NetSuite inventory adjustment account setting, choose an account to map the inventory adjustments. The account you select in this setting is synced to the Adjustment Account field on the NetSuite inventory adjustment record. 
4. In the Specify the Item field's Field ID that matches with Amazon SKU field, specify the NetSuite field ID that matches with the Amazon SKU. You can specify only one Field ID.
5. Click Save.

Adjust your locations

Recommended: Select different warehouse locations to track your sellable and damaged inventory. When inventory is damaged at the Amazon fulfillment center, two adjustments are created. The first adjustment is created to decrease the quantity from the sellable location and the second adjustment is created to increase the quantity in the damaged inventory location. 

1. Go to FBA Locations. 
2. From the Select the FBA warehouse location for sellable inventory drop-down list, select the warehouse location to track your sellable inventory. 
   : The location you choose here should match with the location in the “Select inventory location present in NetSuite” advanced setting for the “Amazon (FBA) Order to NetSuite Order” flow.
3. From the Select the FBA warehouse location for damaged inventory drop-down list, select the warehouse location to track your damaged inventory. If you do not select a warehouse location, the Inventory Adjustment record will contain records only for the sellable (disposition) inventory.
4. Click Save.

Run the flow

1. Run the “Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments” flow.
2. A new pop-up window opens to select any custom date to import any previous FBA inventory adjustment reports.
   
   
3. Click Run.

Find your adjustments in NetSuite

After you run the “Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments” flow, the flow creates inventory adjustment record(s) in NetSuite. Based on the configured flow’s mappings, the flow displays the following in the Adjustments section:

• quantity in the “Adjust Qty. By” column. 
• inventory adjustment reason in the “Celigo Amazon Reason Code” column.

Note: You can configure the “Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments” flow’s field mappings to display other inventory adjustment report fields such as “disposition” and “fulfillment-center-id” to NetSuite custom fields.  

Sync negative inventory adjustments for the bin numbered items if the Use Bins checkbox is unchecked for NetSuite locations

NetSuite limitation: If the Advanced Bin/Numbered Inventory Management check box (Setup > Company > Enable Features page > Item and Inventory tab) is unchecked, you'll not be able to see the Use Bins check box on the location.

To maintain accurate inventory in Amazon and NetSuite, the Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments flow syncs negative adjustment even if the required quantity is not available in the NetSuite location. For a NetSuite location, if the Use Bins checkbox is unchecked, and the inventory status is disabled, the flow syncs the negative inventory adjustment even if the required quantity is not available in the respective location. For serialized or lot numbered items, 

• If the adjustments are less than the available quantity, then the flow adjusts the quantity without any error.
• if the adjustments are more than the available quantity, then an error message is displayed.