Hello,
I’m working on designing a CSV import template for Sales Orders that include lot-numbered assembly items configured as Special Work Order items. These items do not yet have assigned lot numbers, as inventory has not been built.
During testing, I’ve run into an issue: when importing a lot-numbered assembly item that does have available inventory, NetSuite requires a lot number to be specified. However, if I attempt to provide a lot number for items that do not yet exist in inventory, the import fails with an error because the lot number has not been created in the system.
The expected behavior is for these items to trigger Work Orders upon Sales Order creation, without requiring pre-existing lot numbers.
Has anyone successfully handled a similar use case—importing Sales Orders with lot-numbered assembly items that:
- Do not yet have inventory or assigned lot numbers, and
- Are configured as Special Work Order items intended to generate Work Orders?
Any guidance, best practices, or workarounds would be greatly appreciated.
Thank you!