ISSUE There was an issue that item search from a restlet script showed empty results for a specific role used for integration. When the search is executed in UI, results are present but when run through restlet script it shows empty results. SOLUTION The issue was with the subsidiary restriction permission issues. The custom role… Continue reading Issue with showing empty search results for item search in restlet
Month: September 2023
Banket Purchase order and Purchase order Line Mapping Search
Within the Purchase Order record, there is currently no feature available to directly link and identify the corresponding item line within the Blanket Purchase Order. To address this, we can use a search method to determine the corresponding line number in the Blanket Purchase Order. In this particular search, the “Applied to Transaction Line ID”… Continue reading Banket Purchase order and Purchase order Line Mapping Search
How to resolve the error if the invoice section is not showing for newly created Customers in checkout page
We can solve this by extending the profile model under SuiteScript and adding certain codes. For showing the invoice section on payment method section, here we have implemented the vinson related code in our file. Here, the related view is payment method selector Another code we have used is for render function()
Profile.Model does not return the value of a customer field.
By default, the Profile model returns the values as shown below To get the required fields values other than in the profile model, update the profile model by extending it and add the field to the response.
Avoid the standard NetSuite warning message
How to resolve the error if the field data is not saving in the lead record
To resolve the error if the field data is not saving the lead record using script. We have to pass the values from each section and how to use it , will give an example. We can write the code first in SuiteScript to get the values. Code: Here in the code siteTermsName values are… Continue reading How to resolve the error if the field data is not saving in the lead record
Equation to exclude the week ends in saved search
Formula(Numeric) is 1 | CASE WHEN to_char ({trandate},’D’) NOT IN (1,7) THEN 1 END
Negative Profit in Customer Profitability Report
The Customer Profitability report pulls its data from Item Fulfillment and Invoice records. The report includes Item Fulfillment records that are not yet invoiced. This causes the negative profit. To illustrate, say for example, Sales Order 1 and Sales Order 2 are created and have the following related records: Sales Order 1 amounting to $10.00 Item Fulfillment 1 amounting to $10.00 Invoice… Continue reading Negative Profit in Customer Profitability Report
Generating Depreciation History error :UNEXPECTED_ERROR: [object Object]
Scenario User navigates to Fixed Assets > Setup > System Setup > Precompute Depreciation Values to generate depreciation schedules when they received an error: UNEXPECTED_ERROR: [object Object] Solution The reason behind the error is because the End Period Number for depreciation method was populated but the Next Depreciation Method is empty. If the depreciation method covers a limited period (e.g. only… Continue reading Generating Depreciation History error :UNEXPECTED_ERROR: [object Object]
Exclude Empty Commerce Categories
Go to Commerce > Websites > Configuration. Select the Website from the dropdown list. Select the Domain from the dropdown list. Click Configure. Click the Integrations subtab. Click the Categories subtab. Check the Exclude Empty Categories box. Click Save.