Skip to Content
0
Former Member
Jun 13, 2011 at 06:54 AM

Document open qty

45 Views

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?