cancel
Showing results for 
Search instead for 
Did you mean: 

SQL query for Business Partners

bunyodkamalov
Newcomer
0 Kudos
132

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
Product and Topic Expert
Product and Topic Expert
0 Kudos
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.

Accepted Solutions (0)

Answers (0)