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?
Month: March 2025
Calculating Date Differences in SuiteScript
This article provides a reusable SuiteScript 2.x utility function to calculate the number of days between two dates. The function ensures proper date parsing using NetSuite’s N/format module and includes error handling, input validation, and logging. Usage Accepts two date strings in MM/DD/YYYY or NetSuite’s UI format. Converts them into Date objects. Computes the difference… Continue reading Calculating Date Differences in SuiteScript
Star rating in record. Dynamic star in the record using inline HTML
CASE WHEN {custentity_jj_avg_feedback_rating} = 5 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’ WHEN {custentity_jj_avg_feedback_rating} = 4 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’ WHEN {custentity_jj_avg_feedback_rating} = 3 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’ WHEN {custentity_jj_avg_feedback_rating} = 2 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’ WHEN {custentity_jj_avg_feedback_rating} = 1 THEN ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div style=”font-size:20px;color:#FFD700;-webkit-text-stroke:1px black;”>?????</div><br>’ ELSE ‘<br><div style=”font-size:12px;color:#666666;”>SUMMARY RATING</div><br><div… Continue reading Star rating in record. Dynamic star in the record using inline HTML
Customer wise filtered search hyperlink. View search is customer record as link
Combined ‘<br><div style=”font-size:12px;color:#666666;”>TOTAL REVIEWS</div><br>’|| ‘<span style=”display: inline-block; padding: 8px 16px; font-size:15px; color: #000000; font-weight: bold; text-decoration: none; border-radius: 4px;”>’ || {custentity_jj_total_feedback_received} || ‘</span>’|| ‘<a href=”https://td2976892.app.netsuite.com/app/common/search/searchresults.nl?searchtype=Custom&CUSTRECORD_JJ_CUSTOMER_NAME=’||{id}||’&style=NORMAL&report=&grid=&searchid=1537&“ target=”_blank” style=”display: inline-block; padding: 8px 16px; background-color: #007bff; color: white; text-decoration: none; border-radius: 4px; transition: background-color 0.3s; font-style: italic;”> View Reviews </a>’ Specif part ‘<a href=”https://td2976892.app.netsuite.com/app/common/search/searchresults.nl?searchtype=Custom&CUSTRECORD_JJ_CUSTOMER_NAME=’||{id}||’&style=NORMAL&report=&grid=&searchid=1537&“ target=”_blank” style=”display: inline-block; padding:… Continue reading Customer wise filtered search hyperlink. View search is customer record as link
UPS Registration Error Troubleshooting Tricks
Use invoice related date from Amount from Amount Due. On your browser, disable the tool (i.e. AdBlock, any Apps that store passwords and/or auto-fill) to allow the UPS Device ID (Blackbox) value to load. Check if you have an application that automatically populates your password on your browser. Please make sure to manually type in all information in… Continue reading UPS Registration Error Troubleshooting Tricks
Securing AWS RDS: Best Practices and Compliance
Security is a crucial aspect of AWS RDS. Here are best practices for securing your RDS databases: Authentication & Authorization: IAM Database Authentication: Enables secure access without storing credentials. Use IAM Policies: Restrict access based on roles and permissions. Enable Database User Privileges: Grant the least privilege necessary. Encryption: Encrypt Data at Rest: Use AWS… Continue reading Securing AWS RDS: Best Practices and Compliance
High Availability and Scaling in AWS RDS
High Availability: AWS RDS offers several features to ensure database availability and minimal downtime. Multi-AZ Deployments: Creates a standby replica in a different Availability Zone, automatically failing over during outages. Failover Mechanisms: If the primary instance fails, AWS RDS automatically switches to the standby. Backup and Restore: Point-in-time recovery allows database restoration to a specific… Continue reading High Availability and Scaling in AWS RDS
AWS RDS Pricing and Cost Optimization Strategies
AWS RDS pricing depends on various factors, including instance type, storage, and data transfer. Here’s how you can optimize costs while using RDS. Pricing Components: Instance Type: Compute power (CPU, RAM) affects pricing. Storage: Costs vary based on SSD, magnetic storage, and provisioned IOPS. Backup Storage: Automated backups are free up to the allocated database… Continue reading AWS RDS Pricing and Cost Optimization Strategies
Introduction to AWS RDS: Features, Benefits, and Use Cases
AWS Relational Database Service (RDS) is a managed database service that simplifies database administration tasks like provisioning, patching, backup, and scaling. RDS supports various database engines, including MySQL, PostgreSQL, SQL Server, MariaDB, and Amazon Aurora. Features: Automated Backups & Snapshots: RDS provides automated daily backups and manual snapshots for data recovery. Multi-AZ Deployment: Ensures high… Continue reading Introduction to AWS RDS: Features, Benefits, and Use Cases
NetSuite Saved Search Formula: Identifying Records Created Within the Past Year
When working with NetSuite Saved Searches, you may need to filter records based on their creation date. A common requirement is to find records created within the past 12 months. This can be achieved using a Formula (Numeric) field in a NetSuite Saved Search. Formula to Identify Records Created in the Last 12 Months: CASE… Continue reading NetSuite Saved Search Formula: Identifying Records Created Within the Past Year