Skip to Content
Former Member
Jul 28, 2014 at 06:49 AM

BP Balance query?


Hi experts,

I need a query that will help me design a report for a customer.

The query should show the journal entry transactions for business partners, that is their debit and credit transactions.

Also the query should help me to design the report and group by the business partners and secondly group by the account name as well.

This query should help me to be able to choose a business partner and the report will show all the business partner's transactions and show all it's

Debit and credit per the account name.

NB: the query I want to see the bp name,the bp code,the account name,the account code, the transition id,debit,credit,remarks,ref1,ref2,ref3.

Please assist me experts.

Urgent help is needed.