Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
How can I run a report for Inventory by lot code for a specific point in time?
I routinely need to run comparisons from NetSuite Inventory On Hand to our Co-Manufacture inventory On Hand. I have no problem obtaining an inventory snapshot, by lot code, for a specific date from our Co-Man. I cannot for the life of me figure out how to get NetSuite to allow me run a report or search for Inventory by lot code for a specific date in the past, only for current inventory.
I have been working around this limitation by gathering the inventory transaction data from the past few months and doing a "Roll Forward" analysis to get me to my desired point in time. However, this leaves me with a mountain of data to sort and filter.
3