Is it possible to create a CSV Inventory Adjustmen...
# general
e
Is it possible to create a CSV Inventory Adjustment, where you set the new value of the selected items? Not using "Adjust quantity by" but directly setting the new value.
r
Value as in valuation amount, or quantity?
e
Quantity
l
In either scenario, it sounds like you want Inventory Adjustment Worksheet
r
Yes I believe so
read up on some suite answers on that feature, there may be some requirements
I haven't done one in 4 years
e
Inventory Adjustment Worksheet is manual, right? I'm looking for a way to mass update the correct quantity of 12,000+ items.
I can mass import using CSV, but AFAIK it only works setting the "Adjust Qty By"
r
"The Single Inventory Worksheet Import provides an alternative that you can use to create a new inventory worksheet in NetSuite. With this import, you can submit inventory adjustment data in a CSV file that can be built from a system-provided template.'
hmm, sounds like you may be able to import a csv worksheet
l
With an IAW you set the "New Qty" and "New Value", it will "override" the previous Qty and Value. You can import a CSV here: https://system.netsuite.com/app/setup/assistants/nsimport/simpleimport.nl?rectype=INVENTORYWORKSHEET&whence=
r
there you go !
message has been deleted
l
It should go without saying (but I will say it anyway!), make sure you do a test import with a few SKU's before importing your whole catalogue!
e
Thanks mates!!!