Add input filter for FBA inventory adjustments

Balasubramanian Mahadevan

Updated October 11, 2024 15:23

This article contains information on how to create an input filter and how you can add input filters based on event type, country, or fulfillment centers, when you run the Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments integration flow.

Add input filter for ‘Adjustments’ event type

When you run the Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments integration flow, you may find that records of all event types such as Shipments, Warehouse transfers, Receipts, etc., and not just ‘Adjustments’ event type are being added to NetSuite. To avoid this issue, we recommend you to add an input filter in the output source to sync only the ‘Adjustments’ event type records into NetSuite.

Important

The input filter needs to be added only if you have installed the

Amazon (FBA) Inventory Adjustments add-on recently or if the report type is displayed as:

 "reportType": "GET_LEDGER_DETAIL_VIEW_DATA"

You can check the report type in the following manner:

Access the flow builder
Click Export in the input source
The report type will be displayed in the What would you like to export? > HTTP request body section

To add the input filter, you need to modify the input data in the following manner:

Access the Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments integration flow.
In the output source tile, click Define options (+).

The Input filter button () will appear before the output source tile.
Click the Input filter button () to access the Define input filter dialog box.
To add an input filter for a node in the “record” object, remove the reference to the “items” array and the brackets and curly braces related to this array under the “record” object (lines 3, 4, 14, and 15 in the image above)

You will now be able to add the input filter in the Rules section of this dialog box.

To add the input filter for the 'Adjustments' entry type,

In the Rules section of the Define input filter dialog box, select the record.[Event Type] option from the options available in the drop-down list.
1. Click Settings () to the right of this field.
2. Select the Operand type as Field and Data type as String in the Operand Settings dialog box.
3. Click Save to confirm the changes.
Select the And operator to sync only ‘Adjustments’ event type into NetSuite.
Select the contains option in the drop-down list that appears after the record type is selected.
Enter the value as Adjustments in the text box that appears after the record type is selected.
1. Click the Settings () button to the right of this field.
2. Select the Operand type as Value and Data type as String in the Operand Settings dialog box.
3. Click Save to confirm the changes.
4. The input filter will be displayed as shown in the following image:
Click Save & close to confirm the changes made and return to the flow.
Run the flow and you will notice that only records with the ‘Adjustments’ event type will be synced to NetSuite. Records with all other event types will be ignored.

Add input filters for both ‘Adjustments’ event type and country / fulfillment centers

If you need to sync records related to both ‘Adjustments’ event type and country / fulfillment centers into NetSuite, you need to create an input filter as described in this section.

Important

You need to add the filter rule for ‘Adjustments’ event type before adding the filter rules for fulfillment centers for the integration flow to run successfully.

To add the input filter, you need to modify the input data in the following manner:

Access the Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments integration flow.
In the output source tile, click the Define options button (+).

The Input filter button () will appear before the output source tile.
Click the Input filter button () to access the Define input filter dialog box.
To add an input filter for a node in the “record” object, remove the reference to the “items” array and the brackets and curly braces related to this array under the “record” object (lines 3, 4, 14, and 15 in the image above)

You will now be able to add the input filter in the Rules section of this dialog box.

To add the input filter for the 'Adjustments' entry type,

In the Rules section of the Define input filter dialog box, select the record.[Event Type] option from the options available in the drop-down list.
1. Click the Settings () button to the right of this field.
2. Select the Operand type as Field and Data type as String in the Operand Settings dialog box.
3. Click Save to confirm the changes.
Select the And operator to sync only ‘Adjustments’ event type into NetSuite.
Select the contains option in the drop-down list that appears after the record type is selected.
Enter the value as Adjustments in the text box that appears after the record type is selected.
1. Click the Settings () button to the right of this field.
2. Select the Operand type as Value and Data type as String in the Operand Settings dialog box.
3. Click Save to confirm the changes.

To add the input filter for the country / fulfillment centers,

Click Add Group to add the filter rules for the country / fulfillment centers.

Note

You can add the input filter for either the country or the fulfillment centers but not both.
To know how to add the input filter for the country / fulfillment centers, see Add input filter for country or fulfillment centers

The input filter for the 'Adjustments' entry type and the fulfillment centers will be displayed as shown in the following image:

Input filter for ‘Adjustments’ entry type and country:

Input filter for ‘Adjustments’ entry type and fulfillment centers:
Click Save & close to confirm the changes made and return to the flow.
Run the flow and you will notice that the records will be synced to NetSuite only for the 'Adjustments' event type and the fulfillment centers whose fulfillment center IDs have been entered in the newly created input filter.

Add input filter for country / fulfillment centers

When you run the Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments integration flow, you may find that records for all countries and all fulfillment centers are being added to NetSuite. To avoid this issue, we recommend you to add an input filter in the Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments integration flow to sync records only for the country or fulfillment centers that you enter in this input filter.

Note

You can add the input filter for either the country or the fulfillment centers but not both.

To add the input filter, you need to modify the input data in the following manner:

Access the Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments integration flow.
In the output source tile, click the Define options button (+).

The Input filter button () will appear before the output source tile.
Click the Input filter button () to access the Define input filter dialog box.
To add an input filter for a node in the “record” object, remove the reference to the “items” array and the brackets and curly braces related to this array under the “record” object (lines 3, 4, 14, and 15 in the image above)

You will now be able to add the input filter in the Rules section of this dialog box.

To add the input filter for the country,

Select the And operator to sync only the records for the entered country code into NetSuite.
Select the record.[Country] option from the options available in the drop-down list of the Rules section in the Define input filter dialog box.
1. Click the Settings () button to the right of this field.
2. Select the Operand type as Field and Data type as String in the Operand Settings dialog box.
3. Click Save to confirm the changes.
Select the contains option in the drop-down list that appears after the record type is selected.
Enter the value as <country code> in the text box that appears after the record type is selected. For example, US for United States, CA for Canada, MX for Mexico, etc.
1. Click the Settings () button to the right of this field.
2. Select the Operand type as Value and Data type as String in the Operand Settings dialog box.
3. Click Save to confirm the changes.
The input filter will be displayed as shown in the following image:
Click Save & close to confirm the changes made and return to the flow.
Run the flow and you will notice that the records will be synced to NetSuite only for the country code entered in the newly created input filter.

To add the input filter for the fulfillment centers,

If only one fulfillment center ID needs to be added, select the And operator. If multiple fulfillment center IDs need to be added, select the Or operator.
Select the record.[Fulfillment Center ] option from the options available in the drop-down list of the Rules section in the Define input filter dialog box.
1. Click the Settings () button to the right of this field.
2. Select the Operand type as Field and Data type as String in the Operand Settings dialog box.
3. Click Save to confirm the changes.
Select the contains option in the drop-down list that appears after the record type is selected.
Enter the value as <fulfillment center ID> in the text box that appears after the record type is selected. For example, “ABC”, “XYZ”, etc.
1. Click the Settings () button to the right of this field.
2. Select the Operand type as Value and Data type as String in the Operand Settings dialog box.
3. Click Save to confirm the changes.
Click Add Rule to add details for another fulfillment center to the input filter and repeat the actions described in the steps above to add the details for the new rule added.

Note

You can add details of as many fulfillment centers as required by clicking Add Rule.

The input filter will be displayed as shown in the following image:
Click Save & close to confirm the changes made and return to the flow.
Run the flow and you will notice that the records will be synced to NetSuite only for the fulfillment centers whose fulfillment center IDs have been entered in the newly created input filter.

Related articles:

Sync your Amazon FBA inventory adjustments