Skip to Content
avatar image
Former Member

Sales Invoices with Items in Draft

HI experts,

Can you please let me know how can it get the list of items which are there in draft sales invoices.

If you have any helpful query, please share it with me.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 29, 2014 at 06:00 PM

    Hi

    Try the below query

    SELECT T0.[DocNum], T0.[DocDate],T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[LineTotal] FROM ODRF T0  INNER JOIN DRF1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T0.[ObjType] = 13

    With Regards

    Balaji Sampath

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 30, 2014 at 01:08 AM

    Hi,

    Try:

    SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[CardCode], T0.[CardName], T0.[NumAtCard], T1.[ItemCode], T1.[Dscription], T1.[Quantity] FROM ODRF T0  INNER JOIN DRF1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[ObjType]  = 13

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 01:21 AM

    Hi,

    Try:

    SELECT T1.[ItemCode], T1.[Dscription], SUM(T1.[Quantity]) 'QTY', SUM(T1.[LineTotal]) 'Amount'

    FROM ODRF T0  INNER JOIN DRF1 T1 ON T0.[DocEntry] = T1.[DocEntry]

    WHERE T0.[ObjType] = 13

    GROUP BY T1.[ItemCode], T1.[Dscription]

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded