Amazon – NetSuite release notes v1.20.5, April 2020

Note: The Integration App now automatically update integrations that are installed after the Amazon – NetSuite Integration App v1.17.0 release.

What’s enhanced

Auto-assign a number to the Serialized/Lot Numbered items in the FBA Inventory Adjustments add-on

The Integration App now offers an option to auto-assign a system-generated number to the Lot Numbered/Serialized items for the FBA Inventory Adjustments add-on. The following advanced settings are added to the FBA Inventory tab.

• Auto-assign number to Lot Numbered/Serialized items: This setting allows you to automatically assign inventory numbers to the Lot Numbered/Serialized items in NetSuite.
• For an adjustment increase, by default, a unique system-generated number is auto-assigned as inventory detail to the Lot Numbered/Serialized items.
• For an adjustment decrease, either the serial numbers that are created first or the lot numbered item numbers that are nearing expiry or the ones created first if the expiry date is unavailable is assigned and used for allocation.
• Add a prefix for Lot Numbered/Serialized items: This setting allows you to prefix a value to the unique system-generated number when adjustment is an increase. This is an optional setting and can be used as per your business need.

Assign detail for inventory with different statuses

The integration app now supports assigning inventory detail for inventory with different statuses. To assign inventory detail, you have to configure subrecord mappings to the following flows:

• Amazon (FBA) Order to NetSuite Order Add 
• NetSuite Settlement Transaction to NetSuite Refund
• Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments
• Amazon Delivered Shipments to NetSuite Item Receipt

For more information, see Assign inventory status details for Amazon inventory.

Support item aliases for the FBA Inventory Adjustments add-on

The FBA Inventory Adjustments add-on is now enhanced to support the item aliases.  

While processing each inventory adjustment record, if the item is not found in NetSuite with lookup criteria on item record, the Integration App now searches the “Celigo eTail item alias” custom record list using the item name. If a matching record is found using the item name, the integration app fetches the associated parent SKU and posts an adjustment line against the selected location.

Note: If SKU is not present on the item record in NetSuite and SKU is present on the “Celigo eTail item alias” custom record, the flow adjusts the quantity of the linked parent item.

Select the “Item aliases are configured in NetSuite” box in Integration Flows > Order (FBA) > Advanced Settings. When you run the “Amazon (FBA) Order to NetSuite Order Add” flow, the integration app looks for the items with the error message “ITEM_NOT_FOUND”. The filtered items with error messages are further searched using the “Celigo eTail item alias” list using the item name. If the items are found using the item name, an itemID is mapped to those filtered items. An adjustment is created to the original item.

Note: If the “Item aliases are configured in NetSuite” box is not selected, the integration app does not perform item search using the item name.

Support to sync Global Express information for orders in the US marketplace

The “Amazon (FBA/MFN) Order to NetSuite Order Add” flow(s) now supports to sync the global express information to NetSuite. For the US marketplace, if the “IsGlobalExpressEnabled” flag is enabled, it indicates that the order is generated through the Global Express program.

To sync this information, configure the following field mapping in the order flow.

For the value in the import field, you can create a custom field in your NetSuite account and map it in the “Import Field (NetSuite)”. By mapping the Custom Field, the global express information is displayed in the custom field in the NetSuite sales order. 

For more information on Amazon, refer here.

Support to sync additional order information if sold by Amazon Business in the Europe marketplace

The “Amazon (FBA/MFN) Order to NetSuite Order Add '' flow(s) now supports to sync additonal order information if it is sold by Amazon Business in the Europe marketplace. If the “IsSoldByAB'' flag is enabled for the Europe marketplace, it denotes that the order contains items that were bought and re-sold by Amazon Business EU SARL (ABEU).

To sync this information, configure the following field mapping in the order flow.

For the value in the import field, you can create a custom field in your NetSuite account and map its value in the “Import Field (NetSuite)”. By mapping the custom field value, the global express information is displayed in the custom field in the NetSuite sales order. 

For more information on Amazon, refer here.

Revised product category template as per Amazon latest changes

Clothing

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

What’s fixed

Sync inventory adjustments for Assembly items

The FBA Inventory adjustments add-on now syncs the inventory adjustments for Assembly items to NetSuite as expected. The fix is provided in the backend code.

Auto-billing flow to ignore the “eTail Line Canceled” lines 

The integration app now refers to the “eTail Line Canceled” field to identify the canceled line items on a sales order. If the “eTail Line Canceled” is selected for a line item, the “NetSuite Order to NetSuite Invoice/Cash Sale” flow(s) now ignores these lines while creating an invoice or a cash sale.

Taxes for "Marketplace Tax Collection" orders are excluded in the credit memo

When you select the Exclude Tax if Marketplace Tax Collection applies box in the General > Tax section, the taxes are now excluded in the sales order, invoice, and settlement records (payments and credit memo). Also, there will be no variance.

Tax only refund scenario should not get any variance

When you refund only the tax amount for an order with “NetSuite item to track Amazon Shipping amounts and taxes,” the Integration App does not calculate any variance in such scenarios.