Payment Means Table

[vasileiosfasolis]

Hello to all!

i am interested to make a query that will display the following data

from oinv

1. Invoice No
2. Document Status
3. Posting Date
4. Due Date
5. Customer/Vendor Name
6. Document Total

from payment means

1. Payment Date
2. Total

does anyone know which is the table for payment means?

till now i have created the following

select t0.docnum

,t0.DocStatus

,t0.DocDate

,t0.DocDueDate

,t1.cardname

,t0.DocTotal

from OINV t0

inner join OCRD t1 on t1.CardCode=t0.cardcode

inner join INV6 t3 on t3.DocEntry=t0.docentry

order by t0.DocNum

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this:

SELECT T0.[DocNum], T0.[DocDate], T0.[CardName],T0.[CashSum], T0.[CreditSum], T0.[TrsfrSum],T0.[DocTotal], T2.[DocNum], T2.[DocDate], T2.[CardName], T3.[ItemCode], T3.[Quantity], T3.[LineStatus] FROM ORCT T0 INNER JOIN RCT2 T1 ON T0.DocNum = T1.DocNum left join OINV T2 on t1.docentry = t2.docentry INNER JOIN INV1 T3 ON T2.DocEntry = T3.DocEntry WHERE T0.[DocDate] between [%0] and [%1] GROUP BY T0.[DocNum], T0.[DocDate], T0.[CardName],T0.[CashSum], T0.[CreditSum], T0.[TrsfrSum],T0.[DocTotal], T2.[DocNum], T2.[DocDate], T2.[CardName], T3.[ItemCode], T3.[Quantity], T3.[LineStatus]

Thanks & Regards,

Nagarajan

[vasileiosfasolis · Accepted solution]

it seems to work

i have to make some tests and in case it works i will close the thread and mark you for the whole points naga

thanks a lot!

[kothandaraman_nagarajan · Accepted solution]

Hi,

Welcome.

Regards,

Nagarajan