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
Author: Hormese Paul
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
Display a BarCode on a Saved Search
I had seen an article in LinkedIn. I do not remember the source but then I have copied that for personal use. You can try this out, It works for me. What you will need: Downloadable font uploaded to NetSuite file cabinet. Formula (HTML) in saved search column. Steps to use Google Fonts Navigate to… Continue reading Display a BarCode on a 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
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
Render image from a hyperlink field to inline HTML field
‘<img src=”‘ || {custitem24} || ‘” width=”600″ height=”300″>’
Understanding Customer-Scheduled Maintenance in NetSuite
Ayitah Tallada-Oracle Started a new discussion. NetSuite Admin Tip | Understanding Customer-Scheduled Maintenance in NetSuite Understanding CSM is key to improving customer satisfaction, as it lets businesses schedule maintenance when it’s most convenient for them, ensuring their operations aren’t disrupted by necessary technical work. What is Customer-Scheduled Maintenance (CSM)? Customer-Scheduled Maintenance is a feature in NetSuite… Continue reading Understanding Customer-Scheduled Maintenance in NetSuite
Invoice Sales Orders page
If Invoice in Advance of Fulfillment is not enabled under Setup > Accounting > Accounting Preferences > Order Management tab, then Sales Orders with Status of Pending Fulfillment will not show up on Invoice Sales Orders page. A sales order with 2 line items, where one line has been fulfilled & invoiced while the other… Continue reading Invoice Sales Orders page
How to Prevent Item from Being Committed?
Scenario User wants to prevent inventory items from being committed. Solution There may be instances when users want to limit items from being available for commitment. You can try: a) Default Commitment Option > Do Not Commit There is a preference that you can set up where items, by default, will not be committed. This would… Continue reading How to Prevent Item from Being Committed?