https://community.sap.com/t5/application-development-and-automation-discussions/sql-transaction-report-by-project/m-p/577038#M22703 <P>Hi</P> <P>I would like the SQL code fro the report "<STRONG>Transaction Report By Project</STRONG>".</P> <P>Going use within Excel. Also would love more detail like '<STRONG>Item Description</STRONG>' but don't know the table this comes from. When data is refreshed all updates the PIVOT.</P> <P>Any help gratefully received, quite new to SAP Business One and just started new job.</P> <P>Thank you.</P> <P>Keith</P> Mon, 23 Oct 2017 14:14:21 GMT Former Member 2017-10-23T14:14:21Z https://community.sap.com/t5/application-development-and-automation-discussions/sql-transaction-report-by-project/m-p/577038#M22703 <P>Hi</P> <P>I would like the SQL code fro the report "<STRONG>Transaction Report By Project</STRONG>".</P> <P>Going use within Excel. Also would love more detail like '<STRONG>Item Description</STRONG>' but don't know the table this comes from. When data is refreshed all updates the PIVOT.</P> <P>Any help gratefully received, quite new to SAP Business One and just started new job.</P> <P>Thank you.</P> <P>Keith</P> Mon, 23 Oct 2017 14:14:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sql-transaction-report-by-project/m-p/577038#M22703 Former Member 2017-10-23T14:14:21Z