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]%'
Regards,
Vamsi