SQL query for Business Partners

[bunyodkamalov]

Hello dear SAP experts, I am new to SAP B1 and I need help with SQL query, Business Parner statistics. How can I output in tabular form the following columns that belong to all BPs on the first date of this month up to this date:
GroupCode,
The balance due on the first day of the month,
The sum of invoice DocTotals for this month,
Sum of Incoming Payments from this BP this month,
CurrentAccountBalance,
This BP is the sales person code

Thanks in advance for your help.

[chris_keating]

SAP SQL Anywhere is a database management system. I think you will need to retag your question in order for it to get the attention of users familiar with SAP B1.