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

[Former Member]

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

[Former Member · Accepted solution]

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')

[Former Member · Accepted solution]

Hi,

Try:

select v.docnum,v.docdate,v.cardcode,v.CardName

from oinv v

where v.docentry not in (select v1.DocEntry  from inv1 v1 where v1.doctype != '17')

order by v.cardname

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks for your help! Bharathiraja

Regards

Betsy

[kothandaraman_nagarajan]

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.

[Former Member]

Hi Nagarajan,

Thanks for your help! This is exactly what I want!

Thank you for your time and expertise

Regards

Betsy

[Former Member]

Hi,

If I want to add Invoice Total Amount after VAT, how can I do this?

Thanks & regards