Can anyone give me an idea on how I might design a report to figure out how long our parts sit in the receiving/inspection area before they are moved out? I know I can use the PartTran table and look at PUR-INS and INS-xxx transactions but that could end up taking a HUGE amount of time to generate since I’d have to link PartTran to PartTran (I think) in order to figure it out. Has anyone else ever designed a report that could tell how long a part has been sitting somewhere?
You should find all you need on the RcvDtl table:
Just a little subtraction and you should have it