When using SuiteScript to create an Item Fulfillment record, the record.transform function is commonly employed to generate an Item Fulfillment from a Sales Order.
Consider the following example where we fulfill a Sales Order with internal ID 2345:
var ifRec = record.transform({
fromType: record.Type.SALES_ORDER,
fromId: 2345,
toType: record.Type.ITEM_FULFILLMENT,
isDynamic: true,
});
Under normal circumstances, this code works without issues. However, if the Intercompany Cross-Subsidiary Fulfillment feature is enabled, you might encounter the following error:
Name: "VALID_LINE_ITEM_REQD"
Message: "You must have at least one valid line item for this transaction."
This error arises regardless of whether the Automatic Location Assignment feature (found under Setup -> Company -> Enable Features, in the Transactions tab) is enabled. When Automatic Location Assignment is turned on, the code works as expected. But when it’s turned off, an error occurs.
The error is caused by the absence of a required location for the line item during the transformation. In the NetSuite UI, selecting a location is mandatory to generate the Item Fulfillment. When Intercompany Cross-Subsidiary Fulfillment is enabled, the location becomes a required transformation parameter.
You can confirm this behavior in the NetSuite documentation under the section Transforming Sales Orders with the Intercompany Cross-Subsidiary Fulfillment Feature. It states: If the Intercompany Cross-Subsidiary Fulfillment feature is enabled in your account, inventorylocation may become a required transformation parameter when transforming Sales Orders to Item Fulfillments.
To resolve this issue in SuiteScript, you can use the defaultValues parameter to specify a default location for the transformation. This ensures the Item Fulfillment record is generated successfully.
Here’s how you can adjust your code:
var ifRec = record.transform({
fromType: record.Type.SALES_ORDER,
fromId: 2345,
toType: record.Type.ITEM_FULFILLMENT,
isDynamic: true,
defaultValues: {
inventorylocation: 2 // Replace with your location ID
}
});
By setting the inventorylocation using the defaultValues parameter, you can seamlessly transform a Sales Order into an Item Fulfillment even when the Intercompany Cross-Subsidiary Fulfillment feature is enabled, and Automatic Location Assignment is disabled. This approach ensures your script adheres to NetSuite’s requirements for managing locations in cross-subsidiary transactions.
About Us
Concentrus is a leading provider of innovative cloud-based enterprise resource planning (ERP) solutions, including NetSuite. Our team of NetSuite experts offers a range of services, including NetSuite price analysis, NetSuite training, and NetSuite integration services.
Our goal is to help businesses of all sizes maximize their investment in NetSuite by providing expert NetSuite cost optimization and implementation strategies. With years of experience as a NetSuite partner, our NetSuite administrators and NetSuite consultants are well equipped to help businesses of all sizes with their NetSuite consulting needs.
Whether you're looking for a NetSuite consultant to help with your NetSuite implementation or you need ongoing NetSuite support, Concentrus is here to help.
Read About Our Implementation Methodology
Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos