Skip to Content
0

Need a query, how many lotnumber received (In)

Jul 03, 2017 at 05:03 AM

45

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Agustin Marcos Cividanes Jul 03, 2017 at 07:07 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Jul 03, 2017 at 07:07 AM
0

Hi,

Have you tried with Batch number transaction report?

Regards,

Nagarajan

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0