Issue : When exporting items from NetSuite to Magento through the Celigo integration, you may encounter the following error message: Failed to process the item: BA2.56/18 contains a slash in it. Therefore, the Magento server is unable to handle these SKU(s). This error occurs because Magento does not support SKU values that contain… Continue reading Error when exporting items to NetSuite that include ‘/’ in the SKU format
Month: October 2025
Swagger in the Context of API Testing
What is Swagger in the Context of API Testing? Swagger, now primarily known as the OpenAPI Specification (under the OpenAPI Initiative), is an open-source framework for describing, documenting, and testing RESTful APIs. It uses a machine-readable YAML or JSON format to define API endpoints, parameters, request/response schemas, and security schemes. In testing, Swagger excels at… Continue reading Swagger in the Context of API Testing
Auto-check “Calculate Tax” based on Subsidiary and Vendor country (US)
function countrySearch(internalId, type) { try { let countryValueSearch = search.create({ type: type, filters: [ [“internalid”, “anyof”, internalId] ], columns: [ search.createColumn({ name: “country”, label: “Country” }) ] }); let searchResult = countryValueSearch.run().getRange({ start: 0, end: 1 }); if (searchResult.length > 0) { return searchResult[0].getValue({ name: “country” }); } return null; } catch (e) { log.error(“error@countrySearch”,… Continue reading Auto-check “Calculate Tax” based on Subsidiary and Vendor country (US)
Handling Missing “Approval” Field in NetSuite CSV Import
Issue: The “Approval” field is not available by default in NetSuite’s CSV import templates, which can hinder the approval process for imported records. Solutions: Manual Approval: After importing data, manually update the approval status by editing each record in NetSuite’s UI. Automate with SuiteScript: Use SuiteScript to automatically trigger the approval process based on predefined… Continue reading Handling Missing “Approval” Field in NetSuite CSV Import
Mini MP1584EN DC-DC Buck Converter
Overview Product Name: eBoot Mini MP1584EN DC-DC Buck Converter Manufacturer: Based on Monolithic Power Systems (MPS) MP1584EN chip Type: Synchronous buck (step-down) DC-DC converter module Primary Use: Voltage regulation in electronics projects, prototyping, and low-power applications Typical Price Range: $4–$10 USD (varies by seller) Availability: Online retailers like Amazon, eBay, AliExpress, or eBoot direct Datasheet… Continue reading Mini MP1584EN DC-DC Buck Converter
Post approval edits on Journal workflow
Scenario: The client wants the journal to go through approval routine, if the admin edits the journal after approval. i.e. Administrator edits trigger re-approval and JE is unposted until re-approved. The journal contains a review state. Reviewed journals will be submitted for approval by admin. If they are approved by admin it should go to… Continue reading Post approval edits on Journal workflow
Tax calculation via script
require([‘N/currentRecord’],function(currentRecord){ currentRecord.executeMacro({id:’calculateTax’}); }); To calculate the tax inside Netsuite via scripts // get macros available on the record let macros = invoiceRecord.getMacros(); // execute the macro if (‘calculateTax’ in macros) { macros.calculateTax(); // For promise version use: macros.calculateTax.promise() }
Advance paid settlement against expense reports
This article outlines how NetSuite manages advances paid to employees against expense reports. Below is the detailed process flow: The first prerequisite is we can setup default Advance Paid COA in the subsidiary Setup. When creating a journal entry (JE) for the advance, mark the employee’s name at the line level. If the employee later… Continue reading Advance paid settlement against expense reports
TO DISPLAY THE ASSEMBLY ITEM WITHOUT ITS COMPONENTS IN A TRANSACTION DATASET
REQUIREMENT When creating a dataset for sales orders, you may want to include line items. If a line item contains an assembly item, NetSuite automatically adds both the assembly item and its component items to the dataset. This may give discrepancies as you find totals for certain fields. SOLUTION In order to handle the requirement… Continue reading TO DISPLAY THE ASSEMBLY ITEM WITHOUT ITS COMPONENTS IN A TRANSACTION DATASET
Renaming “Copy Previous” Button on Purchase Request
Scenario Users wants to rename the Copy Previous button on Purchase Request using the Administrator role. The new label will be seen when creating Purchase Request using the Employee Center Role. Solution Navigate to Customization > Forms > Transaction Forms Preferred Purchase Order Form: Click Customize/Edit Click Action Click Standard Actions Auto Fill: Label: Enter Label Example: Copy Previous Record Note: The Copy Previous button is also called Auto Fill. This button… Continue reading Renaming “Copy Previous” Button on Purchase Request