web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

How to configure Excel reports (balance sheet, income statement) that are available within the Actions bar in (business manager) role center?

(0) ShareShare
ReportReport
Posted on by 15

Hi everybody,

Even after extensive research I could not find any hints on how to configure the Excel reports offered in the (business manager) role center. By default, these reports are not compatible with the German accounting standards and useless for German BC customers.

pastedimage1595605260864v1.png

Any help is appreciated.

Regards,

Tim

I have the same question (0)
  • Suggested answer
    Tim E. Profile Picture
    15 on at
    RE: How to configure Excel reports (balance sheet, income statement) that are available within the Actions bar in (business manager) role center?

    Thank you so much Terrance. While I do not use GP but BC the General Ledger Setup is exactly the right place to assign the appropriate schedules for the Excel reports.

  • Tim E. Profile Picture
    15 on at
    RE: How to configure Excel reports (balance sheet, income statement) that are available within the Actions bar in (business manager) role center?

    Thanks Zaid, I don't want to bookmark it but rather configure it.

  • Tim E. Profile Picture
    15 on at
    RE: How to configure Excel reports (balance sheet, income statement) that are available within the Actions bar in (business manager) role center?

    Thanks Josh, but this is a default report and I am wondering if there is something like Account Schedules where I can configure it appropriately to local (german) standards. It's called GuV (Gewinn- und Verlustrechnung) in Germany and I currently have 3 different reports that contain 3 different schemes.

  • Verified answer
    Terrance Morgan Profile Picture
    515 on at
    RE: How to configure Excel reports (balance sheet, income statement) that are available within the Actions bar in (business manager) role center?

    To set up default entries and preferences:

    Open the General Ledger Setup window.

    (Financial >> Setup >> Financial >> General Ledger)

    screenshot

    Enter the next journal entry and budget journal entry numbers. A new journal entry number is assigned each time you save an entry in the Transaction Entry, Clearing Entry or Quick Journal Entry windows. A new budget journal entry is assigned each time you save an entry in the Budget Transaction Entry window.

    The journal entry and budget journal entry number appear on reports as part of your audit trail. You can use these numbers to trace transactions to their original point of entry.

    Choose whether to display account balances as net change or period balance amounts.

    The display method you select will appear throughout Microsoft Dynamics GP. You can change the method in each window where the account balances are displayed. Refer to Understanding net change and period balance for more information.

    Skip the retained earnings entries.

    You need to enter the chart of accounts before specifying a retained earnings account. Later, after you’ve set up posting and fixed allocation accounts, you can refer to Chapter 7, “Retained earnings accounts,” for more information about this entry.

    Choose whether to keep account history, transaction history, budget transaction history, or all three.

    Account history provides account summary balances only. Transaction history includes all transactions posted to an account. Budget transaction history retains the history of budget adjustments. When budget transactions are posted, they move directly to the history table because there is no open table for these transactions. Thus, you must choose an option here if you want to do inquiries on budget transactions after they have been posted.

    You can keep history for an unlimited number of years. This information is updated during the year-end closing process when current-year balances become previous-year balances.

    If you choose to keep history, you can print historical information on financial statements, comparing previous-year amounts to current-year amounts. You also can calculate budgets based on information from the previous year.

    Mark whether to enable users to post to history. If this checkbox is marked, you can post transactions to the most recent history year. For example, you can post-audit adjustments after you have closed the year.

    Mark the Deletion of Saved Transactions option to enable users to delete transactions that are saved, but not posted. If you unmark this option, saved transactions must be voided instead of deleted.

    Mark the Voiding/Correcting of Subsidiary Transactions option to enable saved transactions originating in other modules to be voided or posted transactions originating in other modules to be backed out or backed out and corrected. Voiding saved transactions originating in other modules will not update the transactions in those modules. You must void or delete the originating transactions using the originating modules.

    Mark the Back Out of Intercompany Transactions option to enable intercompany transactions to be backed out.

  • Zaid Tariq Profile Picture
    2,274 on at
    RE: How to configure Excel reports (balance sheet, income statement) that are available within the Actions bar in (business manager) role center?

    Hi,

    I am not sure If I understand you question correctly but you can bookmark the reports so that they always appear in Role Center. If you want these reports to be visible for all the user, then you need to extend the existing Role Center using extensions.

    You can check if you can find any local extension for Germany else the other solution would be to do customization.

  • JAngle Profile Picture
    115 on at
    RE: How to configure Excel reports (balance sheet, income statement) that are available within the Actions bar in (business manager) role center?

    Is there nothing on app source that is more appropriate for that localisation? I'm not familiar with the localisation myself so my answer might not be well rounded.

    Data that is available in excel in general is done with web services. I don't know the specific one's involved for these reports but any tweaking will involve page or query objects presumably. You could look at creating a page or query that provides what you need and then consume the data in excel or power bi. I think the latter is a better option as you have more fluid data modelling for the data format. Excel tends to use table formats so layering in formulas is particular.

    A lot of businesses opt for Jet Reports for this very reason that the out of the box don't meet requirements.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 3,055

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,682 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,209 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans