You can use the Amazon Inventory Adjustments feature to adjust the inventory of items in NetSuite at a specific location to reflect the inventory for these items in Amazon warehouses.
When you enable this feature, you have the option to either only receive inventory adjustment reports and then make the manual adjustment yourself, or also run an inventory adjustment sync to automatically update NetSuite with the inventory adjustments.
The inventory adjustment feature is an add-on feature that requires additional integration and ongoing fee. To add inventory adjustment sync to your account, contact your NetSuite account representative.
Setting Up the Inventory Adjustment Addon
When using Amazon Inventory Adjustments, there are several settings that need to be considered. You need to decide if you want to only receive inventory adjustment reports or if you want to also run inventory adjustment sync.
The leading practice when setting up Amazon Inventory Adjustments is as follows:
- Inventory Adjustment Settings
- Configuring Inventory Adjustment Mappings
- Testing Inventory Adjustment
- Setting up the Inventory Adjustment Scheduler
Configuring Inventory Adjustment Mappings
When you have Amazon Inventory Adjustments enabled, you can use the Inventory Adjustment transaction type to create inventory adjustment mappings in Amazon connector’s Mappings > Other Transactions.
You can map the following fields:
- Adjustment Account (required)
- Subsidiary
- Class
- Department
- Adjustment Location
To configure inventory adjustment account:
- Log in to app.farapp.com.
- Select the Amazon connector and the relevant account.
- Go to Mappings > Other Transactions.
- Click Add Mapping.
- In the Add NetSuite Mapping screen, select the Transaction Type, Adjustment Account.
- In NetSuite Field, select the internal ID of the NetSuite field that you want to set as the adjustment account.
- Click Add Mapping.
- Click Save.
Testing Inventory Adjustment
After setting up inventory adjustment settings and mappings, you need to ensure that the Inventory Adjustment Addon is properly configured before setting up the scheduler. You can do so by testing by using the Test Inventory Adjustments feature to check if the data can be properly retrieved and posted as needed.
To test inventory adjustment sync:
A success message is displayed. The transaction is posted to NetSuite and a report is sent to the configured email address. If you instead encounter an error message, rectify the error mentioned in the message then test again.
- Log in to app.farapp.com.
- Select the Amazon connector and the relevant account.
- Go to Settings > Addon Settings > Inventory Adjustments.
- Scroll down to the bottom of the screen, then click Test Inventory Adjustments.
- In the Test Inventory Adjustments window, enter an Item ID to test, then click Show Data.
- Verify the payload displayed in Output.
- Click Post Adjustments.
To test inventory adjustment report:
A success message is displayed. The report is sent to the email address configured. If you encounter an error message, correct the error mentioned in the message then test again.
- Log in to app.farapp.com.
- Select the Amazon connector and the relevant account.
- Go to Settings > Addon Settings > Inventory Adjustments.
- Scroll down to the bottom of the screen, then click Test Inventory Adjustments.
- In the Test Inventory Adjustments window, enter an Item ID to test, then click Show Data.
- Verify the payload displayed in Output.
- Click Send Report.
Setting up the Inventory Adjustment Scheduler
Before setting up the Inventory Adjustment Scheduler you need to:
- Ensure that the settings and mappings are properly configured
- Test if the inventory adjustment sync and discrepancy works with the configured settings
You can set inventory adjustments to run weekly or daily frequency.
To set up inventory adjustment schedule:
Note: The scheduler settings apply to all your accounts that use Amazon Inventory Adjustments.
- Log in to app.farapp.com.
- Select the Amazon connector and the relevant account.
- Go to Settings > Addon Settings > Inventory Adjustments.
- Under Advanced Options, use the following fields to set up your inventory adjustment schedule.
- Frequency – Select Daily or Weekly.
- Run at Time – Set the time when the scheduled task runs.
- Run on Day – This field is only available when Weekly frequency is selected. Set the day of the week when the scheduled task runs.