SAP B1 TB report BP display filtered by GL Accounts

[tamartsulaia0]

Hello experts!

My client has specific need. They are using Trial Balance Report from financial module.

As you know, this report displays business partners, their Opening Balance, Debit, Credit and Ending balance. This format of this report is acceptable, only thing they want to change is that they want to filter business partner balances by their control accounts. For example, if business partner has entries on two control accounts, they want to choose which control account to display in Trial Balance. As i know this is not possible in Trial Balance.

Do you have any suggestions which report should we use to cover this issue?
1. Report must include Opening Balance, Debit, Credit, Ending Balance

2. Repost must be filtered with control accounts

I would be very grateful, if you will give me some suggestion which report will cover these two topics.  

[raymond_giuseppi]

Include pictures in post, more user  friendly than attachments

[Felipe_Lima]

Hi @tamartsulaia0 ,

The only SAP standard report whereby you can use control accounts as parameters is the General Ledger report. It has Opening balance, Debit, Credit and Cumulative balance in local, foreign and system currencies. There is also the possibility of summarizing your report by field(s) according to your criteria.

I hope it helps.

*** If this answer resolves your question, kindly consider marking it as accepted. This helps our community by highlighting useful solutions. Thank you! ***

BR,
Felipe

[tamartsulaia0]

Hello! thank you for your answer. General Ledger has only one issue. It does not display ending balance for every customer.

I have attached screenshots.

First one is selection criteria, second one is general ledger. it displays opening balance in "Cumulative Balance LC" field in light grey color. then in Debit/Credit displays turnover for selected period and ending balance is not displayed. 

Report summarizes totals for all customers, in my case, I have displayed only one customer and total of this report is correct, but in real life, customer will choose several business partners, the bottom of this page will contain all data 

[Felipe_Lima]

I managed to get their current (ending) balance by bringing up Debit/Credit (LC) field and summarize by Totals and sort by BP Account, and set Yes to Order and Summary

Unfortunately, it doesn't show the OB. I think you'll need a bespoken report for this.