SELECT t2.docnum,t2.cardname,T2.[CardCode] ,t2.docstatus, T2.[DocDate] AS [Invoice Date], T2.[VatSum] AS [VAT Paid], t2.doctotal as [Invoiced Amount], t0.docdate as [Payment Date], T1.[SumApplied] FROM ORCT T0 INNER JOIN RCT2 T1 ON T0.DocNum = T1.DocNum INNER JOIN OINV T2 ON T1.DocEntry = T2.DocEntry WHERE t2.receiptnum=t1.docnum AND T2.[CardCode] = 'cardcode'
I have hit a fork in the road whilst creating my Days to Pay Query the aim of the Query is to display all the invoices based on a specific partner along with the posting date and payment date (if there is one) however I am unable to produce this whilst still including open invoices, please see the query below. I am also certain that there are open invoices. Thanks in advance.