You can map integrator.io to use a custom or standard field to find an existing line. The custom field called eTail order Line ID, which is unique for all the lines in that record. You can use this field to find a matching line with the field value: For the mapping to eTail order Line ID, click… Continue reading How we can Provide a custom field as a key value to find a line item
Author: Magi Thomas
Replace all lines of a record in Celigo
In some cases, the source data may contain the complete order instead of just the delta changes. In others, some lines might be removed from the source system that are still in your NetSuite line items. Nonetheless, you might want to remove all the existing lines and add all the lines from your source data… Continue reading Replace all lines of a record in Celigo
Working of a cancel button using Suite Script
Cancel button is using the NetSuite for back to the record. We set the confirm messages using the Suitelet script. Most of the confirm messages has 2 options. One for accept the confirm message other for cancel . If we cancel the message ,the flow goes back to record
E-invoice using Clear tax integration
E-Invoicing E-Invoicing is mandatory to all businesses whose aggregate turnover has exceeded the Rs.20 crore limit w.e.f 1st April 2022. If a business’ turnover exceeds the prescribed limit in a financial year, it would be required to generate e-invoices from the beginning of the next financial year. For example, if the threshold turnover was exceeded… Continue reading E-invoice using Clear tax integration
How we can fix the amount up to two decimal point in Advanced pdf
<#function toCurrency value showSymbol=false> <#if value?is_number> <#local retval = 0> <#local retval = value?string[“#,##0.00”]> <#return retval> <#else> <#return value> Write this code before the style definition in the advanced pdf and use this function where we need to fix the ampunt For Example : <td colspan=”1″ align=”center” border=”.1″ style=”vertical-align: middle;border-top:1px;”>${toCurrency(item.quantity)}</td>
Convert date into specific format
Using this function, we can convert to date into defined format. Define the function in the script. function generateDateString(dateObj) { //convert date to specific format var date = dateObj; log.debug(“date”, date) var d = date.getDate(); log.debug(“d”, d); var m = date.getMonth() + 1; log.debug(“Month: “, m) var… Continue reading Convert date into specific format
Function to check the variable has value or not
Define the below mentioned function for check the variable has value or not. If variable has value, the function will return true. Otherwise, it will return false. function checkForParameter(parameter) { if (parameter! == “” && parameter! == null && parameter! == undefined && parameter! == false && parameter! == “null” && parameter! == “undefined”… Continue reading Function to check the variable has value or not
End points used for clear tax direct integration
There are mainly two important concepts for integrate with clear tax 1 E invoice integration 2. E way bill integration E invoice integration Below mentioned end points are used for integration Generate E invoice Generate IRN – ClearTax Docs Cancel E invoice Cancel IRN – ClearTax Docs Download E invoice Get E-Invoice PDF – ClearTax… Continue reading End points used for clear tax direct integration
Error parsing XML: the entity name must immediately follow the ‘&’ in the entity reference
Solution Firstly, we need to check, where we use the ‘&’ in the record . It may be billing address, shipping address, item name and Lot number in the inventory details . After that using the below mentioned code for replace the ‘&’ replace(/&/gi, ‘&’) || “”; For Example: var get_des = create_invoice.getSublistText({ sublistId: ‘item’, … Continue reading Error parsing XML: the entity name must immediately follow the ‘&’ in the entity reference
Error : “SyntaxError : Unexpected token: <” in the advanced pdf.
This error is to check for invalid XML characters [<, >, “, ‘, &] in the template. These characters need to be replaced with the corresponding Escape String as shown below. < < > > ” " ‘ ' & & Using the below mentioned function, we can solve the issue. function escapeXml(unsafe){ try{ if(unsafe) { log.debug(“inside… Continue reading Error : “SyntaxError : Unexpected token: <” in the advanced pdf.