Experts,
If I run the below query
select * from OSRD where ItemCode='FEBL9018699' and DocOpenQty<>0, it gives the result like
ItemCode FEBL9018699
DocType 16
DocEntry 47
DocNum 2008015
DocLineNum 1
DocQuty 17.000000
DocOpenQty 1.000000
DocDate 2008-05-31 00:00:00.000
Status 0
SrdType 94
ItemName RV160/270
WhsCode FG
CardCode C0054
CardName ACE MANUFACTURING SYSTEMS LTD.
ManOutOnly N
Direction 0
CreateNew NULL
DataSource I
UserSign 3
Now when I open the Return Document , for item FEBL9018699, the quantity is 17 and if I open target document for this return, it open AR Credit Memo. there also quantity for FEBL9018699 is 17.
Then why DocOpenQty = 1.000000 for the above query?