Would you like to customise the financial layout of the Standard Balance Sheet and Income Statement reports without retaining a new or custom report (e.g., customise the Retained Earnings section, change negatives from minus to parentheses)? Yes, it is possible using the Row Layout Assignment feature in NetSuite. 1. Open and customise the Balance Sheet… Continue reading Customise the layout of the Standard Balance Sheet and Income Statement reports
Category: NetSuite ERP
NetSuite ERP
BOM revision update through CSV import
Scenario: User wants to update the BOM revision by removing the existing Bom components and adding new components through csv import. Solution: For removing the existing components, select update and check the ‘override sub list’ checkbox in import options. But if you add all the components in the same file and set the file for… Continue reading BOM revision update through CSV import
Adding a New Line to the Item Sublist in beforeSubmit User Event Script
. 🔍 Applicable Context Script Type: User Event Script Execution Context: beforeSubmit Record Type: Any record with an item sublist (e.g., Sales Order, Invoice) Use Case: Automatically inserting a default item line before the record is submitted const beforeSubmit = (scriptContext) => { try { if (scriptContext.type !== scriptContext.UserEventType.CREATE)… Continue reading Adding a New Line to the Item Sublist in beforeSubmit User Event Script
Signing and encrypting a file using N/pgp module
Background The process involves encrypting and signing a file before transmitting it to an external server. Once received, the external server will: Decrypt the file using their private key (which pairs with the public key we used to encrypt it). Verify the signature using our public key (which pairs with the private key we used… Continue reading Signing and encrypting a file using N/pgp module
Linking two Saved searches as a single report
Formula for the main Report : ‘<A href=”/app/common/search/searchresults.nl?searchtype=Transaction&IT_CUSTITEM_JJ_CATEGORY=’||{item.custitem_jj_category.id}||’&Transaction_LOCATION=’||{location.id}||’&ID_InventoryDetail_STATUS=’||{status.id}||’&ID_InventoryDetail_INVENTORYNUMBER=’||{inventorynumber.id}||’&style=NORMAL&Transaction_SERIALNUMBERtype=STARTSWITH&report=&grid=&searchid=1995″ target=”_blank”>View Transactions</A>’ Formula for the second Report: ‘<a href=”/app/accounting/transactions/transaction.nl?id=’||{internalid}||’” target=”_blank”>View Record</a>’ (Please note it is an example of the linking formulas similarly we can link searches based on the requirement.)
Items Not Listing in the Picking Ticket
Issue: Upon printing the Picking Tickets, the item lines did not show up in the print, even though they were added in the Advanced PDF Template. Cause: If the items on the sales order and transfer order have already been shipped, then we will not be able to print a Picking ticket anymore for that… Continue reading Items Not Listing in the Picking Ticket
‘Current Record’ Option Missing in Workflow’s Set Field Value Action
Issue: We have encountered an issue during the workflow development where the ‘Current Record’ field is not appearing as expected. This appears to be due to the large volume of transactions in the account, which is causing the field values to buffer and load slowly. Even when manually typing the field name, ‘Current Record’ does… Continue reading ‘Current Record’ Option Missing in Workflow’s Set Field Value Action
Preventing Duplicate Record Creation on Form Resubmission
Scenario : Identified that when the Submit button is clicked, and the user subsequently navigates back to the form using the browser’s Back/Forward button, the previously entered content is still present. If the Submit button is clicked again, a duplicate record is created. Solution: To resolve this issue, we have implemented a solution that clears… Continue reading Preventing Duplicate Record Creation on Form Resubmission
Create NetSuite-Connected Visualizations in Klipfolio
Klipfolio is a cloud-based business intelligence (BI) and dashboarding tool focused on real-time data visualization. Primary Use: Building interactive dashboards from various data sources Strengths: Easy drag-and-drop interface Real-time updates Integrates with Google Sheets, Excel, Salesforce, and more Ideal for marketing, sales, and operations teams Limitations: Limited native data warehousing capabilities May require external tools… Continue reading Create NetSuite-Connected Visualizations in Klipfolio
Handling Timezone Conversion When Setting Date Fields in NetSuite via Map/Reduce Scripts
Purpose This article explains how to handle timezone discrepancies when setting date fields in NetSuite via a Map/Reduce script, especially when using ISO 8601 UTC date strings from external systems. This ensures the correct calendar date appears in the NetSuite UI, regardless of the account’s timezone configuration. Problem Overview External systems often send date values… Continue reading Handling Timezone Conversion When Setting Date Fields in NetSuite via Map/Reduce Scripts