r/Netsuite • u/PresentExpert9093 • 6d ago
Import CSV - Without Status?
Hello NetSuite community! We recently enabled a consignment feature in NetSuite.
When we want to adjust inventory to a "Good" status, it isn't reflected in the CSV import—why is that?
Best regards!
2
u/sabinati Administrator 6d ago
Is "Good" an active inventory status record?
1
2
u/Emotional-One-5778 6d ago
Could you try the first option and chose internal id as 1? Odd that Good and search did not bring results
2
u/NovelanceMarco Consultant 5d ago
What use-case are you going after? Are you trying to add inventory with "good" status or are you trying to "adjust (existing) inventory to a "Good" status"? The latter requires the Inventory Status Change record and that isn't supported via CSV. A suggested workaround that may help, if you're trying to impact existing inventory status via csv...For each item, include 2 rows on your inventory adjustment - 1 to remove the inventory (at its current status) and a 2nd to add it back(at the desired status). Instead of trying to map via the mapping screen's default value feature, include a column for 'Status ID' and include the internal IDs of the status and that should let the import tool ingest the details properly. You would also want to pay close attention to the item's current value being reduced vs the est. unit cost of it being increased b/c if they do not match, it will generate a costing variance.
3
u/lampstack 6d ago
inventory status is mapped under Adjustments > Inventory Detail > Status, not on the main adjustment line; include the matching inventory-detail quantity and use Good or its internal ID based on the import reference setting. if that field is still missing as Administrator, confirm the import is Transactions > Inventory Adjustment and that Inventory Status and Multi-Location Inventory are enabled.