Skip to Content

Need a query, how many lotnumber received (In)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 03, 2017 at 07:07 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 03, 2017 at 07:07 AM

    Hi,

    Have you tried with Batch number transaction report?

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded