Author: Arnold Xavi

How to Highlight a Custom Review status field in Green Colour if the Review status is Approved and in Red Colour if the Review status is Pending Approval

Question: How to Highlight a Custom review status field in Green Colour if the Review status is Approved and in red Colour if the Review status is Pending Approval. Solution: Create a new Inline html transaction body field in SO and insert it after review status field and add the below below given formula as… Continue reading How to Highlight a Custom Review status field in Green Colour if the Review status is Approved and in Red Colour if the Review status is Pending Approval

How to Run a Suitelet script Upon clicking a Saved search custom Column button and how to pass the item data as parameters to suite let

In the saved Search result field add Formula(Text ) and in the formula session add the below html .In the html we can add the suitelet script link and we can pass item data as parameters. Below Added the html code. ‘<html><head> <style> .printbutton { background-image: linear-gradient(#fafafa, #e5e5e5); border: 1px solid #b2b2b2; border-radius: 3px; color:… Continue reading How to Run a Suitelet script Upon clicking a Saved search custom Column button and how to pass the item data as parameters to suite let

How to show email id instead of customer name in recipients column of undelivered email saved search

Question: How to show email id instead of customer name in recipients column of undelivered email saved search ? Solution: In the saved search results columns session use below mentioned formula as formula(Text) case when instr({recipients},'<‘)>0 then replace(replace({recipients}, substr({recipients},1,instr({recipients},'<‘)),”),’>’,”) else {recipients} end\

Solution for “An unexpected error has occurred” when viewing a Customer Deposit

Scenario: When a User uses the Make Copy button on a Sales Order with Customer Deposit, the deposit is also being copied to the newly created Sales Order. There are some cases where an error is thrown when opening the Customer Deposit either from the original or copied Sales Order. Due to this error, the User may not be able to… Continue reading Solution for “An unexpected error has occurred” when viewing a Customer Deposit

How to remove payment transactions which have errors from Payment file:

Transactions with errors cannot be processed using the same electronic bank payment file. You can unlink or remove them from the existing PFA record, so that they can be included in another set of payment transactions. To remove payment transactions which have errors: Go to Payments > Payment Processing > Payment File Administration. On the… Continue reading How to remove payment transactions which have errors from Payment file:

Inactivate Matrix Sub Item > Error: ‘You cannot apply new options to an individual child matrix item. Add new options to the parent matrix instead.’

When trying to inactivate a Matrix Sub Item, An error message was encountered.Error: ‘You cannot apply new options to an individual child matrix item. Add new options to the parent matrix instead.’ The reason is that there are discrepancies with the Item Options on the Matrix Sub Item and on the Parent Matrix. For example: Matrix… Continue reading Inactivate Matrix Sub Item > Error: ‘You cannot apply new options to an individual child matrix item. Add new options to the parent matrix instead.’

Resolve Error: “An unexpected error has occurred.” When Viewing Item List

ScenarioUser receives an unexpected error message when they open the Item List via List > Accounting > Items. Note: The error occurs, when the user customize the view of Item Lists and an incorrect syntax is added on the saved search. Solution1. Login to NetSuite Account2. Paste the link on the browser URL: https://system.netsuite.com/app/common/item/itemlist.nl?searchtype=Item&sortcol=Item_NAME_raw&sortdir=ASC&csv=HTML&OfficeXML=F&pdf=&showall=F&style=NORMAL&report=&grid=&searchid=-400&quicksort=&dle=T Note:… Continue reading Resolve Error: “An unexpected error has occurred.” When Viewing Item List