Need a query, how many lotnumber received (In)

[MD1]

Hi All,

Need a query, how many lotnumber received (In) .

Example

ItemCode, ItemName, Vendor Name,No of LotNumber, Lotnumber,Qty ,Uom,

001 XYZ ABC 2 00001 100 kg

001 XYZ ABC 2 , 00002 20 kg

Thanks

Danish

[kothandaraman_nagarajan]

Hi,

Have you tried with Batch number transaction report?

Regards,

Nagarajan

[MD1]

ITEM WISE MAX BATCH NUMBER QUERY IS REQ ALONG WITH IN QTY.

[agustin_marcoscividanes]

Hi

try this query:

SELECT T0.itemcode, T0.itemname, T0.cardcode, T1.distnumber, T2.quantity

FROM OITM T0 innerjoin OBTN T1 on T0.itemcode = T1.itemcode

innerjoin OBTQ T2 on T1.sysnumber = T2.sysnumber and T1.itemcode = T2.itemcode

Kind regards.