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.
Is there a way to run a report or search that will give me Inventory by serial/lot code for a specific date.
So far, my system administrators have told me I am out of luck.