Skip to Content
Former Member
Jan 23, 2010 at 07:01 AM

Amount to Reconcile in Debtors Outstanding balance query


Hi Experts.

Below is the query i used to run Debtors Outstanding Balance. and its working fine but we need Amount To Reconcile Debit and Amount To Reconcile Credit Fields also..

so pls modify this query and help me...

SELECT T0.[TransId],T0.[RefDate], T0.[TransType] AS 'Origin Doc.Type', T1.[BaseRef] AS 'Origin Doc.No', T1.[ShortName], T2.[CardName], 
T1.[Account], T1.[ContraAct], T1.[CreatedBy], T1.[Debit], T1.[Credit], T1.[BalDueDeb], T1.[BalDueCred], T1.[LineMemo]
FROM dbo.OJDT T0  
INNER JOIN dbo.JDT1 T1 ON T0.TransId = T1.TransId
INNER JOIN dbo.OCRD T2 on T2.CardCode = T1.[ShortName]
WHERE T1.[MthDate] IS NULL AND T2.[CardName] LIKE '[%0]%'