REQUIREMENT When trying to delete a custom report in NetSuite, an error occurred “You cannot delete this report until all of its associated schedules and results have been deleted” SOLUTION Deleting a report returned with an error message; occurs when the report may have been scheduled or has associated results. Delete the Report Schedule Login… Continue reading Error in Custom Report Deletion
Author: Jesna John
Issue with showing empty search results for item search in restlet
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
Duplicate Resolution Returning with “Unexpected Error”
Issue The user is merging duplicate customer records and after tagging Master and Duplicate, the Duplicate Resolution Status returns with “An unexpected Error occurred”. Solution 1 ) This is happening because the Customer record being tagged as Duplicate has more transaction records than the record being tagged as Master. Interchanging the tagging will allow the… Continue reading Duplicate Resolution Returning with “Unexpected Error”
Effective Date pricing SuiteApp -Update Types for Creating Price Update Records
To start using the Effective Date Pricing SuiteApp, you must create a record for each of the update types to which the price change applies. You define the update types by creating price update records. You can create a price update record for the following update types: Item Update Type Item Category Update Type Customer… Continue reading Effective Date pricing SuiteApp -Update Types for Creating Price Update Records
Effective Date Pricing SuiteApp
The Effective Date Pricing SuiteApp enables you to set a schedule for specific price changes in advance. You can select the start date and end date when you expect the price changes to take effect. A scheduled script runs in the background to automatically update the item prices on the scheduled period. On the specified… Continue reading Effective Date Pricing SuiteApp
Creating CSV files from a saved search
REQUIREMENT Needs to create CSV file of the saved search result and send the results to the client using a scheduled script. SOLUTION We will use the task module to convert the saved search results to the CSV file and send the CSV file as email attachment using map reduce script.
Sending saved search results as CSV attachment
Requirement Add a scheduled script to send the saved search results to the designated email address as CSV attachments. Solution
Converting date time to another time zone
let todayDate = new Date() let getTime = todayDate.getTime(); let timeOffset = 10 * 60 * 60 * 1000; //Converting to AEST let austTimestamp = getTime + timeOffset; let austDate = new Date(austTimestamp);
Restricting the sales order creation based on the checkbox field in the customer record
Description Upon saving the sales order record, the script will verify whether the customer’s checkbox named “Disallow Create Order” is checked. If the checkbox is found to be checked, it will restrict the update or creation of the sales order each time on its save.
Issue with the creation of multiple custom records when restlet script is triggered in quick succession
ISSUE When the restlet script is triggered in quick succession, multiple custom records are created. Only a single custom record is expected to be created per day. But when resltet script is triggered at the same time, custom records are created multiple times. SOLUTION This issue can be handled by adding an external Id to… Continue reading Issue with the creation of multiple custom records when restlet script is triggered in quick succession