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
-
Assembly
-
Lot Numbered
-
Serialized
-
Alias
Note
The item Alias concept is not applicable to MCF because it does not deal with catalog management. The orders come from different sales channels and the line is pointed to a single SKU in the Amazon Warehouse.
-
Matrix
-
Bin
-
Inventory status enabled
-
-
Not Supported (NetSuite limitation) :
-
Kit
-
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.
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).
|
Sample Inventory Adjustment report |
||||||||
|
adjusted-date |
Transaction-item -id |
fnsku |
sku |
Product -name |
fulfillment-center-id |
quantity |
reason |
disposition |
|
2019-07-31T00:00:00-07:00 |
9249864 |
X001K0P99R |
83542-01-N |
Wireless Headset |
RIC2 |
-1 |
M |
SELLABLE |
|
2019-07-31T00:00:00-07:00 |
92537164 |
B00EA07B0I |
506007-N |
Telephone Headset |
RIC2 |
1 |
F |
SELLABLE |
|
2019-07-31T00:00:00-07:00 |
92500164 |
B00EA07B0I |
506007-N |
Telephone Headset |
RIC2 |
-1 |
O |
SELLABLE |
|
2019-07-29T00:00:00-07:00 |
9869952533 |
B00O1ANTD0 |
201500-01-N |
Headset Mono |
FTW6 |
-1 |
O |
WAREHOUSE_DAMAGED |
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.
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 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.
-
In integrator.io, click Amazon - NetSuite integration app tile.
-
Go to Settings > Integration flows > Inventory (FBA).
-
Enable the “Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments” flow.
-
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.
-
Click Save .
-
Go to Settings > Inventory (FBA) > FBA Inventory.
-
In the Import event types into NetSuite setting, enter event types that must be imported into NetSuite. Records of event types entered in this setting will be imported into NetSuite and records of all other event types will be ignored. By default, the ‘Adjustments’ event type is added to this setting. You can add other event types as per your business requirements in a comma-separated format.
Important
The event types entered in this setting must match the event types existing in the report.
-
In the Define criteria to search the matching items in NetSuite field, define the lookup criteria to search the matching items in NetSuite.
Notice
By default, you can define the lookup criteria where the Item name (Name(internal)) matches the "SKU" coming from Amazon and is in the "active" state.
-
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.
-
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.
-
Click Save .
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.
-
Go to FBA Locations.
-
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.
-
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.
-
Click Save .
Recommended: We recommend you add an input filter in the “Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments” integration flow to sync records only for the 'Adjustments' event type and the country/fulfillment centers that you add to this input filter.
To know how to add input filters, refer Add input filter for FBA inventory adjustments.
-
Run the “Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments” flow.
-
A new pop-up window opens to select any custom date to import any previous FBA inventory adjustment reports.
-
Click Run.
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.
If the Inventory Status setting is enabled in your NetSuite account (Setup > Company > Enable Features > Items & Inventory tab > Inventory sub-tab), you will need to configure sub-record mappings to ensure that inventory status is assigned correctly.
For detailed steps, refer to Assign status details to Amazon inventory.