Query Report for Account balance in Business partner Master Data
One of my client requirement is one query report for account balance of business partner master data . Where I need that query to design a crystal report.
I need your help for the below query , where I need some fields that is BP CODE , BP NAME, BP ADDRESS (block, city, country, mobile no, zip code , landline number) , SERIES POSTING DATE, ORIGIN , ORIGIN NO, DETAILS, DEBIT,CREDIT,CUMULATIVE BALANCE, FROM DATE AND TO DATE.
Actually I am unable to find the field names for ORIGIN, CUMULATIVE BALANCE, FROM DATE AND TO DATE.
Kindly help me for write the query for account balance.
SELECT T0.[CardName], T0.[CardType], T1.[Address], T1.[Street], T1.[CardCode], T1.[Block], T1.[ZipCode], T1.[City], T1.[County], T2.[RefDate], T3.[Debit], T3.[Credit], T3.[LineMemo] FROM OCRD T0 INNER JOIN CRD1 T1 ON T0.[CardCode] = T1.[CardCode], OJDT T2 INNER JOIN JDT1 T3 ON T2.[TransId] = T3.[TransId] WHERE T0.[CardCode] ='c20000'
Thanks and Regards,