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

Notifications

Announcements

No record found.

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)
  • JAngle Profile Picture
    133 on at

    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.

  • Zaid Tariq Profile Picture
    2,274 on at

    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.

  • Verified answer
    Terrance Morgan Profile Picture
    515 on at

    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.

  • Tim E. Profile Picture
    15 on at

    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.

  • Tim E. Profile Picture
    15 on at

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

  • Suggested answer
    Tim E. Profile Picture
    15 on at

    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.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans