I’m attempting to create a Generic Inquiry based on the INLotSerialStatus DAC.
However, it only shows me some of the records that are present in the database.
If I use the DAC schema browser and look at the DAC source data, I see about 2,100 fewer records than what are in the database table.
I’ve compared a number of db records and have been unable to find a commonality between records that don’t show in the DAC.
Is this a bug, or is there logic that filters INLotSerialStatus records and is intended to hide them from the DAC based on certain criteria?
As far as I can tell, all the records that don’t show in the DAC, are records that have production orders that haven't been completed yet. However, there are plenty of records for items that are in various stages of production, that do show in the DAC.