Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.