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
Transform sales order with Inventory Detail Subrecord to fulfillment via scripting
I've run into a problem with fulfilling orders where the lot/serial numbers have been selected on the sales order.
The problem happens when there is less than 2X the available inventory of that inventory number. For example: I have 8 left of a lot numbered item. The sales order is for all 8 of them with the lot number selected on the SO. I get the error "Invalid issueinventorynumber reference key XXX." However, when the order is for 4 or fewer of that item, there is no error.
NetSuite seems to be putting the 8 committed items of that lot on hold so when I try to specify the inventory details of the fulfillment there is not enough inventory to fulfill 8 since only 0 are available. It's not smart enough to notice that the 8 lot items are committed to THIS order.