Author: Manikandan TM

Enter Item Pricing in Item Record Results to Error: “Each Quantity pricing level must be greater than the previous quantity pricing level.”

Enter Item Pricing in Item Record Results to Error: “Each Quantity pricing level must be greater than the previous quantity pricing level.”     Issue: Enter Item Quantity Pricing in item record manually or via CSV Import 2. Save item record 3. Error: Each Quantity pricing level must be greater than the previous quantity pricing level •         The error… Continue reading Enter Item Pricing in Item Record Results to Error: “Each Quantity pricing level must be greater than the previous quantity pricing level.”

Update Field on Work Order from Sales Order via Script

Automatically updating a field on the Work Order from Sales Order via Suitescriptcould save you some time.Doing this on Suitescript by using aftersubmit function of User Event script thatwas deployed on the Work Order Record is one way.A sample of this is available in SuiteAnswers article id: 45149.Same scripting logic could be applied to other… Continue reading Update Field on Work Order from Sales Order via Script

Remove Parent Item Name in Saved Searches

When creating Item Saved Searches, the Name field displays the parent matrixitem name before the matrix child, (example: Parent Item : Matrix Child).The Ability to remove the parent matrix item in Inventory Reports is not availableyet in the system and Enhancement # 161435 has been filed requesting for this.As a workaround to display only the… Continue reading Remove Parent Item Name in Saved Searches

How to access sublist data in a suitelet

Suitelets allow us to create custom pages within NetSuite. One of the commonimplementations for a suitelet is getting data from a user and then processing the datafor display. To get and process the fields that are created in the suitelet, we useserver request.parameters to access the values of the fields. A sublist can also becreated… Continue reading How to access sublist data in a suitelet

Customize your Vendor/Customer Global Search Results to Show its Subsidiaries

Users usually determine the Primary and secondary subsidiaries by opening theVendor/Customer record and navigating to the classification section and subsidiariestab. If you think about it, that will require a lot of steps if you need to check on multiplerecords. So, here’s a tip that will make things easier for you! Instead of going over eachrecord,… Continue reading Customize your Vendor/Customer Global Search Results to Show its Subsidiaries

Vendor Bill error – “Your formula has an error in it…”

Encountering an error on the Approval Page of transactions may hinder users toperform bulk approval which can also prolong their daily tasks and processes.Users can mass submit for approve, reject, re-submit for approval in the ApproveVendor Bill Page if the Approval Routing = T. The Actions in the Approve Bills Page arethe actions from the… Continue reading Vendor Bill error – “Your formula has an error in it…”

Adding a currency symbol to the Totals box

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

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