While executing the Map/Reduce or any bulk record processing script, we will log some values to check whether the script executes as expected. In that case, we will also log the processed record ID. In the above case, we may face situations where some records may not be executed. To check and find these, we… Continue reading Finding the exact log to check whether the particular details are present
Category: NetSuite ERP
NetSuite ERP
E-way Bill Transaction Types – NetSuite – Saral GSP Integration
Transaction types of E-way bill Transaction type of E-waybill is used to identify the type of transaction defined by the GST portal. Following are the types of transactions: Regular Bill To – Ship To Bill To – Ship To Bill From – Dispatch From Combination of 2 and 3 For export invoices if E-way bill… Continue reading E-way Bill Transaction Types – NetSuite – Saral GSP Integration
Resolve HSN Code Error While Setting Via script.
When adding items to a transaction via a User Event Script or using Add Multiple in the UI, the HSN Code is not automatically sourced. This is a known limitation and considered an enhancement request. Attempting to manually set the HSN Code within a User Event Script and then saving the record will result in… Continue reading Resolve HSN Code Error While Setting Via script.
Physical Quantity Mismatch in NetSuite Inventory
Problem: Despite having a dedicated team for stocktaking, XYZ Electronics was facing issues with the physical quantities not aligning with NetSuite’s inventory levels. In particular, raw materials were showing as either overstocked or understocked in NetSuite, leading to: Excessive purchasing: The system showed a shortage of materials that weren’t actually needed. Production delays: Certain work… Continue reading Physical Quantity Mismatch in NetSuite Inventory
Introduction to Akeneo PIM (Product Information Management)
Overview Akeneo PIM is a leading Product Information Management system designed to centralize, manage, enrich, and distribute high-quality product data across multiple sales and marketing channels. It helps organizations ensure product data consistency, accuracy, and completeness across websites, marketplaces, mobile apps, print catalogs, and more. What is PIM? A PIM (Product Information Management) system is… Continue reading Introduction to Akeneo PIM (Product Information Management)
How to attach existing contact to project/job record via CSV?
REQUIREMENT: As the title says — is this possible via CSV? I tried using the Relationship > Customer & Contact Together but I’m getting an error The record you are attempting to load has a different type: job from the type specified: customer. I need to attach the contact in the Project > Relationships tab… Continue reading How to attach existing contact to project/job record via CSV?
Redirecting to a Specific Subtab in NetSuite When Opening a Record
NetSuite provides the redirect.toRecord() API in SuiteScript 2.0, which allows developers to redirect users to a specific record. By passing the selectedtab parameter, you can control which subtab is displayed when the record loads. if (currentUrlParam[“selectedtab”] != “custpage_create_box_app_subtab”) { redirect.toRecord({ type: recordType, id: recordId, … Continue reading Redirecting to a Specific Subtab in NetSuite When Opening a Record
How to access ‘ Generate Inventory report’ in another role?
REQUIREMENT: Using the WMS Warehouse Manager role, I can access WMS Reporting > Inventory Reporting > Generate Inventory Report. How can i give a non WMS role to access this report? ANSWER: You won’t be able to. That report is for the WMS role. You can provide access to other inventory reports by going to… Continue reading How to access ‘ Generate Inventory report’ in another role?
NetSuite Financial Records Audit Trails
🔎 Tracking Key Financial Record Audit Trails in NetSuite General Transaction Audit Trail NetSuite records every change to transactions, including creation, modification, and deletion. Each entry captures details such as the user, their role, the action taken, date and time, affected accounts, and updated amounts. These records are stored as system notes, audit trails, or… Continue reading NetSuite Financial Records Audit Trails
THREE DECIMAL PLACES IN WORKBOOK
SCENARIO In datasets, quantity fields are automatically rounded to two decimal places when added. For example, if the actual data is “Gold Screw – 0.045 gm” and “Gold Chain – 0.050 gm,” the dataset displays both as 0.05 gm. SOLUTION Apply the formula TO_CHAR({field_id}, ‘9999999990.000’) ‘9999999990.000’ ensures three decimal places are always shown. You can… Continue reading THREE DECIMAL PLACES IN WORKBOOK