Scenario User would like to create a report to show all related transactions of an item. Solution You may follow below steps: 1.) Navigate to Go to Reports > Financial > Transaction detail > Customize2.) Rename the report3.) Under Edit Columns, add fields: Transaction Type: Transaction Type Long Name Transaction: Date Transaction: Item Transaction: Document Number Transaction: Account Full… Continue reading Create Transaction Detail Report to show Related Transactions of Item
Tag: search
Create a Search to Display Roles with No Users
Create a Search to Display Roles with No Users
Resolve Internal Error Search Failed in SuiteCommerce Web Sites
Upon viewing all items in the web store, the Error: “Internal Error Search Failed” is displayed. The same error also happens on the Item Search API. However, when you remove the “fieldset=search” URL parameter to the Items Search API URL request, the list of items will be returned. One possible cause of this is that the Display… Continue reading Resolve Internal Error Search Failed in SuiteCommerce Web Sites
Resolve Error: “SSS_INVALID_SRCH_FILTER_JOIN”
Scenario: The following error is thrown: “SSS_INVALID_SRCH_FILTER_JOIN” when an nlobjSearchFilter contains an invalid join ID, or is not in proper syntax. This error is thrown if a SuiteScript record search operation has at least one nlobjSearchFilter object that uses an invalid join table ID. A join table ID is invalid if it is not included in the record… Continue reading Resolve Error: “SSS_INVALID_SRCH_FILTER_JOIN”
SOAP Web service – search operation
SOAP Action – search Scenario: Perform transaction search using soap web service Request Response
Resolve Internal Error Search Failed in SuiteCommerce Web Sites
Upon viewing all items in the web store, the Error: “Internal Error Search Failed” gets displayed. The same error also happens on the Item Search API. Please ensure that other SuiteCommerce Advanced (SCA) websites are not experiencing the same issue.Rarely, it has been observed that this particular problem occurs in multiple regions for SuiteCommerce webstores. However,… Continue reading Resolve Internal Error Search Failed in SuiteCommerce Web Sites
Getting Sales order quantity from invoice search
There is a standard field in the invoice called {quantityordered} which shows the sales order total quantity per item line. But we cannot have the option to fetch it through the transaction search directly. So we need to apply the join field applied to the transaction and fetch the quantity from there. Search result screenshot.… Continue reading Getting Sales order quantity from invoice search
Search or Reports To Show all Searches and Reports Run by an Employee
The client would like to satisfy the below requirement Search or Report for All Searches and Reports Run by Employee Cody: The search or report will include the names of all searches and reports run by Employee Cody It will also provide information such as the date and time of the last run for each… Continue reading Search or Reports To Show all Searches and Reports Run by an Employee
Create a Custom Field that Sources the Name of the Case Creator
Create a Custom Field that sources the Name of who created the Case record using a Summary Saved Search.
How to obtain the internal ID of a Nexus in NetSuite
>>To obtain the internal ID of a Nexus record in NetSuite for setting its value in a dropdown field, you can perform a search using the ‘Nexus’ record type and the desired search criteria. >> Once you have retrieved the desired Nexus record, you can obtain its internal ID and use it to set the… Continue reading How to obtain the internal ID of a Nexus in NetSuite