How to find what batch of item is added in what sale transaction?

AI generated answer (using internal Slack threads):

To find out what batch of item is added in what sale transaction, you would need to create a saved search in NetSuite. Unfortunately, NetSuite does not natively track the exact time an item is added to a sales order. The system notes only capture changes to the line after it is there. However, you can create a saved search to track if the same item has been added to a sales order twice. Here's a general idea of how you can do it: 1. Go to

Reports > New Search

. 2. Select

Transaction

as the record type. 3. In the

Criteria

tab, add a new criterion:

Main Line

is

False

. This will exclude summary lines and only include line items. 4. In the

Results

tab, add the following fields:

Internal ID

(Summary Type:

Group

),

Item

(Summary Type:

Group

), and

Internal ID

(Summary Type:

Count

). 5. In the

Summary

tab, add a new criterion:

Internal ID

(Summary Type:

Count

) is greater than

1

. This will only show items that have been added more than once to the same sales order. Please note that this search will only show sales orders where the same item has been added more than once. It won't show the exact time the item was added. If you need to track the exact time an item is added to a sales order, you would likely need to use SuiteScript to create a custom script that captures this information. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******