Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NetSuite has launched SuiteSuccess Wholesale Distribution Edition, in Japan. Please join us the webinar on February 12 that introduces NetSuite solution with demos and case studies for Wholesale Industry.
Register Now
CSV Import for Serialized Inventory Adjustment
I'm trying to import an inventory adjustment for serialized items by CSV and getting an error.
My mapping is as follows:
Hardcoded: Adjustment Account, Subsidiary, Date, Adjustment Location
- External ID → External ID
- Item → Adjustments: Item
- Location (Line) → Adjustments: Location
- Qty → Adjustments: Adjust Qty By (Req)
- Serial → Inventory Detail: Serial/Lot Number
When I run the import, I get the error "Please enter value(s) for: Serial/Lot Number" for every line item. What am I missing? Any help would be appreciated.
[Edit 10/12/2023]
I've seen the recommended workaround to map Serial → Inventory Detail: Receipt Inventory Number instead of Serial/Lot Number. When I do this I get the error "Inventory Revaluation is no longer the first transaction in the item's history". Standard cost revaluation has been run on all items for relevant locations so it should be the only thing in the item's history.