Contents
- Understand how the flow works
- Read an inventory adjustment report
- Install the add-on
- Before you set up the flow
- Configure and run the flow
- Run the flow
- Find your adjustments in NetSuite
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).
|
Sample Inventory Adjustment report |
||||||||
|
adjusted-date |
Transaction-item |
fnsku |
sku |
Product |
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.
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.
- In integrator.io, click Amazon - NetSuite Integration App (SmartConnector) tile.
- Go to Settings > Integration flows > Inventory (FBA).
Configure basic settings
- 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.
Configure settings
Adjust your inventory
- Go to the Advanced Settings > FBA Inventory tab.
- 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.
- 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.
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.
- 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.
Run the flow
- 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.
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.
Comments
6 comments
In order to use this flow, does the SKU from Amazon always has to match with the Item name/number in NetSuite. We are using a custom field in NetSuite to map the SKU from Amazon since it does not match with the Item Name in NetSuite. When we ran the flow, we are getting an error saying that the matching SKU could not be found in NetSuite.
Could you please confirm if we are using a custom field to match SKU, we should still match the Amazon SKU to Item Name in NetSuite?
Hello Uday
The Order Import flow should also consider any Custom field provided you have correctly update the Item Lookup criteria in the flow. If you look into the mappings of Order Import flow, you would find a mapping for Items : Item (InternalId), where you can define the lookup as per the custom field which have the Item SKU.
Please try this out once and let us know if you any further information.
Hi Khaisar
The flow that I have a question about is in regards to the FBA Inventory adjustment flow and not the order flow.
Hello Uday,
Thanks for clarifying the flow. Yes, the same would apply for this flow as well. Please update the lookup criteria accordingly in the setting, "Define criteria to search the matching items in NetSuite", and as well enter the field Id of the custom field in NetSuite which is holding the Amazon SKU in the setting "Specify the item field ID that matches with Amazon SKU". No changes are required in mappings.
Please review this once and let us know if you are still facing the issue.
Hi Khaisar
I have updated the mappings and ran the flow but still encountering the same issue. The fnsku from Amazon matches with Amazon FNSKU filed on the item record in NetSuite.
Hello Uday
You are getting this error as the fieldID entered in "Specify the item field ID that matches with Amazon SKU" doesn't hold the SKU value i.e., "QB-32-05-90". In this setting you should enter the fieldID of the field which hold the SKU value. And it is required. that NetSuite Item should have this SKU in any of the field.
Please review this and let us know for any further queries.
Please sign in to leave a comment.