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.