Skip to Content
0

Invoice report

May 08, 2017 at 12:49 PM

110

avatar image

Hi Experts

I need a Invoice Report how to join Ar Invoice + Ar credit note is there any link between these two

Thanks

Vinoth

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Balaji Selvaraj May 08, 2017 at 03:11 PM
0

Hi Vinoth,

SELECT * FROM OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN ORIN T2 ON T1.[TrgetEntry] = T2.[DocNum]

Regards:

Balaji

Share
10 |10000 characters needed characters left characters exceeded
Jitin Chawla
May 09, 2017 at 10:10 AM
0

Hi,

Check this :

select T0.DocNum as 'AR Invoice Num', T2.DocNum as 'AR Credit Num'

from OINV T0 INNER JOIN INV1 T1 on T1.DocEntry = t0.DocEntry INNER JOIN ORIN T2 on T2.DocEntry = T1.TrgetEntry

WHERE TargetType = '14'

Regards,

Jitin

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K May 14, 2017 at 12:38 PM
0

Hi,

Try this link,

OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] left join RIN1 T2 on T2.[BaseEntry] = T1.[DocEntry] and T2.[BaseLine] = T1.[LineNum] INNER JOIN ORIN T3 ON T2.[DocEntry] = T3.[DocEntry]

Regards,

Nagarajan

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi

while executing the query its shows wrong result compare with sales analysis report for invoice.

invoice raised values not showing in output

invoice and credit not raised values only displaying.

while comparing with sales analysis it has to match

Thanks

Vinoth

0