Author: Magi Thomas
Create a dynamic lookup in Celigo
Click the mapping button in the center of the import step. The Edit mapping window opens. Click the Settings button next to the field you are mapping. The Settings window opens. In the Field mapping type section, click Lookup. Select Dynamic search in the Options section. Enter the Relative URI. Select an HTTP method. Enter the Resource identifier path. Enter a unique value in the Name field so that you can identify… Continue reading Create a dynamic lookup in Celigo
Create multiple item fulfilment in the NetSuite using Celigo
Create export for read the sales order details from the NetSuite and create lookup to get the shipment details from the shipbob(third party). In the response mapping of the lookup, assign the data to lineDetailsLookup In the Import side, click the one to many option yes and mention the response mapping in the path field… Continue reading Create multiple item fulfilment in the NetSuite using Celigo
Create a file in the filecabinet
How we can read the data from XML format
Xml code =
Convert time to Uk time
Error: ‘Inventory Revaluation is no longer the first transaction in the item’s history’.
This error occurred when we tried to create inventory adjustment first time for an item. You need to create inventory cost revaluation to solve the issue. Go to Transaction> Inventory> Revalue Inventory Cost> New. Create inventory cost revaluation. After that, you can create inventory adjustment in the NetSuite. .
Replace special characters in Script
How we can add filter to the saved search and replace existing filter using script
Equation to convert the unit to base unit in workbook
Convert the backordered quantity to it’s base unit Backordered qty = {tranline.quantitybackordered}/{tranline.item^item.stockunit.conversionrate}