Is there a way to see the serial numbers in stock on a given date in the past? I'm having trouble adding serial number/lot number to the Physical Inventory Worksheet or Inventory Valuation report, as it does not pull all the serial numbers on stock on that date, just a random selection. I wanted to see if anyone had ideas on another way to do this.