In NetSuite, some companies requires to source values from an Item Fulfillment to their Invoices. However, this is a current limitation to source values from the Item Fulfillment to the Invoice record as they have no link between them.
On a brighter note, we've come up with a workaround that utilizes a Saved Search and a Custom Field. In this article, we'll guide you on how to this:
Create the Transaction Saved Search:
On the Criteria subtab, input the values below:
- Filter: Type
- Description: is Item Fulfillment
On the Results subtab, input the values below:
- Field: <The field found on your Item Fulfillment>
- Summary Type: Maximum
On the Available Filters subtab, input the values below:
Create a Custom Field on your Invoice:
On the Transaction Body Field page, set the values below:
- Label: <Set your label here>
- Store Value: Unchecked
On the Applies To subtab, set the values below:
On the Validation & Defaulting subtab, input the values below:
- Search: <The Search we created>
- Field: Created From
Results:
Once done, it should now display the values of the field from the Item Fulfillment as seen below:
Item Fulfillment:
Invoice:
Now you know how to source the values from an Item Fulfillment to your Invoices. I hope this helps! 😁
Disclaimer:
This guide is only for scenarios with one Item Fulfillment.
___
Want to learn more about Customization? Visit New to NetSuite: SuiteBuilder & SuiteBundler
Do you have any feedback? Let us know in the comments!