Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. 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.