Skip to Content
avatar image
Former Member

Show list of AR Invoice which has no Sales Order attached to it

Hi,

I need to generate a list of AR invoices which created manually in the system and those invoices normally don't have a sales order attach to them (not converted from sales order).

Any help would be much appreciated. Thanks!


Regards


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2015 at 01:02 PM

    Hi,

    Try the below query

    select v.docnum,v.docdate,v.cardcode,v.CardName  from oinv v where v.docentry in (select v1.DocEntry  from inv1 v1 where v1.BaseType ='-1')

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2015 at 01:13 AM

    Hi,

    Try this query which excludes AR reserve invoice:-

    SELECT t0.docentry,T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName] FROM OINV T0  INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE   T1.[BaseType] = '-1' and  T0.[isIns] = 'N' group by t0.docentry,T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName]

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded