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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.