Receipt Report

[former_member722674]

Hi Team,

Can anyone please help me with this

below is the query for receipt report I would like to join a column call profit center to this query I tried joinning oprc but I am getting profit center as null values please can anyone help me with this

SELECT T0.[CardCode] as CustomerCode, T0.[CardName] as CustomerName, T0.[DocNum] as DocumentNo, T0.[TransId] as TransactionId,T2.[DocNum] as Reference1, T2.[JrnlMemo] AS RowDetails, T1.[SumApplied] as Paidtoinvoice, T0.[DocDate] AS PostingDate, T0.[FinncPriod] FROM ORCT T0 INNER JOIN RCT2 T1 ON T0.[DocEntry] = T1.[DocNum] INNER JOIN OINV T2 ON T2.[DocEntry]=T1.[DocEntry] WHERE T0.[DocDate] >=[%0] and T0.[DocDate] <=[%1] ORDER BY T0.[TransId] ASC