When implementing new functionalities to send emails, we have to be careful about the NetSuite limitation. A maximum of 10 recipients (recipient + cc + bcc) is only allowed. If we are only chunking the recipients, the cc and bcc will receive the same email more than once. So for tackling this scenario, we have… Continue reading Chunking of entire recipients+cc+bcc to avoid exceeding the 10 (recipient+cc+bcc) limit
Month: June 2023
How to Identify Altready printed Transactions in Netsuite with User Event Script
In Netsuite, you can easily identify transactions by using a User Event script with a beforeLoad function. This script allows you to flag a record with a custom field when the print context is triggered. By setting this custom field, you can keep track of which transactions have been printed or are being printed. In… Continue reading How to Identify Altready printed Transactions in Netsuite with User Event Script
Giving field-level permission for particular roles
In NetSuite records, if we are creating a custom field that should only be edited by employees with a particular role, then add the roles with the sufficient access level needed.
Transactions that are triggering the costing calculation in NetSuite
List of transaction types that are inventory affecting and flag an item for costing has been listed below
How to add GROUP BY clause to a Sequelize find method
In Sequelize, you can add the group option in your query method findAll() to add the GROUP BY clause to the generated SQL query.For example, suppose you have a Users table with the following data: Now you want to select all firstName values and group any duplicate values of the column. Here’s the code for… Continue reading How to add GROUP BY clause to a Sequelize find method
Points to be noted while deploying Workflow using SDF
We have different methods o deploy a workflow from sandbox to production. The methods can be manual creation, Suite Bundler, Copy to account or SDF method. While deploying a workflow to production, keep note of the following points. If the workflow has dependency fields that are created on the sandbox and not yet in the… Continue reading Points to be noted while deploying Workflow using SDF
Intraday Ordering in NetSuite
When costing is run, the Netsuite reorders the items to avoid underwater selling on the the same day and an illustration has been attached below
Enabling Landed Cost Allocation per Line
To use Landed Cost Allocation on individual lines, you must first enable the preference. To set the Landed Cost Allocation per Line Preference: Go to Setup > Accounting > Preferences > Accounting Preferences. Click the Order Management subtab. Check the Landed Cost Allocation per Line box.Note When this preference is enabled, all new item receipts, credit card charges, vendor bills, and… Continue reading Enabling Landed Cost Allocation per Line
Credit Memos in NetSuite and their financial impact
Customer Credit Memos A credit memo is a transaction that decreases the amount a customer owes you. You can use a credit memo to reverse a charge you billed to a customer. For example, a customer returns part of an order after you’ve issued an invoice. Enter a credit memo to decrease the amount of… Continue reading Credit Memos in NetSuite and their financial impact
POST Request With Response using AJAX
jQuery provides several methods for AJAX functionality. With the jQuery AJAX methods, you can request text, HTML, XML, or JSON from a remote server using both HTTP Get and HTTP Post – And you can load the external data directly into the selected HTML elements of your web page! The ajax() method is used to… Continue reading POST Request With Response using AJAX