I just wanted to share with you a User Event script that I had written to add the currencysymbol to the numbers in the Totals box, found on Estimates, Bills, and Sales Ordersamong others. It assumes that the current locale/currency is prefixed to the value ratherthan suffixed (as in some situations) but this can be… Continue reading Adding a currency symbol to the Totals box
Month: January 2022
Troubleshoot an Unexpected Error on Saved Search
Below is the list of the possible reasons why we run an error while running a savedsearch. Check if the search is from a bundle. Clear browsing history. Check the Criteria used. Isolate the fields you want to populate. Check if there is a formula/custom field. Correct the formula and resubmit. Check if the Administrator… Continue reading Troubleshoot an Unexpected Error on Saved Search
Create a Report that shows Unapproved Bills and Next Approver
Here are the steps to accomplish this by creating a Saved Search: Navigate to Transactions > Management > Saved Searches > New Select Transaction as the Search TypeThese would be the settings of the search.Criteria tab > Standard subtab:● Type is Bill● Main Line is true● Status is Bill:Pending ApprovalResults tab > Columns subtab:● Transaction… Continue reading Create a Report that shows Unapproved Bills and Next Approver
Why You Need to Limit Concurrency for each Integration
You can limit the concurrency for each integration by following the steps: Navigate to Setup -> Integration -> Manage Integrations. Click the Integration you wish to edit the concurrency. Click Edit and change the Concurrency Limit to the desired value.Maximum concurrency limit is based from the available UnallocatedConcurrency Limit minus 1. Click Save. Managing the… Continue reading Why You Need to Limit Concurrency for each Integration
Interact with Backend Suitelet
In Netsuite Customization Client script executes in the logged-in user’s role. This can create errors while trying to access records for which the logged-in user doesn’t have the required permission. The solution is to call a backend suitelet from the client script. We suggest If you need to use that value in the client script for setting… Continue reading Interact with Backend Suitelet
Script Overriding Role Permissions
In the role setup, there will not be any permission to a record ie. create/view/edit/full access will not be provided. But we can essentially utilize the EXECUTE AS ADMIN in the server-side script deployment and set it to Administrator it runs the script with all privileges of Admin. For eg: If a particular role has… Continue reading Script Overriding Role Permissions
Updating Shipping Address Fields in Bulk
The phone number is not displayed in the SHIP TO address. But if we open the address sub-record it is there in the address fields. Unmark the Override Checkbox and hit save it sets the address phone number in the SHIP TO address. Instead of reselecting every address in each transaction, we are doing the… Continue reading Updating Shipping Address Fields in Bulk
Auto-Invoice
The script will create an invoice from the Item Fulfillemrnts for the same items & quantity shipped for a specific user and role. We are using the Sales Order transformation method for achieving this.
The consolidated report is not matching with the subsidiary balance sheet amount
The consolidated report is not matching with the subsidiary balance sheet amount
How to customize system emails
Customize system emails