Document open qty

[Former Member]

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?

[Former Member]

Hi Rupa......

I suggest you do not go by Base and Traget Docs through Buttons on Tool Bar try to craete a query where compare the dociments with its DocEntry (Base ANd Target)......

Then only you get exact result.......

Regards,

Rahul

[Former Member]

HI

Did you check the base document for the Returns and its quantity?

I think,the quantity in base document is 18 and you posted returns only for 17 Quantity...

Please check...