Scenario The Item Description column item fulfilment record is not accessible in the saved search. The item description field in the item fulfilment is sourced from the corresponding sales order record and we are not able to edit or add the same. Solution To pull up the exact Item Description displayed in the Sales Order transactions in an Item Fulfillment Saved… Continue reading Fetch Item Description by using Item Fulfilment Saved Search
Author: Abin Pious
PROPOSAL FOR CREATING PDF TEMPLATE FOR RETURN AUTHORISATION
Proposal Summary Waterworks would like to customize the Advance PDF template for the Return authorisation record. Requirement As per the client request, we need to customize the Advance PDF template of the Customer return authorisation record. The template should be similar to the credit note PDF template with some minor changes. Our Solution Based on… Continue reading PROPOSAL FOR CREATING PDF TEMPLATE FOR RETURN AUTHORISATION
Employee Labor cost is showing in parent subsidiary currency, not in employee subsidiary currency.
This behavior is related to an existing enhancement request in the system (404297 | Employee Saved Search > Labor Cost reflected in Base Currency of Parent Subsidiary instead of Base Currency of the Subsidiary where the Employee belongs to). Alternative Solution Create a Custom Field showing the Labor Cost based on the Employee Record Click Edit on… Continue reading Employee Labor cost is showing in parent subsidiary currency, not in employee subsidiary currency.
Custom Field for Store Invoice Number on Time Record when an Invoice is Created for the Billable Time
Requirement Time Transactions are created through Transactions > Employees > Track Time for billable time to a Customer or Project. When the time is Invoiced, a custom field holding the Invoice Number should be automatically populated on the Time Tacking record. Solution Create a Transaction Line Field on the Time Tracking Record with Type = List/Record of Transaction, Applied To = Time, Display Type = Disabled Create a User Event Script deployed on Invoice with After Submit Function that stamps the Custom Transaction Line Field value… Continue reading Custom Field for Store Invoice Number on Time Record when an Invoice is Created for the Billable Time
BOX SUITEAPP ISSUE
Scenario There is an issue with the box suite app. Please refresh and try again. If the problem persists contact your Netsuite Administrator. Solution Go to the employee record and find their internal ID Go to the Record type “Box account association” Find the Internal ID in the Netsuite User ID Column – Delete the… Continue reading BOX SUITEAPP ISSUE
Mass Updating Sales Teams
The Team Selling feature lets you associate sales transactions and customers with sales teams comprised of various employees. In addition to sales reps and managers, sales teams can include engineers, account managers and other employees who aid in the sales process. You can use sales territories to route new leads, prospects, and customers to sales… Continue reading Mass Updating Sales Teams
Make the Columns Mandatory on Transactions Records
Making the Sublist Fields of a Transaction record mandatory is not possible through Form Customization. We can do this by creating a Workflow with a Set Field Mandatory Action. The setup of the Set Field Mandatory would look like this:
TIME_ENTRY_DISALLWD
Issues I will get an error while saving the time entry in UI or in the script. I have verified that the time entry is billable and the time entries are “Unbilled”. The error message is listed below, “type”:”error.SuiteScriptError”,”name”:”TIME_ENTRY_DISALLWD”,”message”:”P&L Test Project does not allow time entry.” Solution I have found the reason for the issue,… Continue reading TIME_ENTRY_DISALLWD
Proposal For Auto Population of Line Level Location
Requirement Team Vita wants to automate the line-level location population when the sales order status changes to Pending Approval to Pending Fulfillment. The line level location will change based on the Order Type. Our Solution We can automate the line level location population in the sales order by using a suite script. We can check… Continue reading Proposal For Auto Population of Line Level Location
Locking a script from edit or viewing.
Question How we can lock a script for editing or view?. Solution There is no direct way for locking a script in Netsuite.We can restrict the script from editing or view by creating a bundle for that script. Even the administrator could not edit/view it.