In order to get the parent name from the customer name hierarchy through the saved search, use the following formula
Tag: search
PROPOSAL FOR รายงานการยื่นแบบ ภงด. 54 และ ภพ. 36
Proposal summary JCurve Solutions would like to create a new report to retrieve data for data from the AP Bill document Reference to Payment with status Paid which is related to PP36 and PND54. This report will show the current status of the document when recalling the report. And print reports in Excel format. Requirement… Continue reading PROPOSAL FOR รายงานการยื่นแบบ ภงด. 54 และ ภพ. 36
Results without Summary type Column in Search
Use the below formula to show the summary value without grouping the search results. count /*comment*/ ({memberitem.internalid}) over (partition by {internalid}) For Example:::Search Type: ItemItem Type: Kit/ PackageResults: Show the count of member items and member item quantity without using the summary type column under the Results subtab Output: Script Code: var kititemSearchObj = search.create({type:… Continue reading Results without Summary type Column in Search
Summary functions in Query
Example of using summary functions in a query (MIN, GROUP) We can use the summary functions in query as we use in the search
Retreive datas using Query
Solution Instead of using search, we can use query to retrieve data from NetSuite. Use the ‘N/query’ module. Simple Example: Retrieving an employee name using the query For more search SuiteQL in SuiteAnswers
Bank Reconciliation Report Using Saved Search
Construct the Reconciliation report using the saved search. Create a new transaction saved search based on the criteria below: Account Type is Bank Posting is true Date is on or before today Cleared is True for Reconciled Transaction And the Result fields are as follows: FIELD SUMMARY TYPE FUNCTION FORMULA CUSTOM LABEL SUMMARY… Continue reading Bank Reconciliation Report Using Saved Search
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:
Search is not working in the Extension
The search is not working in the extension. But the search is working in Netsuite. Issue: There are two functions in the extension for getting details of files and folders from the backend(suitescript file), In the execution log of the corresponding ssp application, it is showing as blank object value is not getting. Solution 1:… Continue reading Search is not working in the Extension
Tips and Tricks in Using Saved Search Formulas
Tips and Tricks in Using Saved Search Formulas
Move search bar in header Proposal
Move search bar in header