get invoice number in item fulfillment using formula

AI generated answer (using internal Slack threads):

To get the invoice number in item fulfillment using a formula, you would need to use scripting as there is no native way to do this in NetSuite without scripting. You can try to get the line item value of a field called

orderdoc

. This field might hold the item fulfillment id. If this doesn't work, then on the before load event of the invoice creation, try to get the line item value of the

line

field. There is a chance that it will contain the item fulfillment id + "_" + line index. However, please note that when you invoice from an item fulfillment, it will invoice the sales order, not the specific fulfillment. If you have two fulfillments that haven't been invoiced on the same sales order, it's going to invoice both. You could have a transform record script written to do this, but expect challenges as this is not a straightforward process. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******