Articles in this section

Assign status details to Amazon inventory

Gogula R Bhavana
Updated

You can assign inventory status for a line item that has different statuses. To assign inventory detail, you have to configure sub-record mappings to the following flows:

Before you configure your Integration App, enable the Inventory Status setting ( Setup > Company > Enable Features > Items & Inventory tab > Inventory sub-tab) in your NetSuite account. You can configure separate mappings for the inventory adjustments to know the status of inventory details lines.

Configure the sub-record mapping

  1. Login to your integrator.io account.

  2. Click on the Amazon-NetSuite Integration App tile.

Amazon (FBA) Order to NetSuite Order Add

  1. Go to Flows > Order .

  2. Click on the " Amazon (FBA) Order to NetSuite Order Add " flow to navigate to the “flow builder” page.

  3. On the flow builder page, below "Amazon (FBA) Order Import Adaptor", click Import .

  4. Configure import settings:

    1. On the “Edit Import” window, below the “How would you like the data imported?” field, click +Add subrecord .

    2. On the “Add subrecord import” window, from the "Which Cash Sale field should this subrecord set?" drop-down list, select Items: Inventory Details.

    3. In the “Path to node that contains item data” option, select items .

    4. Click Save on the “Add subrecord import” window.

    5. Click Save on the “Edit Import” window.

  5. Configure field mappings:

    1. On the flow builder page, next to the appropriate Import icon, click on the Field Mappings icon.

    2. On the “Please select which mapping you would like to edit” window, select NetSuite Credit Memo Import - Items: Inventory Details (Subrecord).

    3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.

      Export Field (HTTP)

      Import Field (NetSuite)

      Select the default status which we want to assign it to the line items

      Inventory Detail: Status (InternalId)

      quantity

      Inventory Detail: Quantity

      “true”

      Inventory Detail: Replace All Lines

NetSuite Settlement Transaction to NetSuite Refund

  1. Go to Flows > Refund .

  2. Click on the " NetSuite Settlement Transaction to NetSuite Refund " flow to navigate to the “flow builder” page.

  3. On the flow builder page, below "NetSuite Credit Memo Import", click Import.

  4. Configure import settings:

    1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord .

    2. On the “Add subrecord import” window, from the "Which Refund field should this subrecord set?" drop-down list, select Items: Inventory Details.

    3. In the “Path to node that contains item data” option, select items .

    4. Click Save on the “Add subrecord import” window.

    5. Click Save on the “Edit Import” window.

  5. Configure field mappings:

    1. On the flow builder page, next to the appropriate Import icon, click on the Field Mappings icon.

    2. On the “Please select which mapping you would like to edit” window, select Amazon (FBA) Order Import Adaptor - Items: Inventory Details (Subrecord).

    3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.

      Export Field (HTTP)

      Import Field (NetSuite)

      Select the default status which we want to assign it to the line items

      Inventory Detail: Status (InternalId)

      quantity

      Inventory Detail: Quantity

      “true”

      Inventory Detail: Replace All Lines

Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments

Important

Prerequisite: Dynamic mapping is added to consider the mappings in the specified order (mappings that are dependent on the previous mapping value). I n the Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments flow >Post Inventory Adjustments to NetSuite import,

  • Ensure to add the body-level mappings in the below-specified order sequence:

    1. Use Dynamic Mode

    2. Subsidiary (InternalId)

    3. Adjustment Account (InternalId)

      1971_FBA_Inventory_adjustments_mapping.jpg

  • Ensure to add the below line-level mappings in the below-specified order sequence:

    Export field (Amazon MWS)

    Import field (NetSuite)

    items[*].id

    Adjustments : Item (InternalId)

    items[*].disposition

    Adjustments : Location (InternalId)

    items[*].quantity

    Adjustments : Item (InternalId)

  1. Go to Flows > Inventory (FBA) add-on .

  2. Click on the " Amazon (FBA) Order to NetSuite Order Add " flow to navigate to the “flow builder” page.

  3. On the flow builder page, below "Post Inventory Adjustments to NetSuite", click Import.

  4. Configure import settings:

    1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord .

    2. On the “Add subrecord import” window, from the "Which Inventory Adjustment field should this subrecord set?" drop-down list, select Adjustments: Inventory Details.

    3. In the “Path to node that contains item data” option, select items .

    4. Click Save on the “Add subrecord import” window.

    5. Click Save on the “Edit Import” window.

  5. Configure field mappings:

    1. On the flow builder page, next to the appropriate Import icon, click on the Field Mappings icon.

    2. On the “Please select which mapping you would like to edit” window, select Post Inventory Adjustments to NetSuite - Items: Inventory Details (Subrecord).

    3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.

      Export Field (HTTP)

      Import Field (NetSuite)

      Select the default status which we want to assign it to the line items

      Inventory Detail: Status (InternalId)

      quantity

      Inventory Detail: Quantity

      “true”

      Inventory Detail: Replace All Lines

Amazon Delivered Shipments to NetSuite Item Receipt

  1. Go to Flows > Shipment (TO) add-on .

  2. Click on the " Amazon Delivered Shipments to NetSuite Item Receipt " flow to navigate to the “flow builder” page.

  3. On the flow builder page, below "Post Item Receipt to NetSuite ", click Import.

  4. Configure import settings:

    1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord .

    2. On the “Add subrecord import” window, from the "Which Item Receipt field should this subrecord set?" drop-down list, select Items: Inventory Details.

    3. In the “Path to node that contains item data” option, select items .

    4. Click Save on the “Add subrecord import” window.

    5. Click Save on the “Edit Import” window.

  5. Configure field mappings:

    1. On the flow builder page, next to the appropriate Import icon, click on the Field Mappings icon.

    2. On the “Please select which mapping you would like to edit” window, select Post Item Receipt to NetSuite - Items: Inventory Details (Subrecord).

    3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.

      Export Field (HTTP)

      Import Field (NetSuite)

      Select the default status which we want to assign it to the line items

      Inventory Detail: Status (InternalId)

      quantity

      Inventory Detail: Quantity

      “true”

      Inventory Detail: Replace All Lines
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.