Intercompany customers and vendors are entity records used only for Intercompany transactions. When you create a work order from an Intercompany Sales Order it is just a regular non-intercompany transaction. Currently, NetSuite only support Intercompany dropship orders but not Intercompany work orders. To build a Work order record from the Intercompany Sales Order created from… Continue reading Error message: You can add inventory, assembly, of kit/package items only to intercompany transactions generated from Purchase Orders when creating Work Order from an Intercompany Sales Order
Category: NetSuite ERP
NetSuite ERP
Automated Cash Application error when customer is in different subsidiary than bank account
Scenario: When receiving bulk payments from a parent customer (or alternate payor) into a bank account that is linked to subsidiary A, the Automated Cash Application does not find any invoices for sub-customers, because they are in subsidiary B. The system shows the error warning triangle and says: This imported payment contains incorrect customer or… Continue reading Automated Cash Application error when customer is in different subsidiary than bank account
Configuring IP Address Rule for Login to NetSuite Account
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
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
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
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
Currency Exchange Rate Providers
User can set exchange rate provider from the Exchange Rate Integration section of the General subtab on the Accounting Preferences page. HSBC Xignite Setting the exchange rate provider first time will not update rates in historical transactions. For past dates, exchange rates won’t be available automatically. To make them accessible, the rates must be manually… Continue reading Currency Exchange Rate Providers