Skip to Content
Former Member
Apr 16, 2013 at 05:22 AM

Batch query correction


Hi friends ,

i need a small correction below query

Select Located, ItemCode,ItemName,BatchNum,WhsCode,Quantity,InDate,CardCode,CardName,BaseType,BaseNum from OIBT


Quantity <> 0

Order By

Located,WhsCode, ItemCode

above query . some others card code value is not picking . because of goods receipt document. some other field batch number create from GRN so it is pick the card code value . some other field batch number create from godds receipt so it is not pick the card code . so where it is showing blank system pick the value from item master data preferred vendor is it possible ? how i create