Hi @User_80C0N Please Hit the like / Awesome / Agree for the code comment I provided as a sign of gesture🙂 that would boost me for the time I spent for your requirement.

Got it!… im changing logic accordingly <#list record.item as tranline> <#assign itemName = tranline.item> <#assign serialNumbers = tranline.serialnumbers> <#assign itemIndex = -1> <#list salesorder.item as soItem> <#if soItem.type == 'Item' && soItem.item == itemName> <#assign itemIndex = soItem_index> </#if> </#list> <tr>…

If you could provide some screenshots to explain exactly what you're trying to achieve, I'd be happy to assist you if it's within my ability to do so. This could also benefit others who come across this query.

Hi @User_80C0N Try the below code and let me know: <#list record.item as tranline> <#assign itemIndex = 0> <#list salesorder.item as soItem> <#if soItem.type == 'Item'> <!-- for filtering out non-item lines --> <#if soItem.item == tranline.item> <#assign itemIndex = soItem_index> </#if> </#if> </#list> <tr> <td…

This isn't working as expected. It's pulling not just the subsidiary accounts for my country, but also the parent company's accounts. For instance, if I set up a tax account that's only applicable to my country, I should only see accounts created specifically for that country. However, the system is retrieving accounts…

Cracked the solution: Below are steps to execute —> Add a checkbox to the journal entry called “has been edited” Add a set field value on entry into rejected state to set the “has been edited” checkbox to UNCHECKED In the add button action add a condition of “has been edited” = T Add a set field value action that sets has…

What is the data you have in the account field in your CSV file? Are you using the long name or just the account number or are you using the Internal ID? Account Number alone does NOT work in CSV. You must have the full long concatenated string of the account number plus name and the name must be in the full parent: child…

Did you tried with other browsers? If you're still encountering the problem after switching browsers and attempting the same navigation, it's a good idea to check with other active Netsuite users to see if they're facing similar issues. If the problem persists for others, it's then recommended to reach out to Netsuite…

@Veronica I noticed Midhun's response, and I approached the task differently by utilizing the "system note" saved search. In contrast, Midhun employed a formula that incorporated the "system notes" as a field, which appears to be a more effective approach. It's great to learn something new. Thank you for sharing this…

Hi, Instead of using a transaction saved search, opt for the "System Note" saved search to count the number of sales order records transitioning from Pending Approval to any alternative status (such as Pending Fulfillment or Pending Bill), with the flexibility to include a date filter as per your specifications. Below are…

To filter the results to show only the lines where the formula returns 'T', you can use the saved search filters. Add a filter for the formula field with the condition set to "is" and the value set to 'T'. This will ensure that only the lines where the Bill To and Ship To addresses are different are displayed in the search…

This is not the appropriate solution we are looking for……We seek to establish a comprehensive backup solution for our NetSuite database, ensuring the replication of our entire account data to an external system/application hosted on Indian servers. This initiative is in compliance with government regulations aimed at…

You can use this Formula (Text): CASE WHEN {billaddress} != {shipaddress} THEN 'T' ELSE 'F' END Replace {billaddress} with the Standard NS entity field for the Bill To Customer and {shipaddress} with the NS Custom field ID for the Ship To Customer/End User.