-
removing inventory that has no lot or bin with many zeros
I am having an issue trying to clear out this inventory with many zeros after the decimal. when I try to put that number into a transfer it gives me 8e-8 on the line and I cannot go any further. How should I get clear this inventory from the system?
-
How to Change Costing Method Standard Costing to FIFO for Large Number of Existing Items/ Assembly
Hi All, We need to switch a large number of inventory and assembly items (around 11,000) from Standard Costing to FIFO in NetSuite. Since most of these items already have historical transactions, I know the costing method can’t be changed directly. What’s the recommended approach to handle this? Is a bulk process (CSV…
-
Saved Search for Inventory Items with Blank Price Level
Hi All, I'm trying to create a saved search to fetch inventory items where the price level is blank, null and the list price is not empty. However, I'm unable to retrieve items where the price level is blank. I've tried creating the saved search based on both Item and Pricing, but I still can't get the expected results.…
-
Mass update script for image alt tags
Hello, I am trying to implement a mass update script to only add image alt content on an item's associated image if there is no value. /** * @NApiVersion 2.1 * @NScriptType MassUpdateScript */ define(['N/record', 'N/log'], (record, log) => { const update = (context) => { try { // Load the Item Record const itemRec =…
-
Set Field Value on Item Record from Purchase Order Pending Approval
If an inventory item is on a purchase order that's in the status pending approval status, I want the value in a custom field on the inventory item record to display something (e.g., Yes or purchase order number). I want this custom field to store the value so that on a different page I can include that field as a filter…
-
Updated Asset Account on inventory item doesn't get updated with value.
Hi, We updated the asset account on some of our items with a newly created account. For example the one that was there before was a 1200 Inventory Account and we created a sub-account 1210 under 1200 and assigned it to some of our inventory items. What we expected was to get the values of those inventory moved to the new…
-
How to customize the Locations listbox in the Inventory Item form
Hey, everybody! I have created a custom field for the Item Location Configuration form. Now, in the Inventory Item form under the Purchasing/Inventory tab, I want to customize the view of the Locations - Inventory Count list by adding a previously created field to it. But when I try to add this field to the list, I get an…
-
Inventory Item Forms Changed
Hi @Niks Blando-Oracle you asked for a screenshot, which I attached. Thank you This field is now showing up on my Inventory Item forms, standard and custom. Field ID: upccode I did not put it there and don't want it there. I tried to remove it, but don't see it as an option when I customize the forms. Anyone else have this…
-
NetSuite Admin Tip | Available items using ODBC Driver NetSuite2.com Data Source
All items, goods, merchandise, and materials are held and used by a business for profit. Businesses must ensure they have an effective inventory management to prevent selling out of items that will upset customers, over-reordering or having overstock that costs money. In NetSuite, businesses can use ODBC to retrieve data…
-
How to consume/charge inventory items to cost?
Hello all, We purchase spare parts, stationary items, electricity items and IT items and keep all as inventory items in a warehouse all these items are not for sale, they are for our company use and consumption only. Whenever an item is required, we should charge its cost to the proper expense account, class, custom…