replace( ns_concat( ‘<font color=”darkgreen”>’ || {billingtransaction} || ‘</font>’ || ‘ –>’ || ‘[ <font color=”red”>’ || ABS({billingtransaction.quantity}) || ‘</font> ]’ || ‘–>’ || ‘<font color=”blue”>’ || {billingtransaction.line} || ‘</font>’ ), ‘,’, ‘<br>’ )
Category: Errors & Solutions
Articles related to errors and its solutions
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
The transaction date you specified is not within the date range of your accounting period” when Saving a Journal Entry
Creating a Journal Entry where Date is not within the date range of the Accounting Period selected on Posting Period field. To be able to enter a Journal Entry where date is outside the date range of posting period, the Accounting Preference below and/or Manage Accounting Period Periods page must be considered: 1. Allow… Continue reading The transaction date you specified is not within the date range of your accounting period” when Saving a Journal Entry
Avoiding the “SSS_SEARCH_FOR_EACH_LIMIT_EXCEEDED” Error in NetSuite SuiteScript
NetSuite developers frequently run into the SSS_SEARCH_FOR_EACH_LIMIT_EXCEEDED error when using forEachResult() to iterate large search result sets. What Causes the Error? NetSuite SuiteScript has a limitation: you can’t return more than 4,000 records using .forEachResult(callback) or .each(callback). The error looks like this: SSS_SEARCH_FOR_EACH_LIMIT_EXCEEDED: No more than 4000 search results may be returned at one time… Continue reading Avoiding the “SSS_SEARCH_FOR_EACH_LIMIT_EXCEEDED” Error in NetSuite SuiteScript
Fixing CSV Column Misalignment Due to Commas in Field Values
Problem Summary When generating CSV files, field values that contain commas can cause column misalignment. This typically happens with descriptive fields like Customer or Project names, especially in entries like: 10001 ABC Company : Commercial Development at BKC, Mumbai The comma in “BKC, Mumbai” causes the CSV parser to split this value into two separate… Continue reading Fixing CSV Column Misalignment Due to Commas in Field Values
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
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
Separate tax amount of PST and GST/HST in a Report
Query Is there a method to calculate individual taxes for PST and GST/HST on each line item within a sales transaction? The highlighted columns represent standard fields, but we’re struggling to extract the percentage for these fields in the saved search. Obtaining these percentages would facilitate the determination of separate tax amounts through a formula.… Continue reading Separate tax amount of PST and GST/HST in a Report
Resolving “Filename Too Long” Issue in Git for Windows
The “Filename too long” error in Git for Windows often occurs due to path length restrictions. Despite enabling core.longpaths in Git-1.9.0-preview20140217, users may still face issues when working with deeply nested directories, such as those generated by tools like Yeoman. To fix this, run the following command in a terminal with administrator privileges: bash git… Continue reading Resolving “Filename Too Long” Issue in Git for Windows