Skip to Content
0
Former Member
Jul 21, 2012 at 09:52 AM

Dispatched serial number query

17 Views

Dear experts,

I need query which give information of unavailable serial numbers with following details

Item Code, Item Description ,Varient Number [U_VarNum - UDF column of Item Master], Frame [U_Frame - UDF column of Item Master], Serial Number, Manufacturing Serial Number, Admission Date, date of delivery, Delivery No., Status.

The selection criteria should be of delivery date.

Thanks & Regards,

Akshata