A Pivot Table is an interactive way to quickly summarize large amounts of data. You can use a Pivot Table to analyse numerical data in detail, and answer unanticipated questions about your data. Moving rows to columns or columns to rows ( or “pivoting”) to see different summaries of the source data. HOW TO CREATE… Continue reading PIVOT TABLE IN EXCEL
Category: NS Implementation
All articles / code related to Netsuite implementation
How to work the formula even if some columns are blank in Saved Search
We can execute the formula even if some columns are blank in Saved Search using the following:-Navigate to1. Lists > Search > Saved Search > New 2. Select the Type of the search3. On the Results tab , Column Subtab;Field – Formula Numeric Formula : NVL({location on order},04. Save and Run
Rescheduling Tasks using scheduling script
Scenario: Example for rescheduling tasks using scheduling task For rescheduling, you need to import ‘N/task’ module first. It is needed for creating each rescheduling tasks after reaching the limit of remaining governance. You can just call this function whenever you want rescheduling. You can change the parameters of the function according the requirement. In this… Continue reading Rescheduling Tasks using scheduling script
Automatically creates Fixed Assets from Vendor bill/ Journal
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:
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
Resolve Lease Asset Modification Error: “The Transaction Date You Specified Is Not Within the Date Range of Your Accounting Period”
Scenario User modified a Lease Record dated on a closed period but Lease Modification’s effectivity date is on an open period. When they click Modify Lease Record Button, User gets the error: “The transaction date you specified is not within the date range of your accounting period”. Solution Open the Closed Period Navigate to Setup > Accounting > Manage… Continue reading Resolve Lease Asset Modification Error: “The Transaction Date You Specified Is Not Within the Date Range of Your Accounting Period”
Scheduled Email through Saved Search
Scheduled email serves a regular update on the saved search results. Saved search results mailed according to the scheduled and also gives alerts when there is any add or update. it can be sent from search owners email address, or default address as company preferred. and also we can customize the content on the message… Continue reading Scheduled Email through Saved Search
Vendor statement
vendor_statement_customization
Use multiple pricing
Scenario Define price level in the customers record. Solution Enable the Multiple Pricing feature: Your administrator can go to Setup > Company > Setup Tasks > Enable Features. On the Transactions subtab, check the Multiple Prices box. Click Save. Create price level records: To create price levels, go to Setup > Accounting > Setup Tasks > Accounting Lists > New. Set price… Continue reading Use multiple pricing
Quick Period Closing
Quick Period Closing