Author: Manikandan TM

INVALID_RECIPIENT on posting a Journal Entry

It’s hard to say exactly what the issue is without taking a deeper look at your account. The INVALID_RECIPIENT error code description is “Recipient internal id does not match an existing entity.”, meaning that you’re trying to email someone and it’s not matching an existing employee/vendor/customer/contact record with an existing email. Upon first glance I… Continue reading INVALID_RECIPIENT on posting a Journal Entry

Sales Transactions – Billing Status ‘Open’ does NOT show unmatched journals

NetSuite users often face a common issue where journal entries are marked as closed in the Billing Status, even before being matched to any invoices. This occurs because NetSuite considers a journal entry closed upon posting, regardless of its invoice matching status. While this behavior cannot be changed within NetSuite, there are practical workarounds to… Continue reading Sales Transactions – Billing Status ‘Open’ does NOT show unmatched journals

How to horizontally display item details in NetSuite Advanced PDF.

<#if record.item?has_content> <table style=“width: 100%; margin-top: 10px;”><!– start items –><#list record.item?chunk(3) as items> <tr> <#list items as item>   <td>   <table> <tr><#if item.custcol_image_url?has_content> <td align=“center” colspan=“4”> <img src=“${item.custcol_image_url}” style=“width:2.5%; height:2.5%; margin: 5px” /></td> </#if> <#if !item.custcol_image_url?has_content> <td align=“right” colspan=“4”> </td> </#if></tr> <tr><td>Model: ${item.item}</td></tr> <tr><td>Size: ${item.custcol_item_size}</td></tr> <tr><td>Quantity: ${item.quantity}</td></tr> <tr><td>Price: ${item.rate}</td></tr> </table> </td> </#list> </tr> </#list><!– end items… Continue reading How to horizontally display item details in NetSuite Advanced PDF.

SNIPPET TO CREATE A DELAY IN A SERVER SIDE SCRIPT

Please be aware that the provided code uses a busy-wait mechanism, considered an antipattern and discouraged. This method involves a loop continually checking the system clock until the specified duration passes. While it works as a makeshift alternative, it’s crucial to use caution and explore other solutions when available. Here’s the function for your reference:… Continue reading SNIPPET TO CREATE A DELAY IN A SERVER SIDE SCRIPT

How do you load a dataset and then add conditions?

// Load dataset var myLoadedQuery = query.load({ id: ‘custworkbook237’ }); // Add joins var mySalesRepJoin = myLoadedQuery.autoJoin({ fieldId: ‘salesrep’ }); // Add the condition var thirdCondition = mySalesRepJoin.createCondition({ fieldId: ’email, operator: query.Operator.START_WITH_NOT, values: ‘foo’ });

When calling the Suitelet API, I’m encountering the ‘SSS_INVALID_HEADER’ error.

Suitelet Response HTTP Header Restrictions In addition to the headers outlined in the General Blocked HTTP Headers section, certain headers cannot be manually set when interacting with the http.ServerResponse objects sent by Suitelets. Attempting to set values for any of these headers will result in an SSS_INVALID_HEADER error. The restricted headers are listed below: Allow… Continue reading When calling the Suitelet API, I’m encountering the ‘SSS_INVALID_HEADER’ error.

Suitelets and UI Object Best Practices

The following are best practices for Suitelet development using UI objects and custom UI. General Suitelets are ideal for generating NetSuite pages (forms, lists), returning data (XML, text), and redirecting requests.Limit the number of UI objects on a page (< 100 rows for sublists, < 100 options for on demand select fields, < 200 rows… Continue reading Suitelets and UI Object Best Practices

Scheduled Script Best Practices

The following are best practices for scheduled scripts. Genaral guidelines: You should set your scheduled scripts to run during the hours of 2 AM to 6 AM PST. Scripts set to run during the hours of 6 AM to 6 PM PST may not run as quickly due to high database activity. The number of Not… Continue reading Scheduled Script Best Practices