Scenario: Automatically create fixed assets from Bills/Journals when these records are created in Netsuite Solution: When a vendor bill/journal creates corresponding fixed asset records will be created automatically if the line count is less than 10. //JJ UE FA Automation QG-118.js //JJ CS Validations for FA Creation QG-119.js Vendor bill Example:
Tag: NetSuite customization
Navigation from One suitelet to Another suitelet
Scenario: By clicking from a suitelet it need to be navigate to another Suitelet Solution: Every elements in the suitelet can be added by using usual suitelet form and form elements. To navigate from a suitelet to another you can use window.location.href, along with URL. In this example, projects are listing and according to the… Continue reading Navigation from One suitelet to Another suitelet
Showing values of a field according to the values of another field using Suitelet
Scenario: There can be one or more tasks can be for a project. Here We are listing projects and It has to list the project tasks of selected project using a suitelet. Solution: //JJ SL Suitelet.js //JJ CS Validations.js
Excluding Inactive values from a list in a custom field
Scenario: We have a custom field ‘Asset type Department’, which is a list/record field. it lists departments. There are some inactive departments are there. We need to filter out these inactive departments from the list. This field is sourcing from Employee record. Solution: Open the custom field setup page 2. Go to Sourcing & Filtering… Continue reading Excluding Inactive values from a list in a custom field
How to update Matrix item by Using CSV import
The CSV file containing your matrix items data should include columns that map to the following fields. For best results, set the column headers to match these field names. External ID: Recommended for all CSV imports, to serve as a unique identifier for each record. Item Name/Number: Name for each matrix item. Matrix Type: Possible… Continue reading How to update Matrix item by Using CSV import
Commerce Categories
Commerce Categories For creating a Commerce category you’ve to first Create a Commerce Catalog. Commerce categories are managed in the context of a commerce catalog. Navigate to Commerce > Content Management > Commerce Catalogs > New and enter the following: Site Name Name DESCRIPTION – Enter a meaningful description for the catalog. Save the record… Continue reading Commerce Categories
How to add Matrix item in NetSuite by CSV import
For adding matrix item we’ve to follow some steps during mapping in the NetSuite and while creating CSV files. We’ve add Item Name/ Number column in the NetSuite and if we add this then it’ll be the Matrix item External ID Item Name/Number SKU Description Category Class Subsidiary Department Location Price Level (Req) 1 Price… Continue reading How to add Matrix item in NetSuite by CSV import
Auto journal creation & application in Payment
Scenario: Create a journal for applying in the credit section of the payment. Ultimate need is to capture the credit info from the custom record, need to create a journal or custom transaction of journal type then apply the same in the payment record.We have seen a limitation of once payment is saved the credit… Continue reading Auto journal creation & application in Payment
Commission Report On Dashboard
Requirement To set up the dashboard to display the commission reports based on the market managers and regional managers. Solution Its not possible to setup a Dashboard using single saved search. So What we have to do is combine multiple saved searches to calculate commissions and setting up dashboard. So we can approach custom records… Continue reading Commission Report On Dashboard
Item Sorting
The order in which items display in your website can make a big difference in regards to your eCommerce sales numbers and profitability, so we can sort items according to relevance, best seller, pricing, etc. For the go to netsuite admin > commerrce > website > website list > search index > sort field >… Continue reading Item Sorting