You can control who can access your company’s NetSuite account by setting IP address rules. This means only computers with approved IP addresses can log in. For example, you might want employees to sign in only from a trusted location for extra security. Enabling Feature Setup -> Company -> Enable Feature Under the ‘Company’ and… Continue reading Configuring IP Address Rule for Login to NetSuite Account
Month: July 2025
Average Cost of an Item Is Null
Scenario Average Cost under the Purchasing/Inventory tab of an item displays null if the total quantity of the item is 0. The computation of Average Cost is Total Value / Total Quantity on Hand. Solution For those Items that have blank/null value on it’s Average Cost, the values are computed per the formula below: Total Value = 0.00 Total… Continue reading Average Cost of an Item Is Null
Apply dashboard appearance to all users
REQUIREMENT: I am as administrator and i have setting dashboard for employee center type, I’d like to apply this dashboard to all employee center. how to do it ? ANSWER: Currently, without the SuitePeople HR module, NetSuite does not support publishing dashboards to Employee Center users. There is a known Enhancement : 537835 Setup >… Continue reading Apply dashboard appearance to all users
How to include Journal in Purchases By Vendor Report?
REQUIREMENT: Curious if anyone else has run into this and/or has a solution. I ran a Purchases By Vendor report and realized that Journal Entries were not included (I was looking at a particular vendor that I do not necessarily create Bills for, but know we have expense recorded through JEs). I also included the… Continue reading How to include Journal in Purchases By Vendor Report?
WIP and Inventory Costing
Requirement: NetSuite help says that an item with FIFO/LILO costing method is not compatible with manufacturing WIP. Is this just from a costing standpoint? If I take an item master that has a FIFO costing method, this is confirmed because the WIP box at the inventory location section is grayed out. Items masters assigned the… Continue reading WIP and Inventory Costing
Error importing Shopify gift card to NetSuite
Issue: Gift card order is stuck on order import. Error ‘Failed to add Shopify Order “XXXXX” mapping error occurred. More than one match for “[[“internalid”, “isempty” AND “isinactive”,”is”,”F”]]” for the record type item”.’ Could not find a match for the record type ‘”item”‘. Solution: A NetSuite item record must be created for it and the gift card… Continue reading Error importing Shopify gift card to NetSuite
Updating Custom Fields with record.submitFields in NetSuite when the field id is stored to a variable.
NetSuite’s record.submitFields method efficiently updates specific fields on a record without loading it. To update the custom field custbody_jj_custfield on a sales order: const BODY_CUSTFIELD = ‘custbody_jj_custfield’; record.submitFields({ type: record.Type.SALES_ORDER, id: soId, values: { [BODY_CUST_FIELD]: true }, options: { enableSourcing: false, ignoreMandatoryFields: true } }); Why []? Use square brackets [BODY_CUST_FIELD] to dynamically reference the… Continue reading Updating Custom Fields with record.submitFields in NetSuite when the field id is stored to a variable.
Item Receipt (IR) in NetSuite Shows No GL Impact
In NetSuite, users may notice that the GL Impact tab of an Item Receipt (IR) transaction sometimes displays “No Results.” This behavior can be confusing, especially when users expect the receipt of inventory to generate accounting entries. However, in most cases, this outcome is expected and directly related to system configuration, item type, or the… Continue reading Item Receipt (IR) in NetSuite Shows No GL Impact
Allow multi select in bank reconciliation
In the console, we can type the below. document.querySelectorAll(‘.uif1506.uif1510.uif1513.uif1515.uif1438’).forEach(el=>el.click()) It will multi-select 111 records at a time
Inventory Adjustment Error – “The Following Bin Numbers Are Not Available” During Zeroing Out Stock
📘 Scenario: During a physical stock reconciliation, the client aimed to reset the inventory of specific items to zero. While performing the Inventory Adjustment in NetSuite, they encountered the error message: “The following Bin numbers are not available.” This happened when trying to select bins from the Inventory Detail window—even though those bins appeared in… Continue reading Inventory Adjustment Error – “The Following Bin Numbers Are Not Available” During Zeroing Out Stock