Amazon – NetSuite release notes v1.21.0, June 2020 – Celigo Help Center

Information: You can find the integrator.io release notes for May 2020 here.

What’s new

Manage your Amazon FBA order returns (add-on)

The FBA return management add-on allows you to manage your FBA returns for order items that are returned to the Amazon warehouses. This add-on also lets you track the returned sellable and returned damaged FBA inventory in NetSuite. The flow automatically syncs the Amazon FBA returns data to NetSuite as return authorizations (RA), followed by item receipts.

For more information, refer to Manage your Amazon FBA order returns (add-on).

What’s enhanced

Set up your GST/VAT requirement

The logic to calculate GST/VAT rate is enhanced. Previously, the “Deduct GST/VAT from order total” setting was available at a section-level. You can now set up your GST/VAT for all the applicable integration flows at the General section > Tax tab.

When you select the Enable GST/VAT for your marketplace box, the below two settings are enabled for your selection.

Apply GST/VAT rate reported by Amazon
GST/VAT rate to apply across all orders

Apply GST/VAT rate reported by Amazon

Select this option if Amazon explicitly provides tax details on the order. This amount will be reported on the NetSuite sales order, invoice, and settlement transactions (such as payments and credit memo). Along with the GST/VAT amount, Amazon also provides the “shipping discount tax” and “promotion discount tax.” The order flow also syncs the values precisely.

Enter GST/VAT rate to apply for all orders

The GST/VAT rate you provide here is considered to calculate taxes on all orders placed in this marketplace. The same rate is used to calculate shipping discount tax and promotion discount tax. The tax calculation logic is consistent in the settlement transactions. This will also add the tax to the item price during pricing and item sync if you enable the “Add GST/VAT to item price” setting.

Note: If you want to apply the GST/VAT rate to item price, make sure to enter the GST/VAT rate in the Enter GST/VAT rate to apply across all orders field.

For more information refer here.

Support Serialized/Lot Numbered items for the Transfer Order - InboundShipments add-on

The Transfer Order - InboundShipments add-on is enhanced to support Serialized/Lot Numbered items. When you create a child transfer order, the integration app now assigns the same inventory details that you manually assign while creating the parent transfer order. For item receipts, the inventory details are fetched from the child transfer order.

Support item aliases for the Transfer Order - InboundShipments add-on

The Transfer Order - InboundShipments add-on is enhanced to support item aliases. When you create a transfer order, the integration app now provides the capability to select an item alias associated with the Amazon SKU for each line item. You can have a single item in NetSuite and have multiple variations or aliases for the same. When you select the parent item, all the associated aliases are populated. In the Parent SKU field, select the Amazon SKU for the particular item. While processing the item receipt, the integration app checks for the Item ID. If no match is found, then check for the item alias in the alias record.

Note: Before you select an item alias associated with the Amazon SKU for each line item, modify the saved search, and configure the flow mappings. For more details, refer here.

Allocate FBA orders to multiple customers

Information: Due to NetSuite limitation, customer payments can’t be applied against an invoice when the customer has more than 10000 open invoices. This enhancement is a workaround for the NetSuite limitation. You might not have to enter multiple customers in the future after NetSuite provides a permanent fix.

The “Default NetSuite customer for all Amazon orders” setting (Order(FBA) > Advanced Settings > Customer) is enhanced as Allocate FBA orders to below NetSuite customer(s). This setting now allows you to allocate FBA orders to multiple customers so that any given customer does not have more than10000 open invoices for a settlement. You can configure the number of customer ID(s) based on the volume of data and frequency of the settlement flow.

In the above setting, enter the customer internal ID(s) in a comma-separated format. The FBA orders are allocated to the customers specified in this setting. The FBA orders are allocated in a cyclic way (round-robin manner).

For more information, refer here.

Calculate inventory as per the sale units to get the actual available quantity

The inventory in NetSuite is now calculated as per the “sale unit” to accurately allocate inventory and get the actual available quantity. Prior to this enhancement, the inventory was calculated as per the “base unit.”

To get the actual available quantity, add the following mapping to the “Amazon (FBA) Order to NetSuite Order Add” flow:

Export Field (HTTP)	Import Field (NetSuite)
“true” (hardcoded value)	handleUnits

Example: You can sell an item in kilograms or grams. One of these units will be a base unit and a sales unit. Assume kilogram is your base unit and 100 gram is your sales unit. Item A has 400 grams as an available quantity. As per the base unit, this item was converted to kilograms and the inventory was displayed as 0.4. But, as per the sale unit which is 100grams, the actual available inventory quantity should be displayed as 4. By adding the above mapping, the inventory is converted to display the actual available quantity.

Note: For inventory adjustments and transfer orders, we consider each quantity as a sale unit.

Support of Netherlands marketplace

Note: This marketplace is available in all editions of the integration app and add-ons.

The integration app is enhanced to support product categories in the Netherlands marketplace. You can now sync items related to the below categories and subcategories using the “NetSuite Item to Amazon Product” flow.

Home
- Art and Craft Supply
- Fabric
- Home
Office
- Art Supplies
- Writing Instruments
- Office Products
- Paper Products
Toys
- Toys and Games

Revised product category template as per Amazon latest changes

For the US marketplace, Amazon has updated the product category template for “Luggage” on March 26th, 2020. You can now map the below new fields in the “NetSuite Item to Amazon Product” flow’s product mappings.

Product Category Name	Field Name
Luggage	batteries_required bullet_point1 country_of_origin material_type package_height package_height_unit_of_measure package_width package_width_unit_of_measure package_length package_length_unit_of_measure package_weight package_weight_unit_of_measure product_description supplier_declared_dg_hz_regulation1 supplier_declared_material_regulation model_name item_type_name

New mapping added to the CA marketplace category template

For the CA marketplace, a new mapping “recommended_browse_nodes” is added.

Note: For the US marketplace we can recommend not to use this field because the behavior of the "Item Type Keyword" field is similar to the "recommended_browse_nodes" field.

Display the “eTail Original SKU” custom field for all item types

The “eTail Original SKU” custom field is now displayed for all item types including item aliases. This custom field is not present on the Celigo substitute items.

What’s fixed

Create inventory adjustments without any “UseBin” error

In your NetSuite account, irrespective of the Advanced Bin/Numbered Inventory Management setting (Setup > Company > Enable Features > Items & Inventory tab > Inventory section) enabled or disabled, you can now create inventory adjustments without any errors.

“Use Dynamic Mode” mapping should not create any discount variance

The discount item you select in the “NetSuite discount item to track Amazon discounts” setting has a value in the “rate” field in NetSuite. If the “Use Dynamic Mode” mapping exists or not, the actual promotion amount is not overwritten with the discount item “rate” value, and also no discount variance is created.