Author: Bibin Thomas

Remove picked/packed items from the Picking ticket

//info: CDUS-1825 We have a requirement where the client only wants the items that have not yet been picked/picked to be printed on the picking ticket. In the normal functionality of NetSuite, only after item fulfillment or the item is shipped, the item will be removed in the picking ticket print which is available under… Continue reading Remove picked/packed items from the Picking ticket

Add a field to a SO record and print it with a Basic PDF Template.

//Info: CDUS-1599 We need to add a field (CSR) to the Sales Order Record and make it available on the printing page. Because the transaction form was Basic, we needed to customize things in the related form. The field that needs to be added comes from the customer record and is an entity field. Solution:Step… Continue reading Add a field to a SO record and print it with a Basic PDF Template.

Memo field multi-function in Main Line vs Line Level

//Info: CDUS-1491 When listing transactions, we usually set the main level to True to display one row per transaction and omit the line item details.We have set some criteria in the saved search to distinguish the orders based on the memo field value. For eg: Later, it was mentioned that the line level fields should… Continue reading Memo field multi-function in Main Line vs Line Level

Transaction Email Attachment Format impact in Email Template

//Info: APPN-2028 After updating the Advanced Pdf templates, we need to set this in Transaction forms to preview the result in Associated Prints.If we want the same print as the Email attachment, we usually select the same template in the Email template section. But, Is the issue solved..? The answer is No! We need to… Continue reading Transaction Email Attachment Format impact in Email Template

Search formula to find the length of a string which contains both char & int together

//Info: NFCC-31 We came across a situation in which we needed to determine the length of an entity record’s external id. The External id field’s value is a combination of characters and integers. By default, in a saved search, selecting Formula(Numeric) as criteria and then adding Function as length, Field, etc. results in LENGTH(char)externalid. The… Continue reading Search formula to find the length of a string which contains both char & int together

Error: A contact record with this name already exists. Every contact record must have a unique name

//Info: NFCC-25 This was an error that occurred while importing the referral file into Netsuite via the Celigo integration.Mapping was performed on contact record fields such as Name, Address, External ID, and so on. We later discovered that the External Id we were attempting to map to the contact record had already been used in… Continue reading Error: A contact record with this name already exists. Every contact record must have a unique name

Add Applied promotions only to the Picking Ticket Template

//Info: TPNC-785 We came into a scenario where we have to add the Promotion table data available under the Sales order to the Picking Ticket Template.In most cases, we normally add an Item table which is followed by checking the condition, What If, in cases where we have to check both the Promotion section content… Continue reading Add Applied promotions only to the Picking Ticket Template

Copy Expense Memos to Invoices

//Info: SWFT-252 There is a requirement to Copy the Memo field value from the Expense memo to invoices which can be seen under the Invoice Billable Customers. Navigation: Transactions > Customers > Invoice Billable customersSelect a customer Invoice from the List. Here, we need to auto-populate the Memo field. (Items > Billable_Expenses)By default, Netsuite set… Continue reading Copy Expense Memos to Invoices