NS_concat function will only work with the summary functions. Group the NS_Concat field with any summary function and it will appear in the saved search result.
Author: Anila George
Not able to create a custom field in Discount Item
The user tries to create a custom item field in the discount item type. But there are the following scenarios The Discount option is not available in the Apply to item types Discount item custom forms are not available in the Apply to form options Even if the custom field is created from the Discount… Continue reading Not able to create a custom field in Discount Item
No GL Impact for Item Receipt
Issue – For the Item Receipt there is no GL impact showing. The corresponding purchase order has a rate specified. Solution – Check the inventory valuation report. If the Item Receipt shows zero value in both GL Impact and Inventory Valuation Report is that the Purchase Order Item Rate field was originally populated with zero… Continue reading No GL Impact for Item Receipt
Rearranging the Fields in Form
When rearranging the form, the client experienced a blocker to arrange the fields in a single row. Even if unchecked the column break checkbox for each field, the fields were in multiple rows. The reason for this was the field group settings. For each field group, there is an option called ‘Single Group’. If this… Continue reading Rearranging the Fields in Form
The maximum Daily limit not working in the timesheet
A maximum daily limit of 10hrs has been applied to the timesheet entered in NetSuite. However, the user is able to track time more than 10hrs in a day. One of the possible reasons for this one may be the role. The restriction will be applied to only the Non-admin role users. The administrators can… Continue reading The maximum Daily limit not working in the timesheet
Sales By Promotion returns no Data
The standard behavior of Sales by Promotion Report only generates the Invoice and Cash Sale transactions. The report does not include data from transactions that have stackable Promotions. When the SuitePromotions is enabled, it will not display any results because the transaction form assumes that stackable SuitePromotions is applied. To override this behavior, disable the… Continue reading Sales By Promotion returns no Data
Import Effective Date Price Records Using CSV Files
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. The user can import price update data into NetSuite using CSV import. Prepare the Import file The Price Update record… Continue reading Import Effective Date Price Records Using CSV Files
Effective Date Pricing functionality
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 functionality
The Disclaimer cannot be edited in the invoice basic transaction layout.
User takes the print of an invoice using the basic transaction layout. But there is no disclaimer is specified at the invoice form setup. But the print shows a disclaimer and the user can not edit it. Solution – When the ‘Print remittance form with invoices and statements’ preference is enabled (Setup -> company ->… Continue reading The Disclaimer cannot be edited in the invoice basic transaction layout.
The Remittance Slip field is not available in an invoice form setup.
In the invoice form setup, the user not able to select any remittance slip as there is no field is available. This is because, the preference ‘Print remittance form with invoices and statements’ is not enabled in the account. Navigate to Setup -> Company -> Preferences -> Printing & Fax.Under the printing tab enable the… Continue reading The Remittance Slip field is not available in an invoice form setup.