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.
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.