Skip to Content
0
Former Member
Nov 07, 2012 at 05:09 AM

Batch query in issue for production

510 Views

hi friends,

I need below structure query

item code item name batch number batch qty location lot number issued qty from the production balance

3234QA key 11254545 300 A101 20120611 133 167

is it possible.

i create below query

SELECT T0.[ItemCode], T0.[ItemName], T0.[BatchNum], T0.[Located], T0.[Quantity] FROM OIBT T0 but issue for production qty not come

onle based issue for production . goods issue is not needed.