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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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