To change the prefix of a document number in NetSuite for both future and existing records, you can follow this structured and safe process: Disable Advanced Numbering (if enabled) Navigate to: Setup > Company > Setup Tasks > Auto-Generated Numbers Uncheck the “Use Advanced Numbering” checkbox. Click Save. Enable “Allow Override” Still in the Auto-Generated… Continue reading Updating Document Number Prefixes: Historical and New Transactions
Month: June 2025
Manufacturing Execution System
MES modules bridge the gap between planning and production cycles through real-time monitoring and control of manufacturing operations. These systems track production progress, machine use, and worker productivity, and automatically collect and organize data for analysis and refinement. MES’s visibility allows manufacturers to set efficient and realistic production schedules and to respond quickly to unexpected… Continue reading Manufacturing Execution System
How to Reliably Identify Line Index in NetSuite Using lineuniquekey
Overview In NetSuite scripting, retrieving the correct line index from a sublist like item is essential — especially when working with Map/Reduce, User Event, or Client Scripts that manipulate specific lines. When records are edited and lines are inserted or deleted, the line numbers may shift, making them unreliable over time. Instead of relying on… Continue reading How to Reliably Identify Line Index in NetSuite Using lineuniquekey
Understanding New Fallback Themes in SuiteCommerce
Fallback themes are essentially backup styles or templates that a website can default to when specific design components or assets fail to load. This may be due to a host of reasons, such as server issues, browser incompatibility, and all other technical snags. The use of a properly developed fallback theme ensures that your website… Continue reading Understanding New Fallback Themes in SuiteCommerce
Testing Error Handling and Logging for NetSuite SuiteScript PO Customization
Overview This Knowledge Base article provides a comprehensive guide for testing the error handling and logging mechanisms of a NetSuite scheduled SuiteScript customization designed to automate the update of the Current Expected Receipt Date for Purchase Order (PO) lines using internal NetSuite logic (e.g., calculations based on vendor lead times, transaction dates, or custom business… Continue reading Testing Error Handling and Logging for NetSuite SuiteScript PO Customization
Efficient Testing Strategy for Large CSV Data Uploads in NetSuite
In many real-world business processes, especially those involving third-party platforms or large external systems, data is received in bulk CSV format. These files often contain transactional, financial, or operational data that needs to be accurately imported and processed within NetSuite using custom-built scripts and Suitelets. One such scenario involved testing a project where large volumes… Continue reading Efficient Testing Strategy for Large CSV Data Uploads in NetSuite
DocumentReference in Firebase / Nextjs
What is it? A DocumentReference is a Firestore object that points to a specific document in a collection, like /users/abc123. It’s used to link related documents instead of duplicating data, keeping things consistent and storage-efficient. How it’s created? We use the doc() function from firebase/firestore, e.g., doc(db, ‘collectionName’, ‘documentId’). Why use it? It enables relational… Continue reading DocumentReference in Firebase / Nextjs
Connecting Google Analytics with Oracle Analytics Cloud (OAC)
In today’s data-driven world, organizations need seamless access to web analytics data to make informed business decisions. Oracle Analytics Cloud (OAC) allows users to connect to various data sources, including Google Analytics, to analyze website traffic, user behavior, and marketing performance. This article guides you through the step-by-step process of integrating Google Analytics with OAC,… Continue reading Connecting Google Analytics with Oracle Analytics Cloud (OAC)
Invoice Advanced PDF/HTML Template with Subsidiary Address
To print the subsidiary address on an invoice Advanced PDF/HTML template, instead of the company address information, follow these steps: Create a Custom Transaction Body Field with sourced address information: Navigate to Customization > Lists, Records & Fields > Transaction Body Fields > New. Provide Label (e.g. Subsidiary Address). Set ID to _subsidiary_address. Set Type to Text Area. Un-check Store Value. In the Applies To tab, check Sale. In the Sourcing & Filtering tab,… Continue reading Invoice Advanced PDF/HTML Template with Subsidiary Address
To add a “Scroll to Top” button in a Next.js TypeScript project
To add a “Scroll to Top” button in a Next.js TypeScript project, follow these steps: 1. Create the ScrollToTop component Create a reusable component that: Listens to scroll position Shows a button when scrolled down Scrolls smoothly to top on click components/ScrollToTop.tsx ‘use client’; import { useEffect, useState } from ‘react’; const ScrollToTop = ()… Continue reading To add a “Scroll to Top” button in a Next.js TypeScript project