“Credit Memo not created. Cannot refund line item [Amazon SKU: XXXXXX, Amazon Order Item Code: XXXXXXXXX]. Please bill this line in NetSuite before importing its refund. Settlement details: Settlement Id# XXXXX, Amazon MFN Order# XXX-XXXXXXX-XXXXXXX.” error. Solution : When the NetSuite Settlement Transaction to NetSuite Refund Add flow is run to sync the refund transactions… Continue reading error: “Credit Memo not created. Cannot refund line item”
Author: Jismol Johnson P
Amazon IO Error – “Please enter a value for amount.”
Problem: The following error may appear for the Order FBA or MFN flow. It occurs when an item has no price associated with it in the Amazon order. This can occur when an item has to be reshipped by Amazon, but the customer is not being charged. Solution: Add the following mapping to the Order FBA… Continue reading Amazon IO Error – “Please enter a value for amount.”
Amazon refund credit memo created without shipping cost being refunded
Problem: The refund should include shipping and the tax on shipping. The credit memo is being created without the shipping being refunded. Solution: Enable Shipping Cost and Shipping Method Fields on the refund record. By exposing the Shipping Cost and Shipping Method, these amounts will get mapped and be adjusted, and the variance will not… Continue reading Amazon refund credit memo created without shipping cost being refunded
error:”failed to save record because invalid account reference key xxx for currency x”
While running the “NetSuite Settlement Transaction to NetSuite Refund Add” flow you may receive the error message: “failed to save record because invalid account reference key xxx for currency x. To resolve the error and sync data for your settlement refunds successfully , the following actions to be completed. 1.Select a currency for the settlement… Continue reading error:”failed to save record because invalid account reference key xxx for currency x”
syncing item inventory from NetSuite to Magento source
For an inventory item in NetSuite we can sync inventory from NetSuite to Magento by the following steps. 1.Create inventory adjustment for the required items. 2.Fetch the items to the saved search. 3.In the search result, consider the quantity of item BPVS as an example . 4.In its item record we can see the location… Continue reading syncing item inventory from NetSuite to Magento source
Add new location in inventory sync
The important steps to be performed in celigo while adding item inventory from a particular location in NetSuite to an inventory source in Magento for location by performing the following steps. 1.Add the NetSuite locations in celigo as shown 2.Map the NetSuite locations with Magento 2 sources. Then run the flow and we thus the… Continue reading Add new location in inventory sync
Error-“URL key for specified store already exists”
While working on NetSuite-Magento integration flow, this error occurs when exporting matrix subitems from NetSuite to Magento. When name of product is same at that time this error comes. Magento 2 automatically generate url key based on name but if the name is same then the error occurs. So check the name of product,if its… Continue reading Error-“URL key for specified store already exists”
Importing Your First Order from Magento Into NetSuite : Prerequisites
1.Ensure you have an SKU in Magento 2 that also exists in NetSuite with the same SKU name/number. If you don’t already have one, use the steps as follows: In Magento 2, Go to Products > Catalog > Add a product and create a new product and populate the “SKU” field as” celigo Test SKU 1″. In NetSuite,… Continue reading Importing Your First Order from Magento Into NetSuite : Prerequisites
Import Customers from Magento to NetSuite-Order imports fail if customer record with same ID already exists in NetSuite
Order imports into NetSuite sometimes fail when customer records with same Customer IDs are already present in NetSuite. You may see the following error: “Failed to add/update customer for order #1xx1. A customer record with this ID already exists. You must enter a unique customer ID for each record you create. To correct this record,… Continue reading Import Customers from Magento to NetSuite-Order imports fail if customer record with same ID already exists in NetSuite
error: You cannot create a purchase order and a work order for the same line. How to resolve?
The said error is shown when we are saving a new sales order with assembly item. To resolve this , go to customization>scripts>scripted records Then undeploy the script which is meant for dropship items and applied to sales order. For dropship items purchase order is created automatically when creating a sales order.Here the value of… Continue reading error: You cannot create a purchase order and a work order for the same line. How to resolve?