I am attempting to create a Month end inventory snapshot for an Inventory management System, I am building. I am attempting to get the end of month quantity for each item in the ImInvTrx, but I am finding duplicate records, same item_no, trx_dt, trx_time, line_no, and doc_type. This is a problem, as my SQL cannot pull an quantity, unless I can specify the exact row. I can preproces the ImInvTrx, and select distinct records, but am I missing another field that will uniquely identify a record by date,time, etc.