Ryan Longenecker
02/11/2025, 4:06 AMCeligo AI
02/11/2025, 4:07 AMAI generated answer (using internal Slack threads):Based on the conversations, it seems that breaking out each lot number into their own line on a report is not directly possible through the standard NetSuite inventory reports. However, you can achieve this by creating a custom transaction saved search or using SuiteQL if you are comfortable with it. For the transaction saved search, you would need to set the 'Main Line' to false to get line/row level details. You can then add a results column of "Line Sequence Number" with a summary type of "Count". Then group the other columns you need to display. For SuiteQL, you can use a modified version of Tim's Suitelet to get a report like you mentioned. Here is the link to the Suitelet: https://timdietrich.me/blog/netsuite-inventory-balance-history-suitelet/ ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
02/11/2025, 4:07 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823422372
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.807456791
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.806437254
Celigo AI
02/11/2025, 4:07 AM