Author: Hormese Paul

NS concat formula with colour

replace(    ns_concat(        ‘<font color=”darkgreen”>’ || {billingtransaction} || ‘</font>’ ||         ‘ –>’ ||         ‘[ <font color=”red”>’ || ABS({billingtransaction.quantity}) || ‘</font> ]’ ||         ‘–>’ ||         ‘<font color=”blue”>’ || {billingtransaction.line} || ‘</font>’    ),     ‘,’,     ‘<br>’ )

Wave Record & Pick task deletion

For WMS, the Pick task records must be deleted first before the deletion of the Wave records. Note that you can only delete Pick Task subrecord in Pending or Ready status. After its deletion, you can now delete the Wave since there are no associated pick tasks. (This is documented in Updating or Deleting Pick Tasks Generated from Waves and Updating Waves… Continue reading Wave Record & Pick task deletion

Free form Text to Rich Text ADD HTML

Normal Text to Rich Text If you have MS Excel, you can use the Replace (Ctrl + H) functionality. Steps: Open your Excel file Press Ctrl + H on your keyboard Click the “Find what:” box, then press Ctrl + J on your keyboard Click the “Replace with:” box then put in <br> Click Replace All Save the file as a CSV It is important that… Continue reading Free form Text to Rich Text ADD HTML

Extract Rich Text Field Values without HTML Tags using Saved Search Formula

Workaround: Using Formula (Text) Fields To address this, you can utilize a Formula (Text) field in your Saved Search to strip the HTML tags from the exported data. This ensures that only the text values are extracted. Edit your Saved Search On the Results tab, add a Formula (Text) field with this formula: REGEXP_REPLACE({fieldid},'<[^<>]*>’,”) where… Continue reading Extract Rich Text Field Values without HTML Tags using Saved Search Formula

CSV import update for the Line Item Updates

The Import Assistant lets you update items data for the following types of transactions: Cash Sale, Estimate, Invoice, Opportunity, Purchase Order, Sales Order, Vendor Bill, Vendor Credit, and Vendor Return Authorization. You can modify data for existing line items and add line items to existing transactions. The Items sublist for transactions uses either Line/Order Line… Continue reading CSV import update for the Line Item Updates

AR Aging Report in Saved Search

Based on the formula above, the NVL({daysoverdue}, Round({today}-{trandate}, 0)): NVL() ensures that if {daysoverdue} is null, it defaults to the calculated difference between {today} and {trandate}. Round({today}-{trandate}, 0): Calculates the number of days since the transaction date. This means the formula originally used the Days Overdue, which is based on the Due Date. Instead, we… Continue reading AR Aging Report in Saved Search

Trial Balance Saved search

I tried several criteria already but still the result does not match. Upon further checking, this is still a system limitation and it is already filed under related Enhancements: #281398 Lists > Search > saved Searches > Transaction > Results tab > Add Quantity or Amount column > Please provide an ‘Alternate Date/Period Range’ on saved… Continue reading Trial Balance Saved search

Extracting Image File Names Instead of URLs in Saved Search Results

Query I have saved search having a column of image fields. Whole extract the search results the image column were providing the url of the image in the file cabinet. I would like to see the image file name instead of the URL. Solution As per checking, this is a feature request filed under Enhancement… Continue reading Extracting Image File Names Instead of URLs in Saved Search Results

Email Notification on Transaction Deletion

Unfortunately at the moment we cannot send email confirmation for a transaction record being deleted. There might be a way by creating an UserEvent Script as an alternative. Please let me know if you are confident with running scripts in NetSuite so that I can I can ask my colleagues from SuiteCloud team to assist you. An… Continue reading Email Notification on Transaction Deletion