Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.